row estimate

The planner's guess at how many rows a step of a query will produce, used to choose the plan.

In more detail

PostgreSQL's EXPLAIN ANALYZE prints estimated rows beside actual rows. A large mismatch means the planner misunderstands the data, often because its statistics are out of date, and may be choosing a poor plan; the ANALYZE command refreshes them.

Related terms

Taught in

References