diff options
| author | Fujii Masao <fujii@postgresql.org> | 2020-12-02 13:00:15 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2020-12-02 13:00:15 +0900 |
| commit | 01469241b2ff6f17fc0b3f20f01559145ffab29e (patch) | |
| tree | dc8dd4dbc8ea466e45afc4542215d5cbf395b623 /doc/src | |
| parent | 91624c2ff8809145880383b0fa84be0ee98f55b5 (diff) | |
| download | postgresql-01469241b2ff6f17fc0b3f20f01559145ffab29e.tar.gz postgresql-01469241b2ff6f17fc0b3f20f01559145ffab29e.zip | |
Track total number of WAL records, FPIs and bytes generated in the cluster.
Commit 6b466bf5f2 allowed pg_stat_statements to track the number of
WAL records, full page images and bytes that each statement generated.
Similarly this commit allows us to track the cluster-wide WAL statistics
counters.
New columns wal_records, wal_fpi and wal_bytes are added into the
pg_stat_wal view, and reports the total number of WAL records,
full page images and bytes generated in the , respectively.
Author: Masahiro Ikeda
Reviewed-by: Amit Kapila, Movead Li, Kyotaro Horiguchi, Fujii Masao
Discussion: https://postgr.es/m/35ef960128b90bfae3b3fdf60a3a860f@oss.nttdata.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/monitoring.sgml | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/doc/src/sgml/monitoring.sgml b/doc/src/sgml/monitoring.sgml index cc48c30ef30..52a69a53660 100644 --- a/doc/src/sgml/monitoring.sgml +++ b/doc/src/sgml/monitoring.sgml @@ -3449,6 +3449,33 @@ SELECT pid, wait_event_type, wait_event FROM pg_stat_activity WHERE wait_event i <tbody> <row> <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>wal_records</structfield> <type>bigint</type> + </para> + <para> + Total number of WAL records generated + </para></entry> + </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>wal_fpi</structfield> <type>bigint</type> + </para> + <para> + Total number of WAL full page images generated + </para></entry> + </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> + <structfield>wal_bytes</structfield> <type>numeric</type> + </para> + <para> + Total amount of WAL bytes generated + </para></entry> + </row> + + <row> + <entry role="catalog_table_entry"><para role="column_definition"> <structfield>wal_buffers_full</structfield> <type>bigint</type> </para> <para> |