VIDEO / PostgreSQL / Databases
PostgreSQL Indexes Explained
A visual mental model for indexes, scans, selectivity, and query planning.
PostgreSQLDatabases
- DURATION
- 15:42
- PUBLISHED
- Aug 15, 2026
- CHAPTERS
- 4
- TOPICS
- PostgreSQL · Databases
VIDEO / CHAPTERS
Inside this explanation
- 00:00Table scans
- 03:18Inside a B-tree
- 08:06Selectivity and cost
- 12:14Reading EXPLAIN
The picture
We build an index from the leaf pages upward, then follow the planner as it compares index and sequential access.
- Ordered keys
- Heap lookups
- Cost estimates
Apply it
The final chapter turns the mental model into a repeatable query-tuning workflow.