Postgres Overview

Dashboard

Performance metrics for Postgres
Last updated: a year ago

Downloads: 1256

  • c6058f17a4e54c8fb40cf9783cb19fcb.png
    c6058f17a4e54c8fb40cf9783cb19fcb.png

Dashboard allow to monitor:

  • rows fetched/returned/inserted/updated/deleted per second
  • total qps based on commits and rollbacks
  • buffers state
  • deadlocks and conflicts graph
  • cache hit ratio graph
  • number of active connections

The author assumes that the metrics are scraped from various hosts and databases. That's why there are placed two templates: $host and $db. Graphs would change accordingly to selected value.

Requirements: Dashboard is based on the https://github.com/wrouesnel/postgres_exporter metrics