Postgres Overview

Performance metrics for Postgres

Postgres Overview screenshot 1

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

Revisions
RevisionDescriptionCreated
PostgreSQL

PostgreSQL

by Grafana Labs
Grafana Labs solution

Easily monitor your deployment of PostgreSQL, the open source relational database, with Grafana Cloud's out-of-the-box monitoring solution.

Learn more

Get this dashboard

Import the dashboard template

or

Download JSON

Datasource
Dependencies