ANALYZE

A command that gathers statistics about the values in tables, which the query planner uses to estimate row counts.

In more detail

PostgreSQL runs it automatically in the background and SQLite runs it when asked. As an option, EXPLAIN ANALYZE instead runs the query for real and reports actual rows and timings next to the estimates.

Related terms

Taught in

References