Reading Execution Plans
Three parts on turning a plan from a wall of text into a diagnosis — which EXPLAIN variant answers which question, the order to read a plan tree in, and the one comparison that localizes most problems.
The examples use PostgreSQL 18, but the reading order and the estimate-versus-actual comparison transfer to any cost-based optimizer. Read the parts in order: each one assumes the previous.
In this series
No published parts yet.