{"kind": "tool", "major": "18", "item": {"slug": "pg-walsummary", "name": "pg_walsummary", "name_zh": "", "category": "Server applications", "summary": "pg_walsummary \u2014 print contents of WAL summary files", "aliases": ["pg_walsummary"], "content_hash": "f0a32a58398e9e46cf8e3bbde7ee517839ecb9907499a197c30a6857fb88af97", "versions": {"17": {"facts": [{"label": "Documented executable", "value": "pg_walsummary"}, {"label": "Executable version", "value": "17.11"}, {"label": "Reference inventory", "value": "Server applications"}, {"label": "Option definition groups", "value": "4"}], "tables": [{"key": "options", "rows": [{"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.", "signature": {"url": "/docs/17/app-pgwalsummary.html", "text": "-i --individual"}}, {"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.", "signature": {"url": "/docs/17/app-pgwalsummary.html", "text": "-q --quiet"}}, {"summary": "Display version information, then exit.", "signature": {"url": "/docs/17/app-pgwalsummary.html", "text": "-V --version"}}, {"summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": {"url": "/docs/17/app-pgwalsummary.html", "text": "-? --help"}}], "title": "Documented options", "columns": [{"key": "signature", "label": "Option and arguments"}, {"key": "summary", "label": "Description"}]}], "options": [{"names": ["-i", "--individual"], "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.", "signature": "-i --individual", "source_url": "/docs/17/app-pgwalsummary.html", "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": ["-q", "--quiet"], "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.", "signature": "-q --quiet", "source_url": "/docs/17/app-pgwalsummary.html", "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": ["-V", "--version"], "summary": "Display version information, then exit.", "signature": "-V --version", "source_url": "/docs/17/app-pgwalsummary.html", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": "-? --help", "source_url": "/docs/17/app-pgwalsummary.html", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "label": "17.11", "major": "17", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/17/postgresql-17-A4.pdf", "bytes": 15521293, "pages": 3099, "sha256": "1991354df0dc89e70ec39328c28988ef8b19c6a93671dab3893650b63e9f4e36", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/17/postgresql-17-US.pdf", "bytes": 15398150, "pages": 3270, "sha256": "07696c8f38abf31babf22d2db337093936e7c472d2af36d050b000c49bbcf52c", "built_at": "2026-09-26"}}, "tree": "17", "index": "index.html", "major": "17", "pages": 1143, "release": "17.11", "source_url": "https://ftp.postgresql.org/pub/source/v17.11/postgresql-17.11.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "revision": "58419c9b0dd42cb34c8d53695bb025a7e582edf55ccd4c5bcb1c2c7c71a37487", "evidence_kind": "English manual and source declarations", "source_sha256": "dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979"}, "sources": [{"url": "/docs/17/app-pgwalsummary.html", "file": "app-pgwalsummary.html", "label": "17.11 English manual \u00b7 app-pgwalsummary.html", "anchor": "", "sha256": "b7daf37f671761f0f6a5f1f4897e7a0b4c98f3bc914ca541ec80713ab3b762e8"}, {"url": "/docs/17/reference-server.html", "file": "reference-server.html", "label": "Server applications inventory", "anchor": "", "sha256": "01f07993ff020684f4c290d17cdafa26fb17ea5c1d476bc3a5efc68bf8ddd9b9"}], "sections": [], "synopsis": ["pg_walsummary [ option ...] [ file ...]"], "signature": "pg_walsummary [ option ...] [ file ...]", "description": ["pg_walsummary \u2014 print contents of WAL summary files"], "environment": [], "manual_html": "
\n
\n
\n

pg_walsummary

\n

pg_walsummary \u2014 print contents of WAL summary files

\n
\n
\n

Synopsis

\n
\n

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

\n
\n
\n
\n

Description

\n

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.

\n

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.

\n
\n
\n

Options

\n
\n
\n
-i
--individual
\n
\n

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.

\n
\n
-q
--quiet
\n
\n

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.

\n
\n
-V
--version
\n
\n

Display version information, then exit.

\n
\n
-?
--help
\n
\n

Shows help about pg_walsummary command line arguments, and exits.

\n
\n
\n
\n
\n
\n

Environment

\n

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

\n
\n\n
", "manual_path": "app-pgwalsummary.html", "comparison_data": {"options": [{"names": ["-i", "--individual"], "signature": "-i --individual", "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": ["-q", "--quiet"], "signature": "-q --quiet", "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": ["-V", "--version"], "signature": "-V --version", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "signature": "-? --help", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "synopsis": ["pg_walsummary [ option ...] [ file ...]"], "environment": []}, "comparison_hash": "fb64f9cdf40e6149d88aceecaf06dca1b50a947b10b4f3e3cfe4e833dd789128"}, "18": {"facts": [{"label": "Documented executable", "value": "pg_walsummary"}, {"label": "Executable version", "value": "18.6"}, {"label": "Reference inventory", "value": "Server applications"}, {"label": "Option definition groups", "value": "4"}], "tables": [{"key": "options", "rows": [{"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.", "signature": {"url": "/docs/18/app-pgwalsummary.html", "text": "-i --individual"}}, {"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.", "signature": {"url": "/docs/18/app-pgwalsummary.html", "text": "-q --quiet"}}, {"summary": "Display version information, then exit.", "signature": {"url": "/docs/18/app-pgwalsummary.html", "text": "-V --version"}}, {"summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": {"url": "/docs/18/app-pgwalsummary.html", "text": "-? --help"}}], "title": "Documented options", "columns": [{"key": "signature", "label": "Option and arguments"}, {"key": "summary", "label": "Description"}]}], "options": [{"names": ["-i", "--individual"], "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.", "signature": "-i --individual", "source_url": "/docs/18/app-pgwalsummary.html", "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": ["-q", "--quiet"], "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.", "signature": "-q --quiet", "source_url": "/docs/18/app-pgwalsummary.html", "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": ["-V", "--version"], "summary": "Display version information, then exit.", "signature": "-V --version", "source_url": "/docs/18/app-pgwalsummary.html", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": "-? --help", "source_url": "/docs/18/app-pgwalsummary.html", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/app-pgwalsummary.html", "file": "app-pgwalsummary.html", "label": "18.6 English manual \u00b7 app-pgwalsummary.html", "anchor": "", "sha256": "d2721b711c04cfa23f2edc8552533bf1d515eec2406ce1ec728b71fd41d9f2ea"}, {"url": "/docs/18/reference-server.html", "file": "reference-server.html", "label": "Server applications inventory", "anchor": "", "sha256": "e9f8bbcc8e3641fadd1d20991e8aad6b532155b786ba5a1b7b364ec4f1a5bef3"}], "sections": [], "synopsis": ["pg_walsummary [ option ...] [ file ...]"], "signature": "pg_walsummary [ option ...] [ file ...]", "description": ["pg_walsummary \u2014 print contents of WAL summary files"], "environment": [], "manual_html": "
\n
\n
\n

pg_walsummary

\n

pg_walsummary \u2014 print contents of WAL summary files

\n
\n
\n

Synopsis

\n
\n

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

\n
\n
\n
\n

Description

\n

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.

\n

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.

\n
\n
\n

Options

\n
\n
\n
-i
--individual
\n
\n

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.

\n
\n
-q
--quiet
\n
\n

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.

\n
\n
-V
--version
\n
\n

Display version information, then exit.

\n
\n
-?
--help
\n
\n

Shows help about pg_walsummary command line arguments, and exits.

\n
\n
\n
\n
\n
\n

Environment

\n

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

\n
\n\n
", "manual_path": "app-pgwalsummary.html", "comparison_data": {"options": [{"names": ["-i", "--individual"], "signature": "-i --individual", "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": ["-q", "--quiet"], "signature": "-q --quiet", "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": ["-V", "--version"], "signature": "-V --version", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "signature": "-? --help", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "synopsis": ["pg_walsummary [ option ...] [ file ...]"], "environment": []}, "comparison_hash": "fb64f9cdf40e6149d88aceecaf06dca1b50a947b10b4f3e3cfe4e833dd789128"}, "19": {"facts": [{"label": "Documented executable", "value": "pg_walsummary"}, {"label": "Executable version", "value": "19beta4"}, {"label": "Reference inventory", "value": "Server applications"}, {"label": "Option definition groups", "value": "4"}], "tables": [{"key": "options", "rows": [{"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.", "signature": {"url": "/docs/19/app-pgwalsummary.html", "text": "-i --individual"}}, {"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.", "signature": {"url": "/docs/19/app-pgwalsummary.html", "text": "-q --quiet"}}, {"summary": "Display version information, then exit.", "signature": {"url": "/docs/19/app-pgwalsummary.html", "text": "-V --version"}}, {"summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": {"url": "/docs/19/app-pgwalsummary.html", "text": "-? --help"}}], "title": "Documented options", "columns": [{"key": "signature", "label": "Option and arguments"}, {"key": "summary", "label": "Description"}]}], "options": [{"names": ["-i", "--individual"], "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.", "signature": "-i --individual", "source_url": "/docs/19/app-pgwalsummary.html", "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": ["-q", "--quiet"], "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.", "signature": "-q --quiet", "source_url": "/docs/19/app-pgwalsummary.html", "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": ["-V", "--version"], "summary": "Display version information, then exit.", "signature": "-V --version", "source_url": "/docs/19/app-pgwalsummary.html", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": "-? --help", "source_url": "/docs/19/app-pgwalsummary.html", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "label": "19beta4", "major": "19", "channel": "preview", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/19/postgresql-19-A4.pdf", "bytes": 16064841, "pages": 3052, "sha256": "4dd099e4125c591128fc5f3ebd02178dc24781f9e5ae629f96d67c4c8547427b", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/19/postgresql-19-US.pdf", "bytes": 15974616, "pages": 3225, "sha256": "61971fa857f0956d47341a0388fa6af9ae10acf691d4b2fc009007d384b0342b", "built_at": "2026-09-26"}}, "tree": "19", "index": "index.html", "major": "19", "pages": 1155, "release": "19beta4", "source_url": "https://ftp.postgresql.org/pub/source/v19beta4/postgresql-19beta4.tar.bz2", "svg_assets": 5, "source_mode": "en SGML built with pinned official archive", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "revision": "1bbbbf4133d426f0e4304010688d2984c30fb67df0cc3a61b3e37eb3f6f37833", "evidence_kind": "English manual and source declarations", "source_sha256": "83157ee9c599d03b2f7a3d73ef3a56ec24e0e79cc2b3501a64d1364f56398c86"}, "sources": [{"url": "/docs/19/app-pgwalsummary.html", "file": "app-pgwalsummary.html", "label": "19beta4 English manual \u00b7 app-pgwalsummary.html", "anchor": "", "sha256": "b02aee9e1ece8963e83a5e8d9017049e9cb49c45791962dab2b4492483156bcd"}, {"url": "/docs/19/reference-server.html", "file": "reference-server.html", "label": "Server applications inventory", "anchor": "", "sha256": "425b070323b448b5516d2cb4e9e4ac77efb5d19dd4e8005d0ae1c61db9ec78e6"}], "sections": [], "synopsis": ["pg_walsummary [ option ...] [ filename ...]"], "signature": "pg_walsummary [ option ...] [ filename ...]", "description": ["pg_walsummary \u2014 print contents of WAL summary files"], "environment": [], "manual_html": "
\n
\n
\n

pg_walsummary

\n

pg_walsummary \u2014 print contents of WAL summary files

\n
\n
\n

Synopsis

\n
\n

pg_walsummary [option...] [filename...]

\n
\n
\n
\n

Description

\n

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.

\n

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.

\n
\n
\n

Options

\n
\n
\n
filename
\n
\n

Specifies the name of a WAL summary file, found in the pg_wal/summaries subdirectory of the data directory.

\n
\n
-i
--individual
\n
\n

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.

\n
\n
-q
--quiet
\n
\n

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.

\n
\n
-V
--version
\n
\n

Display version information, then exit.

\n
\n
-?
--help
\n
\n

Shows help about pg_walsummary command line arguments, and exits.

\n
\n
\n
\n
\n
\n

Environment

\n

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

\n
\n\n
", "manual_path": "app-pgwalsummary.html", "comparison_data": {"options": [{"names": ["-i", "--individual"], "signature": "-i --individual", "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": ["-q", "--quiet"], "signature": "-q --quiet", "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": ["-V", "--version"], "signature": "-V --version", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "signature": "-? --help", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "synopsis": ["pg_walsummary [ option ...] [ filename ...]"], "environment": []}, "comparison_hash": "9953ce3ab217d3e551699ca2681f1cba6b80e2744068c39c87ef0e528aee0bac"}, "20": {"facts": [{"label": "Documented executable", "value": "pg_walsummary"}, {"label": "Executable version", "value": "20devel"}, {"label": "Reference inventory", "value": "Server applications"}, {"label": "Option definition groups", "value": "4"}], "tables": [{"key": "options", "rows": [{"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.", "signature": {"url": "/docs/devel/app-pgwalsummary.html", "text": "-i --individual"}}, {"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.", "signature": {"url": "/docs/devel/app-pgwalsummary.html", "text": "-q --quiet"}}, {"summary": "Display version information, then exit.", "signature": {"url": "/docs/devel/app-pgwalsummary.html", "text": "-V --version"}}, {"summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": {"url": "/docs/devel/app-pgwalsummary.html", "text": "-? --help"}}], "title": "Documented options", "columns": [{"key": "signature", "label": "Option and arguments"}, {"key": "summary", "label": "Description"}]}], "options": [{"names": ["-i", "--individual"], "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.", "signature": "-i --individual", "source_url": "/docs/devel/app-pgwalsummary.html", "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": ["-q", "--quiet"], "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.", "signature": "-q --quiet", "source_url": "/docs/devel/app-pgwalsummary.html", "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": ["-V", "--version"], "summary": "Display version information, then exit.", "signature": "-V --version", "source_url": "/docs/devel/app-pgwalsummary.html", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": "-? --help", "source_url": "/docs/devel/app-pgwalsummary.html", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "label": "20devel", "major": "20", "channel": "devel", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/20/postgresql-20-A4.pdf", "bytes": 16030631, "pages": 3052, "sha256": "bd5d82c0ce38fc18f92a0447818a91a193a261776bca1c37564bf9a683e177d0", "built_at": "2026-09-28"}, "US": {"url": "/files/documentation/pdf/20/postgresql-20-US.pdf", "bytes": 15936613, "pages": 3223, "sha256": "d97d9e0db479a02f4234b175f50fcad70c3661619afc8d6df9b9437882e3c299", "built_at": "2026-09-28"}}, "tree": "0", "index": "index.html", "major": "20", "pages": 1156, "release": "20devel", "source_url": "https://ftp.postgresql.org/pub/snapshot/dev/postgresql-snapshot.tar.bz2", "svg_assets": 6, "source_mode": "en SGML built with pinned official archive", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41", "source_snapshot_utc": "26-Sep-2026 20:22"}, "revision": "2eba5e0fd4c3bffb2803247b6cd537878e9d6ee5a6dfbe3c50ece8b421b80918", "evidence_kind": "English manual and source declarations", "source_sha256": "4d3346909b201ac1648232cf290462a7070c119326f56196f1f0253ed80fae41"}, "sources": [{"url": "/docs/devel/app-pgwalsummary.html", "file": "app-pgwalsummary.html", "label": "20devel English manual \u00b7 app-pgwalsummary.html", "anchor": "", "sha256": "b90e2e6e1e7661bbbd0a1bc5b1dcd65764991d015b411a7b06634318d12d720d"}, {"url": "/docs/devel/reference-server.html", "file": "reference-server.html", "label": "Server applications inventory", "anchor": "", "sha256": "5532c1ebfb8c6f310301be63a28daf0ae212e2a78025bea61a1bdca99e02c43d"}], "sections": [], "synopsis": ["pg_walsummary [ option ...] [ filename ...]"], "signature": "pg_walsummary [ option ...] [ filename ...]", "description": ["pg_walsummary \u2014 print contents of WAL summary files"], "environment": [], "manual_html": "
\n
\n
\n

pg_walsummary

\n

pg_walsummary \u2014 print contents of WAL summary files

\n
\n
\n

Synopsis

\n
\n

pg_walsummary [option...] [filename...]

\n
\n
\n
\n

Description

\n

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.

\n

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.

\n
\n
\n

Options

\n
\n
\n
filename
\n
\n

Specifies the name of a WAL summary file, found in the pg_wal/summaries subdirectory of the data directory.

\n
\n
-i
--individual
\n
\n

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.

\n
\n
-q
--quiet
\n
\n

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.

\n
\n
-V
--version
\n
\n

Display version information, then exit.

\n
\n
-?
--help
\n
\n

Shows help about pg_walsummary command line arguments, and exits.

\n
\n
\n
\n
\n
\n

Environment

\n

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

\n
\n\n
", "manual_path": "app-pgwalsummary.html", "comparison_data": {"options": [{"names": ["-i", "--individual"], "signature": "-i --individual", "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": ["-q", "--quiet"], "signature": "-q --quiet", "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": ["-V", "--version"], "signature": "-V --version", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "signature": "-? --help", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "synopsis": ["pg_walsummary [ option ...] [ filename ...]"], "environment": []}, "comparison_hash": "9953ce3ab217d3e551699ca2681f1cba6b80e2744068c39c87ef0e528aee0bac"}}}, "snapshot": {"facts": [{"label": "Documented executable", "value": "pg_walsummary"}, {"label": "Executable version", "value": "18.6"}, {"label": "Reference inventory", "value": "Server applications"}, {"label": "Option definition groups", "value": "4"}], "tables": [{"key": "options", "rows": [{"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.", "signature": {"url": "/docs/18/app-pgwalsummary.html", "text": "-i --individual"}}, {"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.", "signature": {"url": "/docs/18/app-pgwalsummary.html", "text": "-q --quiet"}}, {"summary": "Display version information, then exit.", "signature": {"url": "/docs/18/app-pgwalsummary.html", "text": "-V --version"}}, {"summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": {"url": "/docs/18/app-pgwalsummary.html", "text": "-? --help"}}], "title": "Documented options", "columns": [{"key": "signature", "label": "Option and arguments"}, {"key": "summary", "label": "Description"}]}], "options": [{"names": ["-i", "--individual"], "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.", "signature": "-i --individual", "source_url": "/docs/18/app-pgwalsummary.html", "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": ["-q", "--quiet"], "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.", "signature": "-q --quiet", "source_url": "/docs/18/app-pgwalsummary.html", "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": ["-V", "--version"], "summary": "Display version information, then exit.", "signature": "-V --version", "source_url": "/docs/18/app-pgwalsummary.html", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "summary": "Shows help about pg_walsummary command line arguments, and exits.", "signature": "-? --help", "source_url": "/docs/18/app-pgwalsummary.html", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "related": [], "release": {"ref": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "label": "18.6", "major": "18", "channel": "stable", "manifest": {"pdf": {"A4": {"url": "/files/documentation/pdf/18/postgresql-18-A4.pdf", "bytes": 15865106, "pages": 3154, "sha256": "19512c405da53f9f7fcf0abba359223aa65f021be025bf3411381918f92e3190", "built_at": "2026-09-26"}, "US": {"url": "/files/documentation/pdf/18/postgresql-18-US.pdf", "bytes": 15748059, "pages": 3328, "sha256": "facbe6c229e598b872d3d98bef53308f46e06746006fa4590de9a7de9dd46319", "built_at": "2026-09-26"}}, "tree": "18", "index": "index.html", "major": "18", "pages": 1148, "release": "18.6", "source_url": "https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2", "svg_assets": 3, "source_mode": "en SGML built with pinned official archive", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "revision": "ee8d1a3612338fd9adf250730cb640fcc5233b5491337cc00a316a44e3a0b9f8", "evidence_kind": "English manual and source declarations", "source_sha256": "555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f"}, "sources": [{"url": "/docs/18/app-pgwalsummary.html", "file": "app-pgwalsummary.html", "label": "18.6 English manual \u00b7 app-pgwalsummary.html", "anchor": "", "sha256": "d2721b711c04cfa23f2edc8552533bf1d515eec2406ce1ec728b71fd41d9f2ea"}, {"url": "/docs/18/reference-server.html", "file": "reference-server.html", "label": "Server applications inventory", "anchor": "", "sha256": "e9f8bbcc8e3641fadd1d20991e8aad6b532155b786ba5a1b7b364ec4f1a5bef3"}], "sections": [], "synopsis": ["pg_walsummary [ option ...] [ file ...]"], "signature": "pg_walsummary [ option ...] [ file ...]", "description": ["pg_walsummary \u2014 print contents of WAL summary files"], "environment": [], "manual_html": "
\n
\n
\n

pg_walsummary

\n

pg_walsummary \u2014 print contents of WAL summary files

\n
\n
\n

Synopsis

\n
\n

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

\n
\n
\n
\n

Description

\n

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.

\n

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.

\n
\n
\n

Options

\n
\n
\n
-i
--individual
\n
\n

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.

\n
\n
-q
--quiet
\n
\n

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.

\n
\n
-V
--version
\n
\n

Display version information, then exit.

\n
\n
-?
--help
\n
\n

Shows help about pg_walsummary command line arguments, and exits.

\n
\n
\n
\n
\n
\n

Environment

\n

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

\n
\n\n
", "manual_path": "app-pgwalsummary.html", "comparison_data": {"options": [{"names": ["-i", "--individual"], "signature": "-i --individual", "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": ["-q", "--quiet"], "signature": "-q --quiet", "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": ["-V", "--version"], "signature": "-V --version", "description": "Display version information, then exit."}, {"names": ["-?", "--help"], "signature": "-? --help", "description": "Shows help about pg_walsummary command line arguments, and exits."}], "synopsis": ["pg_walsummary [ option ...] [ file ...]"], "environment": []}, "comparison_hash": "fb64f9cdf40e6149d88aceecaf06dca1b50a947b10b4f3e3cfe4e833dd789128"}, "comparison": {"left": "17", "right": "18", "status": "unchanged", "diff": ""}}