pg_stat_subscription.leader_pid

Description

Process ID of the leader apply worker if this process is a parallel apply worker; NULL if this process is a leader apply worker or a table synchronization worker

View

pg_stat_subscription

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_subscription;

View semantics

At least one row per subscription, showing information about the subscription workers. See pg_stat_subscription for details.

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_subscription;

Related entries

• pg_stat_subscription columns
• Statistics collection and reset functions

Documentation and source

• PostgreSQL 18 English manual

Compare versions

PostgreSQL 15 → 16: added.

--- PostgreSQL 15
+++ PostgreSQL 16
@@ -1 +1,6 @@
-Not recorded in this version
+{
+  "field": "leader_pid",
+  "sql_type": "integer",
+  "units_mentioned": [],
+  "view": "pg_stat_subscription"
+}

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_subscription.last_msg_receipt_time
• pg_stat_subscription.last_msg_send_time
• pg_stat_subscription.latest_end_lsn
• pg_stat_subscription.latest_end_time
• pg_stat_subscription.pid
• pg_stat_subscription.received_lsn
• pg_stat_subscription.relid
• pg_stat_subscription.subid
• pg_stat_subscription.subname
• pg_stat_subscription.worker_type