What is a covering index / index-only scan?

Answer preview

A covering index contains every column a query needs, so the database answers it from the index alone and never touches the table. PostgreSQL calls this an index-only scan; it typically removes one random heap read per returned row.…