Technologies/PostgreSQL/postgresql.sessions.idle_in_transaction_time
PostgreSQLPostgreSQLMetric

postgresql.sessions.idle_in_transaction_time

Idle in 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 (8)

Configuration Parameters (1)
idle_in_transaction_session_timeoutrecommended: 30min
prevents indefinite idle transactions that block autovacuum
CLI Commands (2)
SELECT count(*) filter (where state = 'idle in transaction') as idle_in_transaction FROM pg_stat_activity;diagnostic
SELECT * FROM pg_stat_activity WHERE state = 'idle in transaction'diagnostic
Technical References (5)
autovacuumcomponentdead tuplesconceptpg_stat_activitycomponenttransactionconceptlock contentionconcept
Related Insights (4)
Idle transactions prevent autovacuum and cause table bloatwarning
▸
Idle transactions hold locks and block operationscritical
▸
Long-running transactions hold locks and block other operationswarning
▸
Long-running transactions cause lock queue buildupwarning
▸