pgwatch on Ubuntu 24.04

Azure Observability

PostgreSQL monitoring that shows you live database health from the first boot

Base
Hardened build
minimal ports, security patches applied at build time
Access
Unique credentials
generated on first boot, readable only by root
Verified
Boots working
services pass a health gate before release
Support
24/7, 365 days
by email and live chat, 24 hour response SLA

Overview

pgwatch is an open source PostgreSQL monitoring stack: a metrics collector, a metrics store and a large library of ready made dashboards. It gathers hundreds of statistics from the databases you point it at, keeps them on a retention schedule, and renders them as charts covering connections, throughput, query performance, table and index behaviour, replication and vacuum activity.

Why the cloudimg image

The cloudimg image is a complete appliance rather than a set of parts: the collector, the metrics store and the dashboard UI are installed, wired together and provisioned with the full bundled dashboard library. It also monitors its own bundled database from the first boot, so the dashboards show live data with no configuration at all. Every secret is generated per virtual machine before any service starts, the database and the administrative API are held on loopback, and a paired deployment guide plus 24/7 support come with it.

Common uses

  • Monitor PostgreSQL health and query performance across a fleet
  • Investigate slow queries, table bloat and lock contention
  • Keep a retained history of database metrics you host yourself

See it running

Real screenshots taken while testing this image against its deployment guide.

pgwatch on Ubuntu 24.04 screenshot 1 pgwatch on Ubuntu 24.04 screenshot 2 pgwatch on Ubuntu 24.04 screenshot 3 pgwatch on Ubuntu 24.04 screenshot 4