Technologies/PostgreSQL/backend_xmin
PostgreSQLPostgreSQLMetric

backend_xmin

Backend 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 (3)

CLI Commands (2)
SELECT * FROM pg_stat_activity WHERE age(backend_xid) > threshold OR age(backend_xmin) > threshold;diagnostic
SELECT pg_terminate_backend(pid);remediation
Technical References (1)
pg_stat_activitycomponent
Related Insights (1)
Long-running transactions prevent vacuum from advancing relfrozenxidcritical
▸