Technologies/PostgreSQL/database_wraparound_age_datminmxid
PostgreSQLPostgreSQLMetric

database_wraparound_age_datminmxid

Datminmxid wraparound age
Dimensions:None
Available on:PrometheusPrometheus (1)
Interface Metrics (1)
PrometheusPrometheus
Age of the oldest multi-transaction ID that has been replaced with a transaction ID.
Dimensions:None

Technical Annotations (8)

Configuration Parameters (1)
autovacuum_multixact_freeze_max_agerecommended: 400000000
Default maximum age before forced vacuum to prevent multixact wraparound; can only be set at server start
Technical References (7)
VACUUMcomponentcheck_postgrescomponenttransaction ID wraparoundconceptpg_class.relminmxidcomponentmultixact ID wraparoundconceptpg_multixact/membersfile pathpg_multixact/offsetsfile path
Related Insights (2)
Transaction ID wraparound prevents new transactions and causes database shutdowncritical
Multixact ID wraparound forces emergency autovacuum despite disabled autovacuumcritical