pg_stat_wal
A statistics view showing information about WAL activity
This entry relates to a PostgreSQL feature which is part of PostgreSQL 14, due to be released in late 2021.
pg_stat_wal is a statistics view showing information about WAL activity.
pg_stat_wal was added in PostgreSQL 14. Note that additional columns may be added before the final PostgreSQL 14 release.
Change history
- PostgreSQL 14
- added (commit 8d9a9359)
Examples
postgres=# SELECT * FROM pg_stat_wal;
wal_buffers_full | stats_reset
------------------+------------------------------
272 | 2020-10-02 18:16:55.66037+02
(1 row)
References
- PostgreSQL 14 documentation: pg_stat_wal
Useful links
- pgsql-hackers thread: New statistics for tuning WAL buffer size
- pgsql-hackers thread: Add statistics to pg_stat_wal view for wal related parameter tuning
Categories
See also
wal_buffers