pg_stat_wal
The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- statistics
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- wal_records, wal_fpi, wal_bytes, wal_buffers_full, stats_reset
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_stat_wal view will always have a single row, containing data about WAL activity of the cluster.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| wal_records | bigint | Nullable | Total number of WAL records generated |
| wal_fpi | bigint | Nullable | Total number of WAL full page images generated |
| wal_bytes | numeric | Nullable | Total amount of WAL generated in bytes |
| wal_buffers_full | bigint | Nullable | Number of times WAL data was written to disk because WAL buffers became full |
| stats_reset | timestamp with time zone | Nullable | Time at which these statistics were last reset |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:b8d3902ed9b30f7f62dc6e3a44b29d1cb092554487c52eeadcb84463c457c95f
Text language: en · catalog-bilingual-repair:b8d3902ed9b30f7f62dc6e3a44b29d1cb092554487c52eeadcb84463c457c95f