Introducing POWA ! A new PostgreSQL Workload Analyzer

Paris, August 19th 2014

DALIBO is proud to present the first release of POWA, a brand new
performance tool for PostgreSQL.

Realtime traffic analysis and dynamic graphs

POWA is a workload analyzer that gives a clear view of the current
activity of your PostgreSQL servers with a query runtime graph and a
block hit/read graph along with a chart of time consuming request over
the specified time period.

If you zoom anywhere in one of the graphs, the chart will adjust and
show you which queries were running at that time. If you click on a
specific query, you will get additional graphs such as read/write time,
number of rows affected, local and shared hit, etc.

A bunch of PL functions are also available to access and manage the
stats.

Extending pg_stat_statements

Basically PoWA is a PostgreSQL extension designed to historize
information given by the pg_stat_statements extension. It provides SQL
SRF to gather useful information on a specified time interval.

This first release is ready for production but of course we will
continue to improve it. Please install it (or test our demo site) and
let's us know what you think of it. Right now what we need most is
feedback and new ideas, especially to improve the user experience and
the graphic interface...

PoWA is available under the PostgreSQL license. The main code is a
PostgreSQL extension written in C and SQL. The user interface is based
on Perl and Mojolicious. Obviously the stats are stored in a PostgreSQL
database :-)

For the complete list of changes, please checkout the release note on
https://github.com/dalibo/powa/blob/master/CHANGELOG.md

Credits

DALIBO would like to thank all the developers who contributed to this
release, especially : Marc Cousin for the original idea and Julien
Rouhaud for the hard work on the GUI.

POWA is an open project available under the PostgreSQL License. Any
contribution to build a better tool is welcome. You just have to send
your ideas, features requests or patches using the GitHub tools or
directly to powa(at)dalibo(dot)com

Links :

* Download : http://dalibo.github.io/powa/
* Demo : http://demo-powa.dalibo.com (login/pass = powa/demo)

________________________________________________________________________

About POWA :

PoWA is PostgreSQL Workload Analyzer that gathers performance stats and
provides real-time charts and graph to help monitor and tune your
PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.

Code & Demo at http://dalibo.github.io/powa/

________________________________________________________________________

About DALIBO :

DALIBO is the leading PostgreSQL company in France, providing support,
trainings and consulting to its customers since 2005. The company
contributes to the PostgreSQL community in various ways, including :
code, articles, translations, free conferences and workshops

Check out DALIBO's open source projects at http://dalibo.github.io

http://www.dalibo.com