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.
- 10m
- Intermediate
Video by Hussein Nasser · YouTube
Check your understanding
3 questions. Unlocks when you finish the video.
Overview
What 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
Your notes will live here
Note taking is not available yet. Nothing you type would be saved, so the tab stays read-only for now.