SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_wal
Read PG 18 manual ↗The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster.
- Kind
- Statistics views
- Columns in this snapshot
- 5
- Definition source
- English manual
Columns 5
| 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
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
wal_records | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
wal_fpi | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
wal_bytes | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
wal_buffers_full | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
wal_write | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | · | · | · |
wal_sync | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | · | · | · |
wal_write_time | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | · | · | · |
wal_sync_time | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | · | · | · |
stats_reset | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● |
wal_fpi_bytes | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
Version history 4
- PG 18 → 19changed
- PG 17 → 18changed
- PG 16 → 17changed
- PG 13 → 14added
Definition snapshot: english-manuals:d6eca639b42213f9148cdcf92a9… · English manual source