diff options
| author | Andres Freund <andres@anarazel.de> | 2014-09-19 16:33:16 +0200 |
|---|---|---|
| committer | Andres Freund <andres@anarazel.de> | 2014-09-19 16:33:16 +0200 |
| commit | bdd5726c347016ea34e9fb68d1b8b71046e25d2e (patch) | |
| tree | 2569cdff72f079c6c7a6c78e8e1cfdb01c43136f /doc/src | |
| parent | 728f152e07f998d2cb4fe5f24ec8da2c3bda98f2 (diff) | |
| download | postgresql-bdd5726c347016ea34e9fb68d1b8b71046e25d2e.tar.gz postgresql-bdd5726c347016ea34e9fb68d1b8b71046e25d2e.zip | |
Add the capability to display summary statistics to pg_xlogdump.
The new --stats/--stats=record options to pg_xlogdump display per
rmgr/per record statistics about the parsed WAL. This is useful to
understand what the WAL primarily consists of, to allow targeted
optimizations on application, configuration, and core code level.
It is likely that we will want to fine tune the statistics further,
but the feature already is quite helpful.
Author: Abhijit Menon-Sen, slightly editorialized by me
Reviewed-By: Andres Freund, Dilip Kumar and Furuya Osamu
Discussion: 20140604104716.GA3989@toroid.org
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/pg_xlogdump.sgml | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/doc/src/sgml/pg_xlogdump.sgml b/doc/src/sgml/pg_xlogdump.sgml index 1d1a2cea870..d9f4a6a499c 100644 --- a/doc/src/sgml/pg_xlogdump.sgml +++ b/doc/src/sgml/pg_xlogdump.sgml @@ -180,6 +180,18 @@ PostgreSQL documentation </varlistentry> <varlistentry> + <term><option>-z</option></term> + <term><option>--stats[=record]</option></term> + <listitem> + <para> + Display summary statistics (number and size of records and + full-page images) instead of individual records. Optionally + generate statistics per-record instead of per-rmgr. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><option>-?</></term> <term><option>--help</></term> <listitem> |