pg_stat_bgwriter

The pg_stat_bgwriter view will always have a single row, containing data about the background writer of the cluster.

Columns 4

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

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
`checkpoints_timed`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	·	·	·	·
`checkpoints_req`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	·	·	·	·
`checkpoint_write_time`	·	·	●	●	●	●	●	●	●	●	●	●	●	●	·	·	·	·
`checkpoint_sync_time`	·	·	●	●	●	●	●	●	●	●	●	●	●	●	·	·	·	·
`buffers_checkpoint`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	·	·	·	·
`buffers_clean`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`maxwritten_clean`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`buffers_backend`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	·	·	·	·
`buffers_backend_fsync`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	·	·	·	·
`buffers_alloc`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`stats_reset`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 9

Definition snapshot: english-manuals:a43f67b279d1d73d40aca5125c2… · English manual source