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 12
- option
SKIP_LOCKED
added (commit 803b1301)
- option
- PostgreSQL 11
- syntax
ANALYZE (option [, ...] )
added (commit 854dd8cf)
- syntax
- PostgreSQL 8.2
- takes a ShareUpdateExclusiveLock (previously: AccessShareLock) on the table being analyzed (commit da7540b9)
- PostgreSQL 7.2
- added (commit f905d65e)
References
- PostgreSQL documentation: ANALYZE