Series · 3 phases
PostgreSQL Indexes, From Zero
What an index really is, how to read the query planner, and how to design indexes that actually get used. Three phases, each with a short quiz.
Log in to save your quiz results and track progress.
- 1
Tables, heap pages, sequential scans, and the B-tree that lets Postgres skip almost all of them.
- 2
Seq Scan, Index Scan, Bitmap Heap Scan: what each plan node means and how to tell if your index is working.
- 3
Column order in multi-column indexes, indexing only the rows you query, and when to stop adding indexes.