Request a Demo
8.3. Background Record Metrics
Prev UpChapter 8. MetricsHome Next

8.3. Background Record Metrics #

Metrics based on the pg_stat_bgwriter view:

  • postgresql.bgwriter.buffers_allocated

  • postgresql.bgwriter.buffers_backend_fsync

  • postgresql.bgwriter.buffers_backend

  • postgresql.bgwriter.buffers_checkpoint

  • postgresql.bgwriter.buffers_clean

  • postgresql.bgwriter.checkpoint_sync_time_milliseconds

  • postgresql.bgwriter.checkpoint_write_time_milliseconds

  • postgresql.bgwriter.checkpoints_requested

  • postgresql.bgwriter.checkpoints_timed

  • postgresql.bgwriter.maxwritten_clean

  • postgresql.bgwriter.stats_reset_unixtime

Starting from Postgres Pro and PostgreSQL 17, the metrics listed below are deprecated for the dropped columns. Use the checkpointer plugin instead.

  • postgresql.bgwriter.checkpoints_timed

  • postgresql.bgwriter.checkpoints_requested

  • postgresql.bgwriter.checkpoint_write_time_milliseconds

  • postgresql.bgwriter.checkpoint_sync_time_milliseconds

  • postgresql.bgwriter.buffers_checkpoint

  • postgresql.bgwriter.buffers_backend

  • postgresql.bgwriter.buffers_backend_fsync

Metrics based on the pg_stat_checkpointer view, available from Postgres Pro and PostgreSQL 17:

  • postgresql.checkpointer.num_timed

  • postgresql.checkpointer.num_requested

  • postgresql.checkpointer.restartpoints_timed

  • postgresql.checkpointer.restartpoints_req

  • postgresql.checkpointer.restartpoints_done

  • postgresql.checkpointer.write_time_milliseconds

  • postgresql.checkpointer.sync_time_milliseconds

  • postgresql.checkpointer.buffers_written

  • postgresql.checkpointer.stats_reset_unixtime

Metrics based on the pg_stat_checkpointer view, available from Postgres Pro and PostgreSQL 18:

  • postgresql.checkpointer.num_done

  • postgresql.checkpointer.slru_written

Prev Up Next
8.2. WAL Archiving Metrics Home 8.4. Table and Index Bloat Metrics
epub pdf