PGXC_STAT_BGWRITER
PGXC_STAT_BGWRITER displays statistics on the background writer of each node in the cluster. All columns except node_name are the same as those in the PG_STAT_BGWRITER view. This view is accessible only to users with system administrators rights.
| Column | Type | Description |
|---|---|---|
| node_name | Text | 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 | Time spent on writing files to the disk during checkpoints, in milliseconds |
| checkpoint_sync_time | Double precision | Time spent on synchronizing data to the disk 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
