pgwatch

Visit website Source code

PostgreSQL monitoring from Cybertec that gathers metrics with SQL queries and stores them in Postgres or Prometheus for the bundled Grafana dashboards.

Pricing and hosting

Pricing
Free
Open source
Yes (BSD-3-Clause)
Self-hosted
Yes
Launched
2011
Status
Active
Website
pgwat.ch

Plans and prices change; check the tool's own site before you decide.

What it does

Database monitoring checklist

6 of 10 confirmed in pgwatch's own documentation. The same checklist is used for every tool in Databases.

  • PostgreSQL Yes
  • MySQL or MariaDB No
  • SQL Server No
  • MongoDB No
  • Query statistics Yes
  • Explain plans Not confirmed
  • Index advice Yes
  • Replication Yes
  • Locks and waits Yes
  • Alerting Yes

PostgreSQL-only; alerting is done in the bundled Grafana

Checked against: github.com, github.com (2), pgwat.ch

Alternatives to pgwatch

Other database monitoring tools. See all 19.