Track total number of WAL records, FPIs and bytes generated in the cluster.
authorFujii Masao <fujii@postgresql.org>
Wed, 2 Dec 2020 04:00:15 +0000 (13:00 +0900)
committerFujii Masao <fujii@postgresql.org>
Wed, 2 Dec 2020 04:00:15 +0000 (13:00 +0900)
commit01469241b2ff6f17fc0b3f20f01559145ffab29e
treedc8dd4dbc8ea466e45afc4542215d5cbf395b623
parent91624c2ff8809145880383b0fa84be0ee98f55b5
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
doc/src/sgml/monitoring.sgml
src/backend/catalog/system_views.sql
src/backend/postmaster/pgstat.c
src/backend/utils/adt/pgstatfuncs.c
src/include/catalog/pg_proc.dat
src/include/pgstat.h
src/test/regress/expected/rules.out