PG_STAT_BGWRITER Sistem Tablosu - View To Monitor The Overall I/O Activity Of The Database

Örnek

Şöyle yaparız

SELECT checkpoints_timed, checkpoints_req, buffers_checkpoint, buffers_clean, 
  maxwritten_clean, buffers_backend, buffers_alloc
FROM pg_stat_bgwriter;

Açıklaması şöyle

This query returns a single row with several columns that provide information about the background writer process. The columns show the number of checkpoints that have been performed, the number of buffers written during checkpoints, the number of buffers cleaned by the background writer, the maximum number of buffers written in a single clean pass, and the number of buffers allocated and used by backends.