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 type:
Collector plugins:
Collector config:
Dashboard revisions
Upload an updated version of an exported dashboard.json file from Grafana
| Revision | Decscription | Created | |
|---|---|---|---|
| Download |
Sign up for Grafana Cloud
Get up and running in minutes with the Grafana Cloud free tier, which includes free forever 10k metrics, 50GB logs, 50GB traces, 500 VUh, and more.
Get this dashboard
Data source:
Dependencies: