db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

Index-only scans and Heap Fetches

An index-only scan skips the heap only for pages the visibility map marks all-visible. The updates just cleared some bits.

task

Bring Heap Fetches to 0 for the query below, then EXPLAIN (ANALYZE, COSTS OFF, TIMING OFF, SUMMARY OFF) it.

hints