Technologies/PostgreSQL/postgresql.vacuum.num_dead_tuples
PostgreSQLPostgreSQLMetric

postgresql.vacuum.num_dead_tuples

Dead tuples during vacuum
Dimensions:None
Available on:DatadogDatadog (1)Native (1)PrometheusPrometheus (1)
Interface Metrics (3)
DatadogDatadog
Number of dead tuples collected since the last index vacuum cycle. This metric is tagged with db, table, phase.
Dimensions:None
Native
num_dead_tuples statistic from pg_stat_progress_vacuum
Dimensions:None
PrometheusPrometheus
Current number of dead tuples found so far.
Dimensions:None
Sources
postgresql.vacuum.num_dead_tuplesgithub.com
num_dead_tuplesgithub.com
stat_progress_vacuum_num_dead_tuplesgithub.com

Technical Annotations (5)

Configuration Parameters (3)
autovacuum_vacuum_scale_factorrecommended: 0.05-0.1
percentage of table size before triggering vacuum
autovacuum_max_workersrecommended: 5-10
concurrent autovacuum processes
autovacuum_vacuum_cost_limitrecommended: 500-1000
controls autovacuum aggressiveness
Technical References (2)
autovacuumcomponentMVCCconcept
Related Insights (1)
Autovacuum lag causes table bloat and performance degradationwarning
▸