Postgres Overview
Performance metrics for Postgres
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
Data source config
Collector config:
Dashboard revisions
Upload an updated version of an exported dashboard.json file from Grafana
Revision | Decscription | Created | |
---|---|---|---|
Download |
Get this dashboard
Data source:
Dependencies: