Postgres Overview
190,359 5.0 (1 reviews)

Created 9/15/2016
Updated 8/13/2018
Revision 2
Grafana Version >=5.2.0-pre1
Datasources
Prometheus

Description

Monitors PostgreSQL system activity and health with a focus on query throughput, storage I/O, and connection workload. Key metrics include pg_stat_database_tup_fetched/_returned/_inserted/_updated/_deleted to gauge table activity, pg_stat_database_xact_commit and pg_stat_database_xact_rollback for transaction volatility, and background write signaling via pg_stat_bgwriter_buffers_alloc, _fsync, and _buffers_backend* to assess I/O efficiency and buffering behavior. The dashboard highlights panels for Rows, QPS, Buffers, Conflicts/Deadlocks, Cache hit ratio, and active connections to provide a concise view of throughput, contention, cache effectiveness, and connection pressure.

Screenshots

Source Grafana.com

Used Metrics 17

Get Dashboard
Download
Copy to Clipboard