Postgres will look up an index only if it is worthwhile to look up an index. It will simply use regular row fetching otherwise. https://thoughtbot.com/blog/why-postgres-wont-always-use-an-index