Wiki / Statistics & Metrics / pg_stat_activity
pg_stat_activity.leader_pid
Process ID of the parallel group leader if this process is a parallel query worker, or process ID of the leader apply worker if this process is a parallel apply worker. NULL indicates that this process is a parallel group leader or leader apply work…
Reading PostgreSQL 18.6.
Description
Process ID of the parallel group leader if this process is a parallel query worker, or process ID of the leader apply worker if this process is a parallel apply worker. NULL indicates that this process is a parallel group leader or leader apply worker, or does not participate in any parallel operation.
- View
- pg_stat_activity
- Field
- leader_pid
- SQL type
- integer
- Units named in the field definition
- Not specified
- Reset observation
- No stats_reset field is documented for this view
Usage
SELECT leader_pid FROM pg_catalog.pg_stat_activity;View semantics
The pg_stat_activity view will have one row per server process, showing information related to the current activity of that process.
Collection and reset context
Read the same-version statistics collection and view documentation below for reset scope and visibility. No per-field reset rule is inferred from the field name.
Inspect this field
Example query; no execution result or measured value is asserted.
SELECT leader_pid FROM pg_catalog.pg_stat_activity;Related entries
Documentation and source
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Compare versions
PostgreSQL 17 → 18: unchanged.
Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.
Related entries
pg_stat_activity.application_namepg_stat_activity.backend_startpg_stat_activity.backend_typepg_stat_activity.backend_xidpg_stat_activity.backend_xminpg_stat_activity.client_addrpg_stat_activity.client_hostnamepg_stat_activity.client_portpg_stat_activity.datidpg_stat_activity.datnamepg_stat_activity.pidpg_stat_activity.query
Export JSON · Back to Statistics & Metrics · Recorded in PostgreSQL 13 through 20; the first sample is not necessarily its introduction.