STATISTICS VIEW · Statistics view

pg_stat_subscription

PostgreSQL documentation ↗Source definition ↗

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

First seen PG 10Last seen PG 19Columns 11

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_stat_subscription

COLUMN	TYPE	DESCRIPTION
`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

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16
`subid`	–	–	–	–	–	–	–
`subname`	–	–	–	–	–	–	–
`pid`	–	–	–	–	–	–	–
`relid`	–	–	–	–	–	–	–
`received_lsn`	–	–	–	–	–	–	–
`last_msg_send_time`	–	–	–	–	–	–	–
`last_msg_receipt_time`	–	–	–	–	–	–	–
`latest_end_lsn`	–	–	–	–	–	–	–
`latest_end_time`	–	–	–	–	–	–	–
`leader_pid`	–	–	–	–	–	–	–	–	–	–	–	–	–
`worker_type`	–	–	–	–	–	–	–	–	–	–	–	–	–	–

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 19 ← 18

8 column description updates

PostgreSQL 17 ← 16

+ worker_type1 column description updates

PostgreSQL 16 ← 15

+ leader_pid6 column description updates

PostgreSQL 15 ← 14

Catalog description updated

PostgreSQL 13 ← 12

Catalog description updated

PostgreSQL 12 ← 11

Catalog description updated

PostgreSQL 10 ← 9.6Catalog added

+ subid+ subname+ pid+ relid+ received_lsn+ last_msg_send_time+ last_msg_receipt_time+ latest_end_lsn+ latest_end_time

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.