PostgreSQL Workload Analyzer: collects query statistics from pg_stat_statements and related extensions into a history you browse in a web UI, with index suggestions.
Pricing and hosting
- Pricing
- Free
- Open source
- Yes (PostgreSQL)
- Self-hosted
- Yes
- Launched
- 2014
- Status
- Active
- Website
- powa.readthedocs.io
Plans and prices change; check the tool's own site before you decide.
What it does
Database monitoring checklist
5 of 10 confirmed in PoWA'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 Yes
- Index advice Yes
- Replication Not confirmed
- Locks and waits Yes
- Alerting Not confirmed
PostgreSQL-only workload analyzer; locks via wait-event sampling; no alerting or replication view found
Checked against: powa.readthedocs.io, powa.readthedocs.io (2), powa.readthedocs.io (3), github.com
Alternatives to PoWA
Other database monitoring tools. See all 19.
-
ClusterControl Severalnines platform to deploy, monitor and manage open source database clusters such as MySQL, PostgreSQL, MongoDB and Redis on your own servers or cloud. -
Percona Monitoring and Management Open source monitoring for MySQL, PostgreSQL, MongoDB and Valkey: a server and client agents collect metrics and query analytics, with Grafana-based dashboards and alerting. -
pganalyze Hosted Postgres performance monitoring that collects query statistics, plans and logs, and suggests indexes and VACUUM settings. The Enterprise plan can run on your own infrastructure. -
pgBadger PostgreSQL log analyzer that turns server logs into HTML reports on slow queries, errors, locks, checkpoints and connections. -
pgDash PostgreSQL monitoring service from RapidLoop that tracks queries, replication, locks and table stats over time, with alerts. A self-hosted edition is sold on annual licences. -
pgwatch PostgreSQL monitoring from Cybertec that gathers metrics with SQL queries and stores them in Postgres or Prometheus for the bundled Grafana dashboards. -
Redgate Monitor Database estate monitoring for SQL Server, PostgreSQL, Oracle and MySQL (formerly SQL Monitor), with query performance history, alerting and estate-wide health views. -
Releem Hosted agent-based service for MySQL, MariaDB and PostgreSQL that monitors performance, analyses slow queries and recommends configuration and index changes. -
SolarWinds Suite of network, server, database and application monitoring products, sold as self-hosted software and as the SaaS SolarWinds Observability. -
SolarWinds Database Performance Analyzer Wait-time based performance analysis for SQL Server, Oracle, MySQL, PostgreSQL and other engines, showing which queries and waits slow each database down. - Foglight Quest's monitoring suite, best known for database performance monitoring across SQL Server, Oracle, PostgreSQL and other engines, with workload analysis and alerting.
- mysqld_exporter Official Prometheus exporter for MySQL and MariaDB that exposes server status, InnoDB and replication metrics.