What is index-only scan?

An index-only scan retrieves all required data directly from the index without accessing the table.

In an index-only scan, the database satisfies a query entirely from the index structure. This works when all selected columns exist in the index and visibility checks confirm tuple validity (e.g., PostgreSQL visibility map). It significantly reduces I/O and improves performance.