GLOBAL_BGWRITER_STAT
GLOBAL_BGWRITER_STAT displays statistics about the background writer process's activities on each node.
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 |
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 the backend had to execute its own fsync call (normally the background writer 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot