pg_stat_activity.query_id
Identifier of this backend's most recent query. If state is active this field shows the identifier of the currently executing query. In all other states, it shows the identifier of last query that was executed. Query identifiers are not computed by default so this field will be null unless compute_query_id parameter is enabled or a third-party module that computes query identifiers is configured.
Reading PG 18·Select a recorded version
- View
- pg_stat_activity
- Field
- query_id
- SQL type
- bigint
- Units named in the field definition
- Not specified
- Reset observation
- No stats_reset field is documented for this view
- documented
- true
- field
- query_id
- manual path
- /docs/18/monitoring-stats.html
- signature
- SELECT query_id FROM pg_catalog.pg_stat_activity;
- source only
- false
- sql type
- bigint
- units mentioned
- Unknown
- view
- pg_stat_activity
Definition PG 18
Identifier of this backend's most recent query. If state is active this field shows the identifier of the currently executing query. In all other states, it shows the identifier of last query that was executed. Query identifiers are not computed by default so this field will be null unless compute_query_id parameter is enabled or a third-party module that computes query identifiers is configured.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f