{"Entry":{"collection":"catalog","key":"pg_stat_subscription","name":"pg_stat_subscription","aliases":[],"metadata":{"changed_in":["16","17"],"changes":[{"added":[],"attributes":[],"description_changed":false,"descriptions":[],"from":"9.6","order":false,"removed":[],"status":"added","to":"10","types":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"12","listing":[],"order":false,"removed":[],"status":"reworded","to":"13","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":true,"descriptions":[],"from":"14","listing":[],"order":false,"removed":[],"status":"reworded","to":"15","types":[],"unlisted":[]},{"added":["leader_pid"],"attributes":[],"description_changed":false,"descriptions":[{"from":"Receipt time of last message received from origin WAL sender","name":"last_msg_receipt_time","to":"Receipt time of last message received from origin WAL sender; NULL for parallel apply workers"},{"from":"Send time of last message received from origin WAL sender","name":"last_msg_send_time","to":"Send time of last message received from origin WAL sender; NULL for parallel apply workers"},{"from":"Last write-ahead log location reported to origin WAL sender","name":"latest_end_lsn","to":"Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers"},{"from":"Time of last write-ahead log location reported to origin WAL sender","name":"latest_end_time","to":"Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers"},{"from":"Last write-ahead log location received, the initial value of this field being 0","name":"received_lsn","to":"Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers"},{"from":"OID of the relation that the worker is synchronizing; null for the main apply worker","name":"relid","to":"OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers"}],"from":"15","listing":[],"order":false,"removed":[],"status":"changed","to":"16","types":[],"unlisted":[]},{"added":["worker_type"],"attributes":[],"description_changed":false,"descriptions":[{"from":"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 synchronization worker","name":"leader_pid","to":"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"}],"from":"16","listing":[],"order":false,"removed":[],"status":"changed","to":"17","types":[],"unlisted":[]},{"added":[],"attributes":[],"description_changed":false,"descriptions":[{"from":"Receipt time of last message received from origin WAL sender; NULL for parallel apply workers","name":"last_msg_receipt_time","to":"Receipt time of last message received from origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker"},{"from":"Send time of last message received from origin WAL sender; NULL for parallel apply workers","name":"last_msg_send_time","to":"Send time of last message received from origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker"},{"from":"Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers","name":"latest_end_lsn","to":"Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker"},{"from":"Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers","name":"latest_end_time","to":"Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers and the sequence synchronization worker"},{"from":"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","name":"leader_pid","to":"Process ID of the leader apply worker if this process is a parallel apply worker; NULL if this process is a leader apply worker, a table synchronization worker or a sequence synchronization worker"},{"from":"Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers","name":"received_lsn","to":"Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers and the sequence synchronization worker"},{"from":"OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers","name":"relid","to":"OID of the relation that the worker is synchronizing; NULL for the leader apply worker, parallel apply workers and the sequence synchronization worker"},{"from":"Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization.","name":"worker_type","to":"Type of the subscription worker process. Possible types are apply, parallel apply, table synchronization, and sequence synchronization."}],"from":"18","listing":[],"order":false,"removed":[],"status":"reworded","to":"19","types":[],"unlisted":[]}],"column_count":11,"content_hash":"43a3373ec32f0ecf31b630b0faaca020842c790db1fcc8214e69f9c76cc9cee6","first_version":"10","imported_at":"2026-09-30T00:40:55.989949+08:00","kind":"statistics","last_version":"20","name":"pg_stat_subscription","position":108,"present_in":["10","11","12","13","14","15","16","17","18","19","20"],"relation_oid":null,"relkind":"v","shared":false,"source_rev":"english-manuals:aa7154b3ebf2636c869025bd0fd450bf87564fa78e716b0efff6619aab63ee72","summary":"At least one row per subscription, showing information about the subscription workers.","summary_zh":""}},"Definition":{"Collection":"catalog","Key":"pg_stat_subscription","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_subscription","SourceRevision":"english-manuals:aa7154b3ebf2636c869025bd0fd450bf87564fa78e716b0efff6619aab63ee72","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the subscription","description_zh":"","documented":true,"documented_name":"subid","hidden":false,"name":"subid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":2,"description":"Name of the subscription","description_zh":"","documented":true,"documented_name":"subname","hidden":false,"name":"subname","not_null":false,"references":"","type":"name","type_modifier":-1,"type_oid":19},{"array_dimensions":0,"attnum":3,"description":"Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization.","description_zh":"","documented":true,"documented_name":"worker_type","hidden":false,"name":"worker_type","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25},{"array_dimensions":0,"attnum":4,"description":"Process ID of the subscription worker process","description_zh":"","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":5,"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","description_zh":"","documented":true,"documented_name":"leader_pid","hidden":false,"name":"leader_pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23},{"array_dimensions":0,"attnum":6,"description":"OID of the relation that the worker is synchronizing; NULL for the leader apply worker and parallel apply workers","description_zh":"","documented":true,"documented_name":"relid","hidden":false,"name":"relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26},{"array_dimensions":0,"attnum":7,"description":"Last write-ahead log location received, the initial value of this field being 0; NULL for parallel apply workers","description_zh":"","documented":true,"documented_name":"received_lsn","hidden":false,"name":"received_lsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220},{"array_dimensions":0,"attnum":8,"description":"Send time of last message received from origin WAL sender; NULL for parallel apply workers","description_zh":"","documented":true,"documented_name":"last_msg_send_time","hidden":false,"name":"last_msg_send_time","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184},{"array_dimensions":0,"attnum":9,"description":"Receipt time of last message received from origin WAL sender; NULL for parallel apply workers","description_zh":"","documented":true,"documented_name":"last_msg_receipt_time","hidden":false,"name":"last_msg_receipt_time","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184},{"array_dimensions":0,"attnum":10,"description":"Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers","description_zh":"","documented":true,"documented_name":"latest_end_lsn","hidden":false,"name":"latest_end_lsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220},{"array_dimensions":0,"attnum":11,"description":"Time of last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers","description_zh":"","documented":true,"documented_name":"latest_end_time","hidden":false,"name":"latest_end_time","not_null":false,"references":"","type":"timestamp with time zone","type_modifier":-1,"type_oid":1184}],"description":"At least one row per subscription, showing information about the subscription workers. See pg_stat_subscription for details.","description_zh":"","doc":{"anchor":"PG-STAT-SUBSCRIPTION","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"},"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"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-SUBSCRIPTION","file":"monitoring-stats.html","lang":"en","sha256":"aa979eed08627fbf715a9d792094a162a73671db5af810f3ab2aad3e073d5722","slug":"18"}},"MeasuredEvidence":{"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}},"Text":{"Collection":"catalog","Key":"pg_stat_subscription","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_stat_subscription","Summary":"","BodyHTML":"\u003cp\u003e\u003c/p\u003e","SourceRevision":"2026-09-27@419045e","ContentHash":"5f05fe715885db4587e2d1fba30b6f0a5ade940102ecf7255e6cdf09d962aaca","Payload":{"columns":[{"description_zh":"订阅的OID","name":"subid","type":"oid","zh_from":"doc"},{"description_zh":"订阅的名称","name":"subname","type":"name","zh_from":"doc"},{"description_zh":"订阅工作进程的类型。可能的类型有 apply、parallel apply 和 table synchronization。","name":"worker_type","type":"text","zh_from":"doc"},{"description_zh":"订阅工作进程的进程 ID","name":"pid","type":"integer","zh_from":"doc"},{"description_zh":"如果此进程是并行应用工作进程，则为领导者应用工作进程的进程 ID；如果此进程是领导者应用工作进程或表同步工作进程，则为 NULL","name":"leader_pid","type":"integer","zh_from":"doc"},{"description_zh":"该工作进程正在同步的关系的 OID；对于领导者应用工作进程和并行应用工作进程，则为 NULL","name":"relid","type":"oid","zh_from":"doc"},{"description_zh":"接收到的最后一个预写式日志位置，该字段的初始值为 0；对于并行应用工作进程，则为 NULL","name":"received_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"从源 WAL 发送进程收到的最后一条消息的发送时间；对于并行应用工作进程，则为 NULL","name":"last_msg_send_time","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"从源 WAL 发送进程收到的最后一条消息的接收时间；对于并行应用工作进程，则为 NULL","name":"last_msg_receipt_time","type":"timestamp with time zone","zh_from":"doc"},{"description_zh":"向源 WAL 发送进程报告的最后一个预写式日志位置；对于并行应用工作进程，则为 NULL","name":"latest_end_lsn","type":"pg_lsn","zh_from":"doc"},{"description_zh":"向源 WAL 发送进程报告最后一个预写式日志位置的时间；对于并行应用工作进程，则为 NULL","name":"latest_end_time","type":"timestamp with time zone","zh_from":"doc"}],"description_zh":"","zh_from":""}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}