PostgreSQL Statistics
65,989
Get Dashboard

Created 7/1/2018

Updated 7/2/2018

Revision 1

Description

This dashboard monitors PostgreSQL server health and configuration impact through metrics derived from pg_static and pg_settings_* sources, offering a snapshot of runtime statistics and resource settings. Key features include time-series views of memory and cost parameters such as pg_settings_shared_buffers_bytes, pg_settings_effective_cache_size_bytes, and pg_settings_work_mem_bytes, plus a focus on connections and transaction activity with panels like Max Connections, Connections, and Transactions. It highlights performance sensitivity through metrics like pg_settings_random_page_cost, pg_settings_seq_page_cost, and pg_settings_max_wal_size_bytes, and surfaces operational bottlenecks with panels such as Lock Tables, Conflicts/Deadlocks, and Read Stats / Change Stats.

Screenshots

Source Grafana.com

Used Metrics 33

Get Dashboard✕

Download

Copy to Clipboard