pgMonitor#
pgMonitor is an environment to visualise the health and performance of a PostgreSQL cluster. It combines a suite of tools to facilitate the collection of important metrics, including:
number of connections
Database size
Replication lag
Transaction wraparround
Extra space taken up by your tables and indexes
CPU, memory, I/O and uptime
It combines multiple open-source software packages to create a robust PostgreSQL monitoring environment, including:
- PostgreSQL Exporter
an open-source data export to Prometheus that supports collecting metrics from any PostgreSQL server ≥ 9.1.
- Prometheus
an open-source metrics collector that is highly customisable.
- Grafana
an open-source data visualiser that allows you to generate many different kinds of charts and graphs.
See also
Installation and configuration#
Installation and configuration instructions for each package are provided: