PostgreSQL 17 ← 16
− checkpoints_timed− checkpoints_req− checkpoint_write_time− checkpoint_sync_time− buffers_checkpoint− buffers_backend− buffers_backend_fsyncCatalog description updated
← Catalog atlas / pg_stat_bgwriter
STATISTICS VIEW · Statistics view
pg_stat_bgwriter
The pg_stat_bgwriter view will always have a single row, containing data about the background writer of the cluster.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_stat_bgwriterPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
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 |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column typePresentAdded / type or attribute changeRemoved
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsPostgreSQL 17 ← 16
PostgreSQL 13 ← 12
PostgreSQL 12 ← 11
PostgreSQL 10 ← 9.6
PostgreSQL 9.6 ← 9.5
PostgreSQL 9.5 ← 9.4
PostgreSQL 9.4 ← 9.3
PostgreSQL 9.2 ← 9.1
PostgreSQL 9.1 ← 9.0
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.