Index-Only Scan — answer from the index, skip the heap when safe

← all topics
SELECT email FROM users WHERE email LIKE 'a%';
Index (idx_users_email) — leaf entries
Visibility Map (1 bit per heap page)

V = all tuples on page are visible to all transactions.
· = page was recently modified — heap visit required.

Heap (only pages we must still visit)