Technologies/PostgreSQL/long_running_transaction_oldest_timestamp
PostgreSQLPostgreSQLMetric

long_running_transaction_oldest_timestamp

The current maximum transaction age in seconds
Dimensions:None
Available on:PrometheusPrometheus (1)
Interface Metrics (1)
PrometheusPrometheus
The current maximum transaction age in seconds
Dimensions:None
Sources
long_running_transactions_oldest_timestamp_secondsgithub.com

Technical Annotations (6)

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 (4)
pgAdmincomponentcheck_postgrescomponentpg_cancel_backend()componentpg_stat_activitycomponent
Related Insights (3)
Long-running queries block other operations and hold lockswarning
▸
Long-running transactions hold locks and block other operationswarning
▸
Long-running transactions prevent vacuum from advancing relfrozenxidcritical
▸