pgwatch vs SQLStream
pgwatch
cybertec-postgresql.comSQLStream
sql-stream.comSide by side
| Figure | pgwatch | SQLStream |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | — |
| Open source | — | — |
| Web | Yes | Yes |
| macOS | — | Yes |
| Linux | — | Yes |
| Self-hosted | Yes | — |
| Plans published | 1 | 1 |
| Spec score · Database Performance Monitoring Software | 8.2 (#7) | 7.1 (#18) |
| Purpose | pgwatch is a metrics collector and visualization solution for PostgreSQL databases. | SQLStream monitors database queries and uses AI agents to analyze query patterns and produce reports with suggested fixes. |
Plans
In their own words
pgwatch
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.
SQLStream
SQLStream has no write-up on Specifiction yet; its figures are above.