System Catalogs / Statistics views
pg_stat_subscription
Read the PG 18 manualAt least one row per subscription, showing information about the subscription workers.
Reading PG 18current·documented in 11 of 24 versions, 10 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 11
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 11
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
subid | oid | OID of the subscription |
subname | name | Name of the subscription |
worker_type | text | Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization. |
pid | integer | Process ID of the subscription worker process |
leader_pid | integer | 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 |
relid | oid | OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers |
received_lsn | pg_lsn | Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers |
last_msg_send_time | timestamp with time zone | Send time of last message received from origin WAL sender; NULL for parallel apply workers |
last_msg_receipt_time | timestamp with time zone | Receipt time of last message received from origin WAL sender; NULL for parallel apply workers |
latest_end_lsn | pg_lsn | Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers |
latest_end_time | timestamp with time zone | Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers |
Column history across versions
Version history 6
Definition snapshot: english-manuals:aa7154b3ebf2636c869025bd0fd… · English manual source