Updated on 2024-05-13 GMT+08:00

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