Help Center/ GaussDB/ Centralized_8.x/ Schemas/ DBE_PERF Schema/ Utility/ GLOBAL_BGWRITER_STAT

Updated on 2024-06-03 GMT+08:00

View PDF

GLOBAL_BGWRITER_STAT

GLOBAL_BGWRITER_STAT displays statistics about the background writer thread's activities on each node, as described in Table 1.

**Table 1** GLOBAL_BGWRITER_STAT columns
Name	Type	Description
node_name	name	Node 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 that has been spent in the portion of checkpoint processing where files are written to disk (unit: ms).
checkpoint_sync_time	double precision	Total time that has been spent in the portion of checkpoint processing where files are synchronized to disk (unit: ms).
buffers_checkpoint	bigint	Number of buffers written during checkpoints.
buffers_clean	bigint	Number of buffers written by the background writer thread.
maxwritten_clean	bigint	Number of times the background writer thread 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 a backend had to execute its own fsync call (normally the background writer thread handles those even when the backend does its own write).
buffers_alloc	bigint	Number of buffers allocated.
stats_reset	timestamp with time zone	Time at which these statistics were last reset.