EXPLAIN ANALYZE
EXPLAIN ANALYZE actually runs the query and reports per-node actual rows, loop counts, timing, and buffer/IO activity alongside the estimates. A large gap between estimated and actual rows at any node is the primary signal that the optimizer chose the plan on bad information.
This Concept is waiting for its first lesson!
EXPLAIN ANALYZE actually runs the query and reports per-node actual rows, loop counts, timing, and buffer/IO activity alongside the estimates. A large gap between estimated and actual rows at any node is the primary signal that the optimizer chose the plan on bad information.
Are you a teacher? Sign in to start contributing.
Sign In