Technologies/PostgreSQL/n_mod_since_analyze
PostgreSQLPostgreSQLMetric

n_mod_since_analyze

Rows modified since analyze
Dimensions:None
Available on:Native (1)PrometheusPrometheus (1)
Interface Metrics (2)
Native
Rows modified since last analyze
Dimensions:None
PrometheusPrometheus
Estimated number of rows changed since last analyze
Dimensions:None
Sources
n_mod_since_analyzegithub.com
stat_user_tables_n_mod_since_analyzegithub.com

Technical Annotations (3)

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 (1)
ANALYZEremediation
Related Insights (2)
Stale statistics from delayed ANALYZE affect query planningwarning
▸
Missing statistics on partitioned tables causes poor query planswarning
▸