pg_stat_activity.xact_start
Time when this process' current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column.
Reading PG 18·Select a recorded version
- View
- pg_stat_activity
- Field
- xact_start
- SQL type
- timestamp with time zone
- Units named in the field definition
- Not specified
- Reset observation
- No stats_reset field is documented for this view
- documented
- true
- field
- xact_start
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT xact_start FROM pg_catalog.pg_stat_activity;
- source only
- false
- sql type
- timestamp with time zone
- units mentioned
- Unknown
- view
- pg_stat_activity
Definition PG 18
Time when this process' current transaction was started, or null if no transaction is active. If the current query is the first of its transaction, this column is equal to the query_start column.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f