Index Scan — B-tree traversal + heap fetches

SELECT * FROM users WHERE email = 'ada@pg.dev';

B-tree index (idx_users_email)

root · [m]

[a..f]

[g..l]

[m..r]

[s..z]

leaf: a..f

Heap (physical pages)