{"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":"a9564e9ffb915f87302eafbd6f61fe4253350aaa46a726273f8ef792eecb8d4e","derived_content_hash":"398a5a01055396505bbefe67a850a03aaa40fbf35acaf320d19d470ac0efb538","documentation_refresh":{"batch":"20261113","original_source_rev":"catalog-bilingual-repair:c6ccdec626b77389f8857d3262eddd873b162c967ea9425a5b82be9cbd1ce747","versions":{"14":"14.25","15":"15.20","16":"16.16","17":"17.12","18":"18.7","19":"19rc2"}},"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":"catalog-bilingual-repair:c6ccdec626b77389f8857d3262eddd873b162c967ea9425a5b82be9cbd1ce747","summary":"At least one row per subscription, showing information about the subscription workers.","summary_zh":"每个订阅至少一行，显示有关订阅工作进程的信息。有关详细信息，请参阅 pg_stat_subscription。"}},"Definition":{"Collection":"catalog","Key":"pg_stat_subscription","SourceDatabase":"center","Version":"18","SourceTable":"catalog","SourceKey":"pg_stat_subscription","SourceRevision":"catalog-bilingual-repair:c6ccdec626b77389f8857d3262eddd873b162c967ea9425a5b82be9cbd1ce747","Facts":{"columns":[{"array_dimensions":0,"attnum":1,"description":"OID of the subscription","description_zh":"订阅的 OID","documented":true,"documented_name":"subid","hidden":false,"name":"subid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":3,"description":"Type of the subscription worker process. Possible types are apply, parallel apply, and table synchronization.","description_zh":"订阅工作进程的类型。可能的类型有 apply、parallel apply 和 table synchronization。","documented":true,"documented_name":"worker_type","hidden":false,"name":"worker_type","not_null":false,"references":"","type":"text","type_modifier":-1,"type_oid":25,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":4,"description":"Process ID of the subscription worker process","description_zh":"订阅工作进程的进程 ID","documented":true,"documented_name":"pid","hidden":false,"name":"pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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":"如果此进程是并行应用工作进程，则为领导者应用工作进程的进程 ID；如果此进程是领导者应用工作进程或表同步工作进程，则为 NULL","documented":true,"documented_name":"leader_pid","hidden":false,"name":"leader_pid","not_null":false,"references":"","type":"integer","type_modifier":-1,"type_oid":23,"zh_from":"same-version-manual"},{"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":"该工作进程正在同步的关系的 OID；对于领导者应用工作进程和并行应用工作进程，则为 NULL","documented":true,"documented_name":"relid","hidden":false,"name":"relid","not_null":false,"references":"","type":"oid","type_modifier":-1,"type_oid":26,"zh_from":"same-version-manual"},{"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":"接收到的最后一个预写式日志位置，该字段的初始值为 0；对于并行应用工作进程，则为 NULL","documented":true,"documented_name":"received_lsn","hidden":false,"name":"received_lsn","not_null":false,"references":"","type":"pg_lsn","type_modifier":-1,"type_oid":3220,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":8,"description":"Send time of last message received from origin WAL sender; NULL for parallel apply workers","description_zh":"从源 WAL 发送进程收到的最后一条消息的发送时间；对于并行应用工作进程，则为 NULL","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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":9,"description":"Receipt time of last message received from origin WAL sender; NULL for parallel apply workers","description_zh":"从源 WAL 发送进程收到的最后一条消息的接收时间；对于并行应用工作进程，则为 NULL","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,"zh_from":"same-version-manual"},{"array_dimensions":0,"attnum":10,"description":"Last write-ahead log location reported to origin WAL sender; NULL for parallel apply workers","description_zh":"向源 WAL 发送进程报告的最后一个预写式日志位置；对于并行应用工作进程，则为 NULL","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,"zh_from":"same-version-manual"},{"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":"向源 WAL 发送进程报告最后一个预写式日志位置的时间；对于并行应用工作进程，则为 NULL","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,"zh_from":"same-version-manual"}],"description":"","description_zh":"","description_zh_html":"\u003cp\u003e\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-SUBSCRIPTION\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.18. \u003ccode class=\"structname\"\u003epg_stat_subscription\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_subscription 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003esubid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅的 OID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003esubname\u003c/code\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅的名称\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eworker_type\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅工作进程的类型。可能的类型有 \u003ccode class=\"literal\"\u003eapply\u003c/code\u003e、\u003ccode class=\"literal\"\u003eparallel apply\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003etable synchronization\u003c/code\u003e。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003epid\u003c/code\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅工作进程的进程 ID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eleader_pid\u003c/code\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       如果此进程是并行应用工作进程，则为领导者应用工作进程的进程 ID；如果此进程是领导者应用工作进程或表同步工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003erelid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       该工作进程正在同步的关系的 OID；对于领导者应用工作进程和并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ereceived_lsn\u003c/code\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       接收到的最后一个预写式日志位置，该字段的初始值为 0；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elast_msg_send_time\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从源 WAL 发送进程收到的最后一条消息的发送时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elast_msg_receipt_time\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从源 WAL 发送进程收到的最后一条消息的接收时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elatest_end_lsn\u003c/code\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       向源 WAL 发送进程报告的最后一个预写式日志位置；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elatest_end_time\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       向源 WAL 发送进程报告最后一个预写式日志位置的时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","doc":{"anchor":"PG-STAT-SUBSCRIPTION","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"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"},"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","sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:aa7154b3ebf2636c869025bd0fd450bf87564fa78e716b0efff6619aab63ee72","version":"18"}],"zh_from":"same-version-manual"},"ManualEvidence":{"doc":{"anchor":"PG-STAT-SUBSCRIPTION","file":"monitoring-stats.html","lang":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","slug":"18"},"sources":[{"evidence":[{"build_id":107,"kind":"same-version-manual","locale":"zh-Hans","page":"monitoring-stats.html","sha256":"0274aac7991450316bcf7be44635653b6d896fb00e321242c1b6674cb05c2e53","source_revision":"unknown:rendered-translation-baseline","translation_revision":"git:b1b500221dbe5437cfca004d6b04d3f6e422765d;html-sha256:08e987a66af27b98444a8057c256314eafa13611a3fb9e888214fc436824244b","version":"18"}],"kind":"catalog-bilingual-repair","prior_source_revision":"english-manuals:aa7154b3ebf2636c869025bd0fd450bf87564fa78e716b0efff6619aab63ee72","version":"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":"center","Version":"18","Locale":"zh-Hans","Title":"pg_stat_subscription","Summary":"","BodyHTML":"\u003cp\u003e\u003c/p\u003e\u003cdiv id=\"PG-STAT-SUBSCRIPTION\"\u003e\u003cp\u003e\u003cstrong\u003e表 27.18. \u003ccode\u003epg_stat_subscription\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv\u003e\u003ctable summary=\"pg_stat_subscription 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth\u003e\u003cp\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003esubid\u003c/code\u003e \u003ccode\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅的 OID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003esubname\u003c/code\u003e \u003ccode\u003ename\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅的名称\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003eworker_type\u003c/code\u003e \u003ccode\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅工作进程的类型。可能的类型有 \u003ccode\u003eapply\u003c/code\u003e、\u003ccode\u003eparallel apply\u003c/code\u003e 和 \u003ccode\u003etable synchronization\u003c/code\u003e。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003epid\u003c/code\u003e \u003ccode\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅工作进程的进程 ID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003eleader_pid\u003c/code\u003e \u003ccode\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       如果此进程是并行应用工作进程，则为领导者应用工作进程的进程 ID；如果此进程是领导者应用工作进程或表同步工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003erelid\u003c/code\u003e \u003ccode\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       该工作进程正在同步的关系的 OID；对于领导者应用工作进程和并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003ereceived_lsn\u003c/code\u003e \u003ccode\u003epg_lsn\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       接收到的最后一个预写式日志位置，该字段的初始值为 0；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003elast_msg_send_time\u003c/code\u003e \u003ccode\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从源 WAL 发送进程收到的最后一条消息的发送时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003elast_msg_receipt_time\u003c/code\u003e \u003ccode\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从源 WAL 发送进程收到的最后一条消息的接收时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003elatest_end_lsn\u003c/code\u003e \u003ccode\u003epg_lsn\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       向源 WAL 发送进程报告的最后一个预写式日志位置；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd\u003e\u003cp\u003e\n\u003ccode\u003elatest_end_time\u003c/code\u003e \u003ccode\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       向源 WAL 发送进程报告最后一个预写式日志位置的时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","SourceRevision":"catalog-bilingual-repair:c6ccdec626b77389f8857d3262eddd873b162c967ea9425a5b82be9cbd1ce747","ContentHash":"2d29aa9df73649ea60216ccebf92f5c12c5cd456a3a294ff45b3757f1818b810","Payload":{"columns":[{"description_zh":"订阅的 OID","name":"subid","type":"oid","zh_from":"same-version-manual"},{"description_zh":"订阅的名称","name":"subname","type":"name","zh_from":"same-version-manual"},{"description_zh":"订阅工作进程的类型。可能的类型有 apply、parallel apply 和 table synchronization。","name":"worker_type","type":"text","zh_from":"same-version-manual"},{"description_zh":"订阅工作进程的进程 ID","name":"pid","type":"integer","zh_from":"same-version-manual"},{"description_zh":"如果此进程是并行应用工作进程，则为领导者应用工作进程的进程 ID；如果此进程是领导者应用工作进程或表同步工作进程，则为 NULL","name":"leader_pid","type":"integer","zh_from":"same-version-manual"},{"description_zh":"该工作进程正在同步的关系的 OID；对于领导者应用工作进程和并行应用工作进程，则为 NULL","name":"relid","type":"oid","zh_from":"same-version-manual"},{"description_zh":"接收到的最后一个预写式日志位置，该字段的初始值为 0；对于并行应用工作进程，则为 NULL","name":"received_lsn","type":"pg_lsn","zh_from":"same-version-manual"},{"description_zh":"从源 WAL 发送进程收到的最后一条消息的发送时间；对于并行应用工作进程，则为 NULL","name":"last_msg_send_time","type":"timestamp with time zone","zh_from":"same-version-manual"},{"description_zh":"从源 WAL 发送进程收到的最后一条消息的接收时间；对于并行应用工作进程，则为 NULL","name":"last_msg_receipt_time","type":"timestamp with time zone","zh_from":"same-version-manual"},{"description_zh":"向源 WAL 发送进程报告的最后一个预写式日志位置；对于并行应用工作进程，则为 NULL","name":"latest_end_lsn","type":"pg_lsn","zh_from":"same-version-manual"},{"description_zh":"向源 WAL 发送进程报告最后一个预写式日志位置的时间；对于并行应用工作进程，则为 NULL","name":"latest_end_time","type":"timestamp with time zone","zh_from":"same-version-manual"}],"description_zh":"","description_zh_html":"\u003cp\u003e\u003c/p\u003e\u003cdiv class=\"table\" id=\"PG-STAT-SUBSCRIPTION\"\u003e\u003cp class=\"title\"\u003e\u003cstrong\u003e表 27.18. \u003ccode class=\"structname\"\u003epg_stat_subscription\u003c/code\u003e 视图\u003c/strong\u003e\u003c/p\u003e\u003cdiv class=\"table-contents\"\u003e\u003ctable border=\"1\" class=\"table\" summary=\"pg_stat_subscription 视图\"\u003e\u003ccolgroup\u003e\u003ccol/\u003e\u003c/colgroup\u003e\u003cthead\u003e\u003ctr\u003e\u003cth class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n       列类型\n      \u003c/p\u003e\n\u003cp\u003e\n       描述\n      \u003c/p\u003e\u003c/th\u003e\u003c/tr\u003e\u003c/thead\u003e\u003ctbody\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003esubid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅的 OID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003esubname\u003c/code\u003e \u003ccode class=\"type\"\u003ename\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅的名称\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eworker_type\u003c/code\u003e \u003ccode class=\"type\"\u003etext\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅工作进程的类型。可能的类型有 \u003ccode class=\"literal\"\u003eapply\u003c/code\u003e、\u003ccode class=\"literal\"\u003eparallel apply\u003c/code\u003e 和 \u003ccode class=\"literal\"\u003etable synchronization\u003c/code\u003e。\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003epid\u003c/code\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       订阅工作进程的进程 ID\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003eleader_pid\u003c/code\u003e \u003ccode class=\"type\"\u003einteger\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       如果此进程是并行应用工作进程，则为领导者应用工作进程的进程 ID；如果此进程是领导者应用工作进程或表同步工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003erelid\u003c/code\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       该工作进程正在同步的关系的 OID；对于领导者应用工作进程和并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003ereceived_lsn\u003c/code\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       接收到的最后一个预写式日志位置，该字段的初始值为 0；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elast_msg_send_time\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从源 WAL 发送进程收到的最后一条消息的发送时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elast_msg_receipt_time\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       从源 WAL 发送进程收到的最后一条消息的接收时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elatest_end_lsn\u003c/code\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       向源 WAL 发送进程报告的最后一个预写式日志位置；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003ctr\u003e\u003ctd class=\"catalog_table_entry\"\u003e\u003cp class=\"column_definition\"\u003e\n\u003ccode class=\"structfield\"\u003elatest_end_time\u003c/code\u003e \u003ccode class=\"type\"\u003etimestamp with time zone\u003c/code\u003e\n\u003c/p\u003e\n\u003cp\u003e\n       向源 WAL 发送进程报告最后一个预写式日志位置的时间；对于并行应用工作进程，则为 NULL\n      \u003c/p\u003e\u003c/td\u003e\u003c/tr\u003e\u003c/tbody\u003e\u003c/table\u003e\u003c/div\u003e\u003c/div\u003e","zh_from":"same-version-manual"}},"RequestedLocale":"en","Fallback":true,"Versions":["10","11","12","13","14","15","16","17","18","19","20"],"Locales":["zh-Hans"],"Signatures":null,"Spellings":null,"SQLState":null,"Evidence":null}