{"Entry":{"collection":"func","key":"pg-get-wal-summarizer-state","name":"pg_get_wal_summarizer_state","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"17"},{"descriptions_changed":true,"doc_overhaul":false,"from":"18","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"changed","to":"19"}],"content_hash":"e235992f1b05983c6f307bd8dd658810b28e3d047fd65b7aba5d3d7ba70a6840","first_version":"17","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.229908+08:00","last_version":"20","name":"pg_get_wal_summarizer_state","name_key":"pg_get_wal_summarizer_state","position":28077,"present_in":["17","18","19","20"],"signature":"pg_get_wal_summarizer_state () → record ( summarized_tli bigint, summarized_lsn pg_lsn, pending_lsn pg_lsn, summarizer_pid int )","signature_count":1,"slug":"pg-get-wal-summarizer-state","source_rev":"b7bd9cda","summary":"Returns information about the progress of the WAL summarizer.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-get-wal-summarizer-state","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-get-wal-summarizer-state","SourceRevision":"b7bd9cda","Facts":{"description":"Returns information about the progress of the WAL summarizer. If the WAL summarizer has never run since the instance was started, then summarized_tli and summarized_lsn will be 0 and 0/0 respectively; otherwise, they will be the TLI and ending LSN of the last WAL summary file written to disk. If the WAL summarizer is currently running, pending_lsn will be the ending LSN of the last record that it has consumed, which must always be greater than or equal to summarized_lsn; if the WAL summarizer is not running, it will be equal to summarized_lsn. summarizer_pid is the PID of the WAL summarizer process, if it is running, and otherwise NULL.","description_html":"Returns information about the progress of the WAL summarizer. If the WAL summarizer has never run since the instance was started, then \u003ccode class=\"literal\"\u003esummarized_tli\u003c/code\u003e and \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e will be \u003ccode class=\"literal\"\u003e0\u003c/code\u003e and \u003ccode class=\"literal\"\u003e0/0\u003c/code\u003e respectively; otherwise, they will be the TLI and ending LSN of the last WAL summary file written to disk. If the WAL summarizer is currently running, \u003ccode class=\"literal\"\u003epending_lsn\u003c/code\u003e will be the ending LSN of the last record that it has consumed, which must always be greater than or equal to \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e; if the WAL summarizer is not running, it will be equal to \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e. \u003ccode class=\"literal\"\u003esummarizer_pid\u003c/code\u003e is the PID of the WAL summarizer process, if it is running, and otherwise NULL.","description_zh":"","description_zh_html":"","doc":{"anchor":"FUNCTIONS-WAL-SUMMARY","file":"functions-info.html","slug":"18"},"group":"info","group_label":"System Information Functions And Operators","lang":"en","layout":"table-new","pages":["functions-info.html"],"prose_only":false,"signatures":[{"description":"Returns information about the progress of the WAL summarizer. If the WAL summarizer has never run since the instance was started, then summarized_tli and summarized_lsn will be 0 and 0/0 respectively; otherwise, they will be the TLI and ending LSN of the last WAL summary file written to disk. If the WAL summarizer is currently running, pending_lsn will be the ending LSN of the last record that it has consumed, which must always be greater than or equal to summarized_lsn; if the WAL summarizer is not running, it will be equal to summarized_lsn. summarizer_pid is the PID of the WAL summarizer process, if it is running, and otherwise NULL.","description_html":"Returns information about the progress of the WAL summarizer. If the WAL summarizer has never run since the instance was started, then \u003ccode class=\"literal\"\u003esummarized_tli\u003c/code\u003e and \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e will be \u003ccode class=\"literal\"\u003e0\u003c/code\u003e and \u003ccode class=\"literal\"\u003e0/0\u003c/code\u003e respectively; otherwise, they will be the TLI and ending LSN of the last WAL summary file written to disk. If the WAL summarizer is currently running, \u003ccode class=\"literal\"\u003epending_lsn\u003c/code\u003e will be the ending LSN of the last record that it has consumed, which must always be greater than or equal to \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e; if the WAL summarizer is not running, it will be equal to \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e. \u003ccode class=\"literal\"\u003esummarizer_pid\u003c/code\u003e is the PID of the WAL summarizer process, if it is running, and otherwise NULL.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_wal_summarizer_state\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003esummarized_tli\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003esummarized_lsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epending_lsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003esummarizer_pid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eint\u003c/code\u003e )","returns":"record","text":"pg_get_wal_summarizer_state () → record ( summarized_tli bigint, summarized_lsn pg_lsn, pending_lsn pg_lsn, summarizer_pid int )","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-WAL-SUMMARY","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-get-wal-summarizer-state","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_get_wal_summarizer_state","Summary":"返回有关 WAL 汇总器进度的信息。如果自实例启动以来 WAL 汇总器从未运行过，则 summarized_tli和summarized_lsn 将分别为0和0/0；否则，它们将是最近写入磁盘的 WAL 汇总文件的 TLI 和结束 LSN。如果 WAL 汇总器当前正在运行，pending_lsn将是它已消费的最后一条记录的结束 LSN，该值必定始终大于或等于summarized_lsn；如果 WAL 汇总器未在运行，则它将等于summarized_lsn。summarizer_pid是 WAL 汇总器进程的 PID；如果它正在运行则返回该 PID，否则为 NULL。","BodyHTML":"返回有关 WAL 汇总器进度的信息。如果自实例启动以来 WAL 汇总器从未运行过，则 \u003ccode\u003esummarized_tli\u003c/code\u003e和\u003ccode\u003esummarized_lsn\u003c/code\u003e 将分别为\u003ccode\u003e0\u003c/code\u003e和\u003ccode\u003e0/0\u003c/code\u003e；否则，它们将是最近写入磁盘的 WAL 汇总文件的 TLI 和结束 LSN。如果 WAL 汇总器当前正在运行，\u003ccode\u003epending_lsn\u003c/code\u003e将是它已消费的最后一条记录的结束 LSN，该值必定始终大于或等于\u003ccode\u003esummarized_lsn\u003c/code\u003e；如果 WAL 汇总器未在运行，则它将等于\u003ccode\u003esummarized_lsn\u003c/code\u003e。\u003ccode\u003esummarizer_pid\u003c/code\u003e是 WAL 汇总器进程的 PID；如果它正在运行则返回该 PID，否则为 NULL。\u003cpre\u003epg_get_wal_summarizer_state () → record ( summarized_tli bigint, summarized_lsn pg_lsn, pending_lsn pg_lsn, summarizer_pid int )\u003c/pre\u003e返回有关 WAL 汇总器进度的信息。如果自实例启动以来 WAL 汇总器从未运行过，则 \u003ccode\u003esummarized_tli\u003c/code\u003e和\u003ccode\u003esummarized_lsn\u003c/code\u003e 将分别为\u003ccode\u003e0\u003c/code\u003e和\u003ccode\u003e0/0\u003c/code\u003e；否则，它们将是最近写入磁盘的 WAL 汇总文件的 TLI 和结束 LSN。如果 WAL 汇总器当前正在运行，\u003ccode\u003epending_lsn\u003c/code\u003e将是它已消费的最后一条记录的结束 LSN，该值必定始终大于或等于\u003ccode\u003esummarized_lsn\u003c/code\u003e；如果 WAL 汇总器未在运行，则它将等于\u003ccode\u003esummarized_lsn\u003c/code\u003e。\u003ccode\u003esummarizer_pid\u003c/code\u003e是 WAL 汇总器进程的 PID；如果它正在运行则返回该 PID，否则为 NULL。","SourceRevision":"ca936764","ContentHash":"53a4a8c0d9f71e1100c8a5464c339e338a700c64f888a7bf326a37d8b1c0c96c","Payload":{"description_zh":"返回有关 WAL 汇总器进度的信息。如果自实例启动以来 WAL 汇总器从未运行过，则 summarized_tli和summarized_lsn 将分别为0和0/0；否则，它们将是最近写入磁盘的 WAL 汇总文件的 TLI 和结束 LSN。如果 WAL 汇总器当前正在运行，pending_lsn将是它已消费的最后一条记录的结束 LSN，该值必定始终大于或等于summarized_lsn；如果 WAL 汇总器未在运行，则它将等于summarized_lsn。summarizer_pid是 WAL 汇总器进程的 PID；如果它正在运行则返回该 PID，否则为 NULL。","description_zh_html":"返回有关 WAL 汇总器进度的信息。如果自实例启动以来 WAL 汇总器从未运行过，则 \u003ccode class=\"literal\"\u003esummarized_tli\u003c/code\u003e和\u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e 将分别为\u003ccode class=\"literal\"\u003e0\u003c/code\u003e和\u003ccode class=\"literal\"\u003e0/0\u003c/code\u003e；否则，它们将是最近写入磁盘的 WAL 汇总文件的 TLI 和结束 LSN。如果 WAL 汇总器当前正在运行，\u003ccode class=\"literal\"\u003epending_lsn\u003c/code\u003e将是它已消费的最后一条记录的结束 LSN，该值必定始终大于或等于\u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e；如果 WAL 汇总器未在运行，则它将等于\u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e。\u003ccode class=\"literal\"\u003esummarizer_pid\u003c/code\u003e是 WAL 汇总器进程的 PID；如果它正在运行则返回该 PID，否则为 NULL。","signatures":[{"description_zh":"返回有关 WAL 汇总器进度的信息。如果自实例启动以来 WAL 汇总器从未运行过，则 summarized_tli和summarized_lsn 将分别为0和0/0；否则，它们将是最近写入磁盘的 WAL 汇总文件的 TLI 和结束 LSN。如果 WAL 汇总器当前正在运行，pending_lsn将是它已消费的最后一条记录的结束 LSN，该值必定始终大于或等于summarized_lsn；如果 WAL 汇总器未在运行，则它将等于summarized_lsn。summarizer_pid是 WAL 汇总器进程的 PID；如果它正在运行则返回该 PID，否则为 NULL。","description_zh_html":"返回有关 WAL 汇总器进度的信息。如果自实例启动以来 WAL 汇总器从未运行过，则 \u003ccode class=\"literal\"\u003esummarized_tli\u003c/code\u003e和\u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e 将分别为\u003ccode class=\"literal\"\u003e0\u003c/code\u003e和\u003ccode class=\"literal\"\u003e0/0\u003c/code\u003e；否则，它们将是最近写入磁盘的 WAL 汇总文件的 TLI 和结束 LSN。如果 WAL 汇总器当前正在运行，\u003ccode class=\"literal\"\u003epending_lsn\u003c/code\u003e将是它已消费的最后一条记录的结束 LSN，该值必定始终大于或等于\u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e；如果 WAL 汇总器未在运行，则它将等于\u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e。\u003ccode class=\"literal\"\u003esummarizer_pid\u003c/code\u003e是 WAL 汇总器进程的 PID；如果它正在运行则返回该 PID，否则为 NULL。","returns":"record","text":"pg_get_wal_summarizer_state () → record ( summarized_tli bigint, summarized_lsn pg_lsn, pending_lsn pg_lsn, summarizer_pid int )","zh_from":"doc"}],"zh_from":"doc"}},"RequestedLocale":"zh-Hans","Fallback":false,"Versions":["17","18","19","20"],"Locales":["en","zh-Hans"],"Signatures":[{"Version":"18","Ordinal":0,"Hash":"edb2109e740e8167d8561ecb0bc44e57b8b500a96c421320984d6949ca73b679","Text":"pg_get_wal_summarizer_state () → record ( summarized_tli bigint, summarized_lsn pg_lsn, pending_lsn pg_lsn, summarizer_pid int )","Returns":"record","Payload":{"description":"Returns information about the progress of the WAL summarizer. If the WAL summarizer has never run since the instance was started, then summarized_tli and summarized_lsn will be 0 and 0/0 respectively; otherwise, they will be the TLI and ending LSN of the last WAL summary file written to disk. If the WAL summarizer is currently running, pending_lsn will be the ending LSN of the last record that it has consumed, which must always be greater than or equal to summarized_lsn; if the WAL summarizer is not running, it will be equal to summarized_lsn. summarizer_pid is the PID of the WAL summarizer process, if it is running, and otherwise NULL.","description_html":"Returns information about the progress of the WAL summarizer. If the WAL summarizer has never run since the instance was started, then \u003ccode class=\"literal\"\u003esummarized_tli\u003c/code\u003e and \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e will be \u003ccode class=\"literal\"\u003e0\u003c/code\u003e and \u003ccode class=\"literal\"\u003e0/0\u003c/code\u003e respectively; otherwise, they will be the TLI and ending LSN of the last WAL summary file written to disk. If the WAL summarizer is currently running, \u003ccode class=\"literal\"\u003epending_lsn\u003c/code\u003e will be the ending LSN of the last record that it has consumed, which must always be greater than or equal to \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e; if the WAL summarizer is not running, it will be equal to \u003ccode class=\"literal\"\u003esummarized_lsn\u003c/code\u003e. \u003ccode class=\"literal\"\u003esummarizer_pid\u003c/code\u003e is the PID of the WAL summarizer process, if it is running, and otherwise NULL.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_get_wal_summarizer_state\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003erecord\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003esummarized_tli\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003esummarized_lsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003epending_lsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003esummarizer_pid\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eint\u003c/code\u003e )","returns":"record","text":"pg_get_wal_summarizer_state () → record ( summarized_tli bigint, summarized_lsn pg_lsn, pending_lsn pg_lsn, summarizer_pid int )","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}