Technologies/PostgreSQL/postgresql.relation.xmin
PostgreSQLPostgreSQLMetric

postgresql.relation.xmin

Relation transaction xmin
Dimensions:None
Available on:Native (1)DatadogDatadog (1)
Interface Metrics (2)
Native
backend_xmin statistic from pg_stat_replication
Dimensions:None
DatadogDatadog
Transaction ID of the latest relation's modification in pg_class. This metric is tagged with db, schema, table
Dimensions:None
Sources
backend_xmingithub.com
postgresql.relation.xmingithub.com

Technical Annotations (4)

Configuration Parameters (1)
autovacuum_freeze_max_agerecommended: 200000000
Default maximum age before forced vacuum to prevent wraparound; can only be set at server start
Technical References (3)
pg_class.relfrozenxidcomponenttransaction ID wraparoundconceptpg_xactfile path
Related Insights (1)
Transaction ID wraparound forces emergency autovacuum despite disabled autovacuumcritical
▸