Technologies/PostgreSQL/last_analyze
PostgreSQLPostgreSQLMetric

last_analyze

Last analyze time
Dimensions:None
Available on:DatadogDatadog (2)Native (1)PrometheusPrometheus (1)
Interface Metrics (4)
DatadogDatadog
Last time at which this table was manually analyzed. This metric is tagged with db, schema, table.
Dimensions:None
DatadogDatadog
Last time at which this table was analyzed by the autovacuum daemon. This metric is tagged with db, schema, table.
Dimensions:None
Native
Time of last analyze
Dimensions:None
PrometheusPrometheus
Last time at which this table was analyzed by the autovacuum daemon
Dimensions:None
Sources
postgresql.last_analyze_agegithub.com
postgresql.last_autoanalyze_agegithub.com
last_analyzegithub.com
stat_user_tables_last_autoanalyzegithub.com

Technical Annotations (9)

Configuration Parameters (2)
autovacuum_analyze_thresholdrecommended: 50
Minimum modified tuples to trigger analyze; combine with scale factor
autovacuum_analyze_scale_factorrecommended: 0.1
Default 10% of table size; reduce for large tables to analyze sooner
CLI Commands (4)
VACUUMremediation
ANALYZEremediation
SELECT relname, last_analyze, last_autoanalyze FROM pg_stat_user_tables WHERE relname = 'users';diagnostic
ANALYZE users;remediation
Technical References (3)
pg_stat_user_tablescomponentautovacuumcomponentdead tuplesconcept
Related Insights (3)
Bloated tables with dead rows skew performance metrics and waste storagewarning
▸
Stale statistics cause poor query planswarning
▸
Stale statistics from delayed ANALYZE affect query planningwarning
▸