You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Track total number of WAL records, FPIs and bytes generated in the cluster.
Commit 6b466bf 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
WHERE ((pg_stat_all_tables.schemaname <> ALL (ARRAY['pg_catalog'::name, 'information_schema'::name])) AND (pg_stat_all_tables.schemaname !~ '^pg_toast'::text));
2141
-
pg_stat_wal| SELECT w.wal_buffers_full,
2141
+
pg_stat_wal| SELECT w.wal_records,
2142
+
w.wal_fpi,
2143
+
w.wal_bytes,
2144
+
w.wal_buffers_full,
2142
2145
w.stats_reset
2143
-
FROM pg_stat_get_wal() w(wal_buffers_full, stats_reset);
2146
+
FROM pg_stat_get_wal() w(wal_records, wal_fpi, wal_bytes, wal_buffers_full, stats_reset);
0 commit comments