System Catalogs / Statistics views
pg_stat_bgwriter
Read the PG 18 manualThe pg_stat_bgwriter view will always have a single row, containing data about the background writer of the cluster.
Reading PG 18current·documented in 20 of 24 versions, 8.3 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 4
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 4
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
buffers_clean | bigint | Number of buffers written by the background writer |
maxwritten_clean | bigint | Number of times the background writer stopped a cleaning scan because it had written too many buffers |
buffers_alloc | bigint | Number of buffers allocated |
stats_reset | timestamp with time zone | Time at which these statistics were last reset |
Column history across versions
Version history 6
Definition snapshot: english-manuals:02741e530d66fd3b89a43c8d8d4… · English manual source