Glossary: PostgreSQL Beyond the Basics
Estimate vs actual
Also written: row estimate, estimated rows
The comparison of the planner's guessed `rows=` with the real rows in EXPLAIN ANALYZE. A gap of 10× or more is the usual reason for a bad plan.
Glossary: PostgreSQL Beyond the Basics
Also written: row estimate, estimated rows
The comparison of the planner's guessed `rows=` with the real rows in EXPLAIN ANALYZE. A gap of 10× or more is the usual reason for a bad plan.