{"Entry":{"collection":"func","key":"pg-available-wal-summaries","name":"pg_available_wal_summaries","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":"8c16c3e8fd2f700ead4b8280aac1c007cfc303563b36fae74925359d8dcf1f41","first_version":"17","group":"info","group_label":"System Information Functions And Operators","groups":["info"],"imported_at":"2026-09-27T17:57:29.115715+08:00","last_version":"20","name":"pg_available_wal_summaries","name_key":"pg_available_wal_summaries","position":28033,"present_in":["17","18","19","20"],"signature":"pg_available_wal_summaries () → setof record ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn )","signature_count":1,"slug":"pg-available-wal-summaries","source_rev":"b7bd9cda","summary":"Returns information about the WAL summary files present in the data directory, under pg_wal/summaries.","summary_zh":""}},"Definition":{"Collection":"func","Key":"pg-available-wal-summaries","SourceDatabase":"center","Version":"18","SourceTable":"func","SourceKey":"pg-available-wal-summaries","SourceRevision":"b7bd9cda","Facts":{"description":"Returns information about the WAL summary files present in the data directory, under pg_wal/summaries. One row will be returned per WAL summary file. Each file summarizes WAL on the indicated TLI within the indicated LSN range. This function might be useful to determine whether enough WAL summaries are present on the server to take an incremental backup based on some prior backup whose start LSN is known.","description_html":"Returns information about the WAL summary files present in the data directory, under \u003ccode class=\"literal\"\u003epg_wal/summaries\u003c/code\u003e. One row will be returned per WAL summary file. Each file summarizes WAL on the indicated TLI within the indicated LSN range. This function might be useful to determine whether enough WAL summaries are present on the server to take an incremental backup based on some prior backup whose start LSN is known.","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 WAL summary files present in the data directory, under pg_wal/summaries. One row will be returned per WAL summary file. Each file summarizes WAL on the indicated TLI within the indicated LSN range. This function might be useful to determine whether enough WAL summaries are present on the server to take an incremental backup based on some prior backup whose start LSN is known.","description_html":"Returns information about the WAL summary files present in the data directory, under \u003ccode class=\"literal\"\u003epg_wal/summaries\u003c/code\u003e. One row will be returned per WAL summary file. Each file summarizes WAL on the indicated TLI within the indicated LSN range. This function might be useful to determine whether enough WAL summaries are present on the server to take an incremental backup based on some prior backup whose start LSN is known.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_available_wal_summaries\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\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 )","returns":"setof record","text":"pg_available_wal_summaries () → setof record ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn )","zh_from":""}],"zh_from":""},"ManualEvidence":{"doc":{"anchor":"FUNCTIONS-WAL-SUMMARY","file":"functions-info.html","slug":"18"}},"MeasuredEvidence":{}},"Text":{"Collection":"func","Key":"pg-available-wal-summaries","SourceDatabase":"pgweb","Version":"18","Locale":"zh-Hans","Title":"pg_available_wal_summaries","Summary":"返回数据目录中 pg_wal/summaries下现有 WAL 汇总文件的信息。每个 WAL 汇总文件返回一行。每个文件都汇总了指定 TLI 上、指定 LSN 范围内的 WAL。该函数可用于判断服务器上是否存在足够的 WAL 汇总，从而基于某个已知起始 LSN 的先前备份执行增量备份。","BodyHTML":"返回数据目录中 \u003ccode\u003epg_wal/summaries\u003c/code\u003e下现有 WAL 汇总文件的信息。每个 WAL 汇总文件返回一行。每个文件都汇总了指定 TLI 上、指定 LSN 范围内的 WAL。该函数可用于判断服务器上是否存在足够的 WAL 汇总，从而基于某个已知起始 LSN 的先前备份执行增量备份。\u003cpre\u003epg_available_wal_summaries () → setof record ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn )\u003c/pre\u003e返回数据目录中 \u003ccode\u003epg_wal/summaries\u003c/code\u003e下现有 WAL 汇总文件的信息。每个 WAL 汇总文件返回一行。每个文件都汇总了指定 TLI 上、指定 LSN 范围内的 WAL。该函数可用于判断服务器上是否存在足够的 WAL 汇总，从而基于某个已知起始 LSN 的先前备份执行增量备份。","SourceRevision":"ca936764","ContentHash":"ecfc512ea6d20344615ca74363b42a70a1f49544378dfef5c04130aea8e77f16","Payload":{"description_zh":"返回数据目录中 pg_wal/summaries下现有 WAL 汇总文件的信息。每个 WAL 汇总文件返回一行。每个文件都汇总了指定 TLI 上、指定 LSN 范围内的 WAL。该函数可用于判断服务器上是否存在足够的 WAL 汇总，从而基于某个已知起始 LSN 的先前备份执行增量备份。","description_zh_html":"返回数据目录中 \u003ccode class=\"literal\"\u003epg_wal/summaries\u003c/code\u003e下现有 WAL 汇总文件的信息。每个 WAL 汇总文件返回一行。每个文件都汇总了指定 TLI 上、指定 LSN 范围内的 WAL。该函数可用于判断服务器上是否存在足够的 WAL 汇总，从而基于某个已知起始 LSN 的先前备份执行增量备份。","signatures":[{"description_zh":"返回数据目录中 pg_wal/summaries下现有 WAL 汇总文件的信息。每个 WAL 汇总文件返回一行。每个文件都汇总了指定 TLI 上、指定 LSN 范围内的 WAL。该函数可用于判断服务器上是否存在足够的 WAL 汇总，从而基于某个已知起始 LSN 的先前备份执行增量备份。","description_zh_html":"返回数据目录中 \u003ccode class=\"literal\"\u003epg_wal/summaries\u003c/code\u003e下现有 WAL 汇总文件的信息。每个 WAL 汇总文件返回一行。每个文件都汇总了指定 TLI 上、指定 LSN 范围内的 WAL。该函数可用于判断服务器上是否存在足够的 WAL 汇总，从而基于某个已知起始 LSN 的先前备份执行增量备份。","returns":"setof record","text":"pg_available_wal_summaries () → setof record ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn )","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":"ed8e1c44ed2dc4ce17536639ff77fb4dc7dc8b596b8be87224ea3b5b9ed40fa3","Text":"pg_available_wal_summaries () → setof record ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn )","Returns":"setof record","Payload":{"description":"Returns information about the WAL summary files present in the data directory, under pg_wal/summaries. One row will be returned per WAL summary file. Each file summarizes WAL on the indicated TLI within the indicated LSN range. This function might be useful to determine whether enough WAL summaries are present on the server to take an incremental backup based on some prior backup whose start LSN is known.","description_html":"Returns information about the WAL summary files present in the data directory, under \u003ccode class=\"literal\"\u003epg_wal/summaries\u003c/code\u003e. One row will be returned per WAL summary file. Each file summarizes WAL on the indicated TLI within the indicated LSN range. This function might be useful to determine whether enough WAL summaries are present on the server to take an incremental backup based on some prior backup whose start LSN is known.","description_zh":"","description_zh_html":"","examples":[],"html":"\u003ccode class=\"function\"\u003epg_available_wal_summaries\u003c/code\u003e () → \u003ccode class=\"returnvalue\"\u003esetof record\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 )","returns":"setof record","text":"pg_available_wal_summaries () → setof record ( tli bigint, start_lsn pg_lsn, end_lsn pg_lsn )","zh_from":""}}],"Spellings":null,"SQLState":null,"Evidence":null}