{"Entry":{"collection":"func","key":"pg-wal-summary-contents","name":"pg_wal_summary_contents","aliases":[],"metadata":{"changed_in":[],"changes":[{"descriptions_changed":false,"doc_overhaul":false,"from":"16","group_changed":null,"signatures":{"added":[],"removed":[]},"status":"added","to":"17"}],"content_hash":"e0e2bdc2be2ff7979725dc730185e0d41a8b78c44c66451c8f8e07637c31c4b4","first_version":"17","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.329372+08:00","last_version":"20","name":"pg_wal_summary_contents","name_key":"pg_wal_summary_contents","position":28115,"present_in":["17","18","19","20"],"signature":"pg_wal_summary_contents ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn ) → setof record ( relfilenode oid, reltablespace oid, reldatabase oid, relforknumber smallint, relblocknumber bigint, is_limit_block boolean )","signature_count":1,"slug":"pg-wal-summary-contents","source_rev":"b7bd9cda","summary":"Returns one information about the contents of a single WAL summary file identified by TLI and starting and ending LSNs.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-wal-summary-contents","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-wal-summary-contents","SourceRevision":"b7bd9cda","Facts":{"description":"Returns one information about the contents of a single WAL summary file identified by TLI and starting and ending LSNs. Each row with is_limit_block false indicates that the block identified by the remaining output columns was modified by at least one WAL record within the range of records summarized by this file. Each row with is_limit_block true indicates either that (a) the relation fork was truncated to the length given by relblocknumber within the relevant range of WAL records or (b) that the relation fork was created or dropped within the relevant range of WAL records; in such cases, relblocknumber will be zero.","description_html":"Returns one information about the contents of a single WAL summary file identified by TLI and starting and ending LSNs. Each row with \u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e false indicates that the block identified by the remaining output columns was modified by at least one WAL record within the range of records summarized by this file. Each row with \u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e true indicates either that (a) the relation fork was truncated to the length given by \u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e within the relevant range of WAL records or (b) that the relation fork was created or dropped within the relevant range of WAL records; in such cases, \u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e will be zero.","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 one information about the contents of a single WAL summary file identified by TLI and starting and ending LSNs. Each row with is_limit_block false indicates that the block identified by the remaining output columns was modified by at least one WAL record within the range of records summarized by this file. Each row with is_limit_block true indicates either that (a) the relation fork was truncated to the length given by relblocknumber within the relevant range of WAL records or (b) that the relation fork was created or dropped within the relevant range of WAL records; in such cases, relblocknumber will be zero.","description_html":"Returns one information about the contents of a single WAL summary file identified by TLI and starting and ending LSNs. Each row with \u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e false indicates that the block identified by the remaining output columns was modified by at least one WAL record within the range of records summarized by this file. Each row with \u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e true indicates either that (a) the relation fork was truncated to the length given by \u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e within the relevant range of WAL records or (b) that the relation fork was created or dropped within the relevant range of WAL records; in such cases, \u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e will be zero.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_wal_summary_contents\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etli\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estart_lsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eend_lsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003erelfilenode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ereltablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ereldatabase\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003erelforknumber\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003esmallint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003erelblocknumber\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_limit_block\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e )","returns":"setof record","text":"pg_wal_summary_contents ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn ) → setof record ( relfilenode oid, reltablespace oid, reldatabase oid, relforknumber smallint, relblocknumber bigint, is_limit_block boolean )","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-WAL-SUMMARY","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-wal-summary-contents","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_wal_summary_contents","Summary":"返回由 TLI 以及起始和结束 LSN 标识的单个 WAL 汇总文件内容的信息。每一行中，如果is_limit_block为 false，则表示其余输出列所标识的块在该文件所汇总的 WAL 记录范围内被至少一条 WAL 记录修改过。每一行中，如果is_limit_block 为 true，则表示以下两种情况之一：(a) 该关系分支在相关 WAL 记录范围内被截断到relblocknumber给出的长度；或者 (b) 该关系分支在相关 WAL 记录范围内被创建或删除；在创建或删除的情况下，relblocknumber将为零。","BodyHTML":"返回由 TLI 以及起始和结束 LSN 标识的单个 WAL 汇总文件内容的信息。每一行中，如果\u003ccode\u003eis_limit_block\u003c/code\u003e为 false，则表示其余输出列所标识的块在该文件所汇总的 WAL 记录范围内被至少一条 WAL 记录修改过。每一行中，如果\u003ccode\u003eis_limit_block\u003c/code\u003e 为 true，则表示以下两种情况之一：(a) 该关系分支在相关 WAL 记录范围内被截断到\u003ccode\u003erelblocknumber\u003c/code\u003e给出的长度；或者 (b) 该关系分支在相关 WAL 记录范围内被创建或删除；在创建或删除的情况下，\u003ccode\u003erelblocknumber\u003c/code\u003e将为零。\u003cpre\u003epg_wal_summary_contents ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn ) → setof record ( relfilenode oid, reltablespace oid, reldatabase oid, relforknumber smallint, relblocknumber bigint, is_limit_block boolean )\u003c/pre\u003e返回由 TLI 以及起始和结束 LSN 标识的单个 WAL 汇总文件内容的信息。每一行中，如果\u003ccode\u003eis_limit_block\u003c/code\u003e为 false，则表示其余输出列所标识的块在该文件所汇总的 WAL 记录范围内被至少一条 WAL 记录修改过。每一行中，如果\u003ccode\u003eis_limit_block\u003c/code\u003e 为 true，则表示以下两种情况之一：(a) 该关系分支在相关 WAL 记录范围内被截断到\u003ccode\u003erelblocknumber\u003c/code\u003e给出的长度；或者 (b) 该关系分支在相关 WAL 记录范围内被创建或删除；在创建或删除的情况下，\u003ccode\u003erelblocknumber\u003c/code\u003e将为零。","SourceRevision":"ca936764","ContentHash":"a7609dbe8f4fadc33f6b41977f715e58ddf32080900e9dd5bf4f6b634aead7e2","Payload":{"description_zh":"返回由 TLI 以及起始和结束 LSN 标识的单个 WAL 汇总文件内容的信息。每一行中，如果is_limit_block为 false，则表示其余输出列所标识的块在该文件所汇总的 WAL 记录范围内被至少一条 WAL 记录修改过。每一行中，如果is_limit_block 为 true，则表示以下两种情况之一：(a) 该关系分支在相关 WAL 记录范围内被截断到relblocknumber给出的长度；或者 (b) 该关系分支在相关 WAL 记录范围内被创建或删除；在创建或删除的情况下，relblocknumber将为零。","description_zh_html":"返回由 TLI 以及起始和结束 LSN 标识的单个 WAL 汇总文件内容的信息。每一行中，如果\u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e为 false，则表示其余输出列所标识的块在该文件所汇总的 WAL 记录范围内被至少一条 WAL 记录修改过。每一行中，如果\u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e 为 true，则表示以下两种情况之一：(a) 该关系分支在相关 WAL 记录范围内被截断到\u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e给出的长度；或者 (b) 该关系分支在相关 WAL 记录范围内被创建或删除；在创建或删除的情况下，\u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e将为零。","signatures":[{"description_zh":"返回由 TLI 以及起始和结束 LSN 标识的单个 WAL 汇总文件内容的信息。每一行中，如果is_limit_block为 false，则表示其余输出列所标识的块在该文件所汇总的 WAL 记录范围内被至少一条 WAL 记录修改过。每一行中，如果is_limit_block 为 true，则表示以下两种情况之一：(a) 该关系分支在相关 WAL 记录范围内被截断到relblocknumber给出的长度；或者 (b) 该关系分支在相关 WAL 记录范围内被创建或删除；在创建或删除的情况下，relblocknumber将为零。","description_zh_html":"返回由 TLI 以及起始和结束 LSN 标识的单个 WAL 汇总文件内容的信息。每一行中，如果\u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e为 false，则表示其余输出列所标识的块在该文件所汇总的 WAL 记录范围内被至少一条 WAL 记录修改过。每一行中，如果\u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e 为 true，则表示以下两种情况之一：(a) 该关系分支在相关 WAL 记录范围内被截断到\u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e给出的长度；或者 (b) 该关系分支在相关 WAL 记录范围内被创建或删除；在创建或删除的情况下，\u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e将为零。","returns":"setof record","text":"pg_wal_summary_contents ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn ) → setof record ( relfilenode oid, reltablespace oid, reldatabase oid, relforknumber smallint, relblocknumber bigint, is_limit_block boolean )","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":"200c8e6f7a43aeed9cac166b2577e574c4efb5029539b1adfce6029dbc8c2dc1","Text":"pg_wal_summary_contents ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn ) → setof record ( relfilenode oid, reltablespace oid, reldatabase oid, relforknumber smallint, relblocknumber bigint, is_limit_block boolean )","Returns":"setof record","Payload":{"description":"Returns one information about the contents of a single WAL summary file identified by TLI and starting and ending LSNs. Each row with is_limit_block false indicates that the block identified by the remaining output columns was modified by at least one WAL record within the range of records summarized by this file. Each row with is_limit_block true indicates either that (a) the relation fork was truncated to the length given by relblocknumber within the relevant range of WAL records or (b) that the relation fork was created or dropped within the relevant range of WAL records; in such cases, relblocknumber will be zero.","description_html":"Returns one information about the contents of a single WAL summary file identified by TLI and starting and ending LSNs. Each row with \u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e false indicates that the block identified by the remaining output columns was modified by at least one WAL record within the range of records summarized by this file. Each row with \u003ccode class=\"literal\"\u003eis_limit_block\u003c/code\u003e true indicates either that (a) the relation fork was truncated to the length given by \u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e within the relevant range of WAL records or (b) that the relation fork was created or dropped within the relevant range of WAL records; in such cases, \u003ccode class=\"literal\"\u003erelblocknumber\u003c/code\u003e will be zero.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_wal_summary_contents\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003etli\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003estart_lsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eend_lsn\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003epg_lsn\u003c/code\u003e ) → \u003ccode class=\"returnvalue\"\u003esetof record\u003c/code\u003e ( \u003cem class=\"parameter\"\u003e\u003ccode\u003erelfilenode\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ereltablespace\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003ereldatabase\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eoid\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003erelforknumber\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003esmallint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003erelblocknumber\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003ebigint\u003c/code\u003e, \u003cem class=\"parameter\"\u003e\u003ccode\u003eis_limit_block\u003c/code\u003e\u003c/em\u003e \u003ccode class=\"type\"\u003eboolean\u003c/code\u003e )","returns":"setof record","text":"pg_wal_summary_contents ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn ) → setof record ( relfilenode oid, reltablespace oid, reldatabase oid, relforknumber smallint, relblocknumber bigint, is_limit_block boolean )","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}