Technologies/PostgreSQL/idle_in_transaction_time
PostgreSQLPostgreSQLMetric

idle_in_transaction_time

Idle transaction time
Dimensions:None
Available on:Native (1)DatadogDatadog (1)
Interface Metrics (2)
Native
Time spent idle in transactions (ms)
Dimensions:None
DatadogDatadog
Time spent idling while in a transaction in this database, in milliseconds (this corresponds to the states idle in transaction and idle in transaction (aborted) in pg_stat_activity). This metric is tagged with db.
Dimensions:None
Sources
idle_in_transaction_timegithub.com
postgresql.sessions.idle_in_transaction_timegithub.com

Technical Annotations (2)

Configuration Parameters (1)
idle_in_transaction_session_timeoutrecommended: 300s
Auto-terminate transactions idle for more than 5 minutes
Technical References (1)
pg_stat_activitycomponent
Related Insights (2)
Idle-in-transaction connections block vacuum and hold lockswarning
▸
Long-running transactions hold locks and block other operationswarning
▸