System Catalogs / Statistics views
pg_stat_wal
Read the PG 18 manualThe pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster.
Reading PG 18current·documented in 7 of 24 versions, 14 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 5
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 5
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
wal_records | bigint | Total number of WAL records generated |
wal_fpi | bigint | Total number of WAL full page images generated |
wal_bytes | numeric | Total amount of WAL generated in bytes |
wal_buffers_full | bigint | Number of times WAL data was written to disk because WAL buffers became full |
stats_reset | timestamp with time zone | Time at which these statistics were last reset |
Column history across versions
Definition snapshot: english-manuals:9e12acc0a30ab462ba2ca1ac326… · English manual source