PG_STAT_BGWRITER

PG_STAT_BGWRITER displays statistics about the background writer process's activity.

**Table 1** PG_STAT_BGWRITER columns
Name	Type	Description
checkpoints_timed	bigint	Number of scheduled checkpoints that have been performed
checkpoints_req	bigint	Number of requested checkpoints that have been performed
checkpoint_write_time	double precision	Time spent writing files to disks during checkpoints, in milliseconds.
checkpoint_sync_time	double precision	Time spent in synchronizing data to disks during checkpoints, in milliseconds.
buffers_checkpoint	bigint	Number of buffers written during checkpoints
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_backend	bigint	Number of buffers written directly by a backend
buffers_backend_fsync	bigint	Number of times that a backend has to execute fsync
buffers_alloc	bigint	Number of buffers allocated
stats_reset	timestamp with time zone	Time at which these statistics were reset