Skip to content

Glossary: PostgreSQL Beyond the Basics

ANALYZE

A command that samples a table and stores the statistics the planner uses for row estimates. Don't confuse it with the `ANALYZE` option of EXPLAIN, which actually runs the statement.

Where the book teaches it

Related terms

Statistics targetEXPLAIN