GLOBAL_BGWRITER_STAT
GLOBAL_BGWRITER_STAT displays statistics about the bgwriter thread's activities on all instances.
| 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
