pg_stat_subscription
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
This definition is unavailable in the selected language. The original Simplified Chinese text is shown.
- kind
- statistics
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- subid, subname, worker_type, pid, leader_pid, relid, received_lsn, last_msg_send_time, last_msg_receipt_time, latest_end_lsn, latest_end_time
- runtime verified
- false
- source
- english-manual
Definition PG 18
表 27.18. pg_stat_subscription 视图
列类型 描述 |
|---|
订阅的 OID |
订阅的名称 |
订阅工作进程的类型。可能的类型有 |
订阅工作进程的进程 ID |
如果此进程是并行应用工作进程，则为领导者应用工作进程的进程 ID；如果此进程是领导者应用工作进程或表同步工作进程，则为 NULL |
该工作进程正在同步的关系的 OID；对于领导者应用工作进程和并行应用工作进程，则为 NULL |
接收到的最后一个预写式日志位置，该字段的初始值为 0；对于并行应用工作进程，则为 NULL |
从源 WAL 发送进程收到的最后一条消息的发送时间；对于并行应用工作进程，则为 NULL |
从源 WAL 发送进程收到的最后一条消息的接收时间；对于并行应用工作进程，则为 NULL |
向源 WAL 发送进程报告的最后一个预写式日志位置；对于并行应用工作进程，则为 NULL |
向源 WAL 发送进程报告最后一个预写式日志位置的时间；对于并行应用工作进程，则为 NULL |
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| subid | oid | Nullable | OID of the subscription |
| subname | name | Nullable | Name of the subscription |
| worker_type | text | Nullable | Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization. |
| pid | integer | Nullable | Process ID of the subscription worker process |
| leader_pid | integer | Nullable | 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 | Nullable | OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers |
| received_lsn | pg_lsn | Nullable | 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 | Nullable | Send time of last message received from origin WAL sender; NULL for parallel apply workers |
| last_msg_receipt_time | timestamp with time zone | Nullable | Receipt time of last message received from origin WAL sender; NULL for parallel apply workers |
| latest_end_lsn | pg_lsn | Nullable | Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers |
| latest_end_time | timestamp with time zone | Nullable | Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:c6ccdec626b77389f8857d3262eddd873b162c967ea9425a5b82be9cbd1ce747
Text language: zh-Hans · catalog-bilingual-repair:c6ccdec626b77389f8857d3262eddd873b162c967ea9425a5b82be9cbd1ce747