↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: Index-only scans

Also known as "covering indexes", allows data in indexes to satisfy queries where all columns in a given query are covered by the index. This removes the requirement of having to visit the table pages, which was required previously to get visibility information, but now the visibility map is used instead.