ANALYZE

A utility command for collating table statistics

ANALYZE is a utility command for collating statistics about database tables and columns.

ANALYZE was added in PostgreSQL 7.2.

Monitoring ANALYZE progress

Since PostgreSQL 13,  the progress reporting view pg_stat_progress_analyze provides a way of monitoring the status of an ANALYZE operation.

Change history

  • PostgreSQL documentation: ANALYZE

Categories

SQL command, Utility command

See also

VACUUM, pg_stat_progress_analyze