Build the Habit of Reading Query Plans on Queries That Are Not Slow
Plan reading is a recognition skill, and recognition comes from volume, not from one careful reading under pressure. The way people get good at it is to EXPLAIN ANALYZE queries that are already fast, predict the plan before running it, and check whether the estimated and actual row counts agreed; a few minutes a day for a month builds the instinct. Keep a small file of plans you have understood, with the sentence that explains each one, so the shapes become familiar before the night you need them.
Questions this Concept answers
- Why does the skill come from volume rather than from one careful reading?
This Concept is waiting for its first lesson!
Plan reading is a recognition skill, and recognition comes from volume, not from one careful reading under pressure. The way people get good at it is to EXPLAIN ANALYZE queries that are already fast, predict the plan before running it, and check whether the estimated and actual row counts agreed; a few minutes a day for a month builds the instinct. Keep a small file of plans you have understood, with the sentence that explains each one, so the shapes become familiar before the night you need them.
Are you a teacher? Sign in to start contributing.
Sign In