Technologies/PostgreSQL/postgresql.last_vacuum
PostgreSQLPostgreSQLMetric

postgresql.last_vacuum

Last vacuum time
Dimensions:None
Available on:DatadogDatadog (2)Native (2)PrometheusPrometheus (1)
Interface Metrics (5)
DatadogDatadog
Last time at which the toast table of this table was vacuumed by the autovacuum daemon. This metric is tagged with db, schema, table.
Dimensions:None
DatadogDatadog
Last time at which the toast table of this table was manually vacuumed (not counting VACUUM FULL). This metric is tagged with db, schema, table.
Dimensions:None
Native
Time of last vacuum
Dimensions:None
Native
Time of last automatic vacuum
Dimensions:None
PrometheusPrometheus
Last time at which this table was vacuumed by the autovacuum daemon
Dimensions:None
Sources
postgresql.toast.last_autovacuum_agegithub.com
postgresql.toast.last_vacuum_agegithub.com
last_vacuumgithub.com
stat_user_tables_last_autovacuumgithub.com

Technical Annotations (12)

Configuration Parameters (1)
autovacuum_vacuum_scale_factorrecommended: 0.01
vacuum at 1% dead rows instead of default 20% to maintain visibility map for index-only scans
CLI Commands (2)
VACUUM citiesremediation
ALTER TABLE cities SET (autovacuum_vacuum_scale_factor = 0.01);remediation
Technical References (9)
autovacuumcomponentpgwatchcomponentpg_stat_user_tablescomponentvisibility mapcomponentheapcomponentMVCCprotocolxminconceptxmaxconceptVACUUMcomponent
Related Insights (4)
Autovacuum falling behind on tables causes bloat accumulationwarning
▸
Autovacuum lag causes bloat and planner estimate degradationwarning
▸
Index-only scans fail when visibility map has dead rows/pageswarning
▸
Dead tuples accumulation indicates insufficient VACUUM frequencywarning
▸