You can try powa at demo-powa.anayrat.info. Just click “Login” and try its features! Note that in order to get interesting metrics, resources have been limited on this server (2 vCPU, 384MB of RAM and 150iops for the disks). Please be patient when using it.
Thanks to Adrien Nayrat for providing it.
The PostgreSQL Workload Analyzer is performance tool for PostgreSQL 9.4 and superior allowing to collect, aggregate and purge statistics on multiple PostgreSQL instances from various sources. It is implemented as a background worker
This includes support for various stat extensions:
- pg_stat_statements, providing data about queries being executed
- pg_qualstats, providing data about predicates, or where clauses
- pg_stat_kcache, providing data about operating-system level cache
- pg_wait_sampling, providing data about wait events
It supports the following extension:
- HypoPG, allowing you to create hypothetical indexes and test their usefulness without creating them
Additionnaly, the PoWA User Interface allows you to make the most sense of this information.
- PoWA-archivist is the PostgreSQL extension, collecting statistics.
- PoWA-web is the graphical user interface to powa-collected metrics.
- Stat extensions are the actual source of data.
- PoWA is the whole project.
You should first take a look at the Quickstart guide.