Lu, Huayi
e6fa411af0
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
8.8 KiB
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 |