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