Tech10 min
Database Indexes: Why Postgres Ignores the One You Added
A database index is a sorted copy of one or more columns that turns a full table scan into a handful of page fetches. The part nobody explains is why the index you already have sits there unused while your query crawls. Usually it is the way the query is written, not the absence of an index.
postgresqldatabase-indexquery-performance