PostreSQL Workload Analyzer

Note

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:

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.

Main components

  • 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.