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.

PoWA (PostgreSQL Workload Analyzer) is a performance tool for PostgreSQL 9.4 and newer allowing to collect, aggregate and purge statistics on multiple PostgreSQL instances from various Stats Extensions.

Depending on your needs, you can either use the provided background worker (requires a PostgreSQL restart, and more suited for single-instance setups), or the provided PoWA-collector daemon (does not require a PostgreSQL restart, can gather performance metrics from multiple instances, including standby).

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 the real index

Additionnaly, the PoWA User Interface allows you to make the most of this information.

Main components

• PoWA-archivist is the PostgreSQL extension, collecting statistics.
• PoWA-collector is the daemon that gather performance metrics from remote PostgreSQL instances (optional) on a dedicated repository server.
• 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.

• Quickstart
• Remote setup
• Frequently Asked question
• Security
• Components
• Impact on performances
• Support
• Release Notes
• Contributing