Technologies/PostgreSQL/autovacuum_timestamp
PostgreSQLPostgreSQLMetric

autovacuum_timestamp

Autovacuum start time
Dimensions:None
Available on:PrometheusPrometheus (1)
Interface Metrics (1)
PrometheusPrometheus
Start timestamp of the vacuum process in seconds
Dimensions:None
Sources
stat_activity_autovacuum_timestamp_secondsgithub.com

Technical Annotations (12)

Configuration Parameters (2)
autovacuum_vacuum_cost_delay
Controls delay between vacuum cost limit checks to optimize performance
autovacuum_vacuum_cost_limit
Sets cost limit before autovacuum sleeps to balance performance impact
CLI Commands (3)
SELECT schemaname, relname, n_dead_tup, n_live_tup, ROUND((n_dead_tup::float / NULLIF(n_live_tup + n_dead_tup, 0)) * 100, 2) AS dead_tuple_percent, last_autovacuum, autovacuum_count FROM pg_stat_user_tables WHERE n_dead_tup > 1000 ORDER BY n_dead_tup DESC;diagnostic
SELECT name, setting FROM pg_settings WHERE name LIKE 'autovacuum%';diagnostic
VACUUM ANALYZE your_table_name;remediation
Technical References (7)
autovacuumcomponentpgwatchcomponentpg_stat_user_tablescomponentn_dead_tupcomponentdead tuplesconcepttable bloatconcepttransaction ID wraparoundconcept
Related Insights (3)
Autovacuum falling behind on tables causes bloat accumulationwarning
▸
Dead tuple accumulation causes table bloat and performance degradationwarning
▸
High autovacuum duration causes table bloat and performance degradationwarning
▸