PostgreSQL documentation (opens in a new tab)
The official reference for the tools used in this lesson.
Link
Reading EXPLAIN ANALYZE
The plan tells you what the database did and what it expected. A large gap between estimated and actual rows is usually the real problem.
Lesson 3.210m 17sIntermediate7.6k students
Lesson length
10:17What this lesson covers
- Read a plan from the innermost node outwards
- Spot sequential scans that should be index scans
- Compare estimated against actual row counts
This lesson sits in Query Performance, part of PostgreSQL for Developers. It assumes what came before it and leads directly into the next lesson in the module.
In this lesson you will
- Read a plan from the innermost node outwards
- Spot sequential scans that should be index scans
- Compare estimated against actual row counts
Resources
Personal notes are coming soon.