Skip to main content
Journey Uncommon Logo
JourneyUncommon
hardSQLcovering indexesSingle-choice MCQ

An index-only scan in EXPLAIN ANALYZE shows 'Heap Fetches: 41203' even though every needed column is in the index. What is the underlying cause?

Index Only Scan using idx_cov on events (actual rows=120000 loops=1) Index Cond: (tenant_id = 7) Heap Fetches: 41203