pg_stat_bgwriter
The pg_stat_bgwriter view will always have a single row, containing data about the background writer 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
- buffers_clean, maxwritten_clean, buffers_alloc, stats_reset
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_stat_bgwriter view will always have a single row, containing data about the background writer of the cluster.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| buffers_clean | bigint | Nullable | Number of buffers written by the background writer |
| maxwritten_clean | bigint | Nullable | Number of times the background writer stopped a cleaning scan because it had written too many buffers |
| buffers_alloc | bigint | Nullable | Number of buffers allocated |
| 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:408e177d2a00f15b8c10cd4608d7dc93d0ee006a42775157678ab7c74833fc24
Text language: en · catalog-bilingual-repair:408e177d2a00f15b8c10cd4608d7dc93d0ee006a42775157678ab7c74833fc24