pg_watch - PostgreSQL Monitoring Tool

pg_watch is a metrics collector and visualization solution for PostgreSQL databases. It was developed by CYBERTEC. This flexible, self-contained PostgreSQL monitoring tool brings your database monitoring to the next level.

Although there are many PostgreSQL monitoring solutions, most of them are too complex to set up, and too inflexible – they do not allow you to extend their functionality on your own. pg_watch changes all that by providing high flexibility, and by focusing solely on metrics gathering. The presentation side is left to the best dashboarding tool available.

How pg_watch works

pg_watch works as a remote metrics-gathering daemon, periodically connecting to the database as a normal user would, and reading out metrics provided by the Postgres statistics subsystem. This has the advantage that you don’t need any special user rights and you don’t have to install any extensions on the database server itself, making use in restricted environments (e.g. AWS RDS) possible.

Main Features

1-minute installation with Docker (custom installations still possible)
Superb overview of all database activities on a single page
Easy extensibility by defining metrics in pure SQL
Intuitive metrics presentation using the Grafana dashboarding engine. Users can create their own graphs (in addition to predefined ones) with just a couple of clicks
server log error monitoring (when installed on DB server)
Optional alerting (Mail, Slack, PagerDuty) provided by Grafana
Open Source software – free to extend
PostgreSQL versions 9.0+ supported

More details

Built in web-based management interface for managing monitored databases and metrics
Many options for metrics storage – InfluxDB, PostgreSQL, Prometheus, Graphite
Optional basic security by user authentication
Provides Optional “metrics fetching helper” stored procedures for reading out CPU load and pg_stat_statement info
Exposes logs for individual components over the web-based UI for easier troubleshooting

Visit our official website pgwatch.com for further information and instant downloading or read below for more details about pgwatch for enterprise-grade solutions.

Go to pgwatch.com

pg_watch: PostgreSQL Monitoring Tool at Scale

We’ve built pg_watch with scale-up in mind – it’s perfect for monitoring large infrastructures. If you represent a large-scale enterprise, pgwatch is the right monitoring solution for you.

pg_watch can be run for thousands of systems

We have tested pgwatch on large-scale systems and have gathered a large amount of field experience with it. If you want to monitor thousands of systems, pgwatch is certainly the tool you should use. If you want to use pg_watch for your setup, get in touch with us to find out more.

Contact us

Screenshots of the monitoring tool pg_watch

Logically arranged dashboards, i.e. for Global Health, Server Log Events, and Stat Activity, make pg_watch easy to operate:

pg_watch Quickstart Guide:

Start the Docker image with “docker run -d -p 3000:3000 -p 8080:8080 –name pw2 cybertec/pgwatch2”
Add your database to monitor it via management interface on port 8080
Wait a few minutes for the daemon to fetch data and then open Grafana on port 3000
ENJOY!

For additional support, we've also added a video: How to install PGWatch with Docker on Ubuntu