Indexes and EXPLAIN

B-Tree Index

• splits
• fill factor
• covering indexes

Index Only Scan vs Index Scan

• visibility map role

EXPLAIN (ANALYZE, BUFFERS) Node Types

• Seq Scan
• Index Scan
• Bitmap Heap Scan
• Hash Join
• Merge Join
• Nested Loop