GLOBAL_BGWRITER_STAT

GLOBAL_BGWRITER_STAT displays statistics about the bgwriter thread's activities on all instances.

**Table 1** GLOBAL_BGWRITER_STAT columns
Name	Type	Description
node_name	name	Instance name.
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	Total time spent on performing write operations during checkpointing (unit: ms).
checkpoint_sync_time	double precision	Total time spent on performing sync operations during checkpointing (unit: ms).
buffers_checkpoint	bigint	Number of buffers written during checkpointing.
buffers_clean	bigint	Number of buffers written by the BGWRITER thread.
maxwritten_clean	bigint	Number of times that the BGWRITER thread stops cleanup scanning because the number of pages refreshed in a single scan is too large.
buffers_backend	bigint	Number of buffers written directly by the backend.
buffers_backend_fsync	bigint	Number of times that the backend thread automatically executes fsync. Generally, fsync is called by the BGWRITER thread.
buffers_alloc	bigint	Number of buffers allocated
stats_reset	timestamp with time zone	Time when the statistics of the current row were reset last time.

Parent topic:Utility

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.