pgwatch vs Quest Foglight for Databases

pgwatch is a free, open-source metrics collector and visualization solution for PostgreSQL databases. A remote daemon periodically connects to databases and reads PostgreSQL statistics using a normal database user, without special database rights or server-side extensions. Grafana presents the metrics and lets users add graphs; optional alerts can go through Mail, Slack, or PagerDuty. Metrics can be extended using pure SQL, and supported storage options include PostgreSQL, Prometheus, JSON File, and RPC. A built-in web interface manages databases and metric definitions and displays logs. pgwatch supports PostgreSQL 14 and newer, including single instances, high-availability clusters, pooled environments using PgBouncer or Pgpool II, and Patroni cluster managers. It is self-hosted, with a one-minute Docker installation described alongside custom installation options. The FAQ says it can be deployed fully on premises. Some operating-system metrics may be unavailable on cloud-managed PostgreSQL services because of platform restrictions.

Quest Foglight for Databases has no write-up on Specifiction yet; its figures are above.