PG_STAT_BGWRITER
PG_STAT_BGWRITER displays statistics about the background writer process's activity.
| Name | Type | Description |
|---|---|---|
| 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 amount of time that has been spent in the portion of checkpoint processing where files are written to disk, in milliseconds |
| checkpoint_sync_time | double precision | Total amount of time that has been spent in the portion of checkpoint processing where files are synchronized to disk, 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 |
Last Article: PG_STAT_BAD_BLOCK
Next Article: PG_STAT_DATABASE
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.