Lesson 3.210mIntermediate7.6k students
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.
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
Your notes for this lesson will appear here.