pg_stat_database.idle_in_transaction_time
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)
Reading PG 18·Select a recorded version
- View
- pg_stat_database
- Field
- idle_in_transaction_time
- SQL type
- double precision
- Units named in the field definition
- milliseconds
- Reset observation
- Time at which these statistics were last reset
- documented
- true
- field
- idle_in_transaction_time
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT idle_in_transaction_time FROM pg_catalog.pg_stat_database;
- source only
- false
- sql type
- double precision
- units mentioned
- milliseconds
- view
- pg_stat_database
Definition PG 18
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)
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f