Demo

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.

PostgreSQL Workload Analyzer

PoWA is a PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers.

For more information, please read:

• the Documentation : https://powa.readthedocs.io/

WARNING !!!

The current version PoWA is designed for all PostgreSQL versions supported by the community, and EOL versions down to 9.4.

If you're using PostgreSQL 9.3, you should use PoWA version 1.x:

• The code is here: https://github.com/powa-team/powa/tree/REL_1_STABLE
• The documentation is there: https://powa.readthedocs.io/en/rel_1_stable/

Where's the code ?

This repository contains the PoWA documentation. The source code is split in multiple separate projects:

• PoWA-archivist: the statistic collector
• PoWA-web: the graphic user interface
• pg_qualstats: an extension to sample predicate statistics
• pg_stat_kcache: an extension to sample O/S metrics

Some other extensions are supported, for a complete list please refer to the documentation.