↑↓ 选择↵ 打开⌫ 切换范围完整搜索

PG.CENTER 连接 PostgreSQL 文档、百科与生态知识。由 Pigsty 维护。

Wiki / 命令行工具

pg_walsummary

pg_walsummary — print contents of WAL summary files

当前阅读 PG 18·选择有来源记录的版本

此版本暂无所选语言的定义,以下显示原始英文内容。

Documented executable
pg_walsummary
Executable version
18.6
Reference inventory
Server applications
Option definition groups
4
environment
未知
manual path
app-pgwalsummary.html
signature
pg_walsummary [ option ...] [ file ...]
synopsis
pg_walsummary [ option ...] [ file ...]

版本定义 PG 18

pg_walsummary

pg_walsummary — print contents of WAL summary files

Synopsis

pg_walsummary [option...] [file...]

Description

pg_walsummary is used to print the contents of WAL summary files. These binary files are found in the pg_wal/summaries subdirectory of the data directory, and can be converted to text using this tool. This is not ordinarily necessary, since WAL summary files primarily exist to support incremental backup, but it may be useful for debugging purposes.

A WAL summary file is indexed by tablespace OID, relation OID, and relation fork. For each relation fork, it stores the list of blocks that were modified by WAL within the range summarized in the file. It can also store a "limit block," which is 0 if the relation fork was created or truncated within the relevant WAL range, and otherwise the shortest length to which the relation fork was truncated. If the relation fork was not created, deleted, or truncated within the relevant WAL range, the limit block is undefined or infinite and will not be printed by this tool.

Options

-i
--individual

By default, pg_walsummary prints one line of output for each range of one or more consecutive modified blocks. This can make the output a lot briefer, since a relation where all blocks from 0 through 999 were modified will produce only one line of output rather than 1000 separate lines. This option requests a separate line of output for every modified block.

-q
--quiet

Do not print any output, except for errors. This can be useful when you want to know whether a WAL summary file can be successfully parsed but don't care about the contents.

-V
--version

Display version information, then exit.

-?
--help

Shows help about pg_walsummary command line arguments, and exits.

Environment

The environment variable PG_COLOR specifies whether to use color in diagnostic messages. Possible values are always, auto and never.

Documented options

Option and argumentsDescription
-i --individualBy default, pg_walsummary prints one line of output for each range of one or more consecutive modified blocks. This can make the output a lot briefer, since a relation where all blocks from 0 through 999 were modified will produce only one line of output rather than 1000 separate lines. This option requests a separate line of output for every modified block.
-q --quietDo not print any output, except for errors. This can be useful when you want to know whether a WAL summary file can be successfully parsed but don't care about the contents.
-V --versionDisplay version information, then exit.
-? --helpShows help about pg_walsummary command line arguments, and exits.

比较版本

完整来源事实

options

map[description:By default, pg_walsummary prints one line of output for each range of one or more consecutive modified blocks. This can make the output a lot briefer, since a relation where all blocks from 0 through 999 were modified will produce only one line of output rather than 1000 separate lines. This option requests a separate line of output for every modified block. names:[-i --individual] signature:-i --individual source_url:/docs/18/app-pgwalsummary.html summary:By default, pg_walsummary prints one line of output for each range of one or more consecutive modified blocks. This can make the output a lot briefer, since a relation where all blocks from 0 through 999 were modified will produce only one line of output rather than 1000 separate lines. This option requests a separate line of output for every modified block.], map[description:Do not print any output, except for errors. This can be useful when you want to know whether a WAL summary file can be successfully parsed but don't care about the contents. names:[-q --quiet] signature:-q --quiet source_url:/docs/18/app-pgwalsummary.html summary:Do not print any output, except for errors. This can be useful when you want to know whether a WAL summary file can be successfully parsed but don't care about the contents.], map[description:Display version information, then exit. names:[-V --version] signature:-V --version source_url:/docs/18/app-pgwalsummary.html summary:Display version information, then exit.], map[description:Shows help about pg_walsummary command line arguments, and exits. names:[-? --help] signature:-? --help source_url:/docs/18/app-pgwalsummary.html summary:Shows help about pg_walsummary command line arguments, and exits.]

来源引用

完整定义与证据 JSON

定义来源

center · PostgreSQL 18 · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8

正文语言: en · ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8