POWA 1.2 is out !

Posted on 2014-10-28 by Dalibo

DALIBO is proud to present a new release of POWA, a 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 requests 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.

New metrics and a better UI

This release includes some new features and some fixes since the first public release.

The core is responsible of statistics gathering. It relies on pg_stat_statements. As a first change, in order to avoid storing useless informations, DEALLOCATE and BEGIN statements are now ignored by the core. The snapshot timestamps were fixed. In order to ease backups and diagnostics, now PoWA history tables are now marked as "to be dumped" by pg_dump. Performance for "per database aggregated stats" were also improved. And last thing, some more metrics were made available throught the SQL API : temporary data, I/O time, average runtime.

The UI was also improved. In addition to displaying the new available metrics, several features were added. First, the UI follows the selected time interval from page to page. The displayed metrics are now human readable. Also, the query metrics are now displayed on each query page. Each page now has a different title, regarding its context. In order to get a better display area, the original database selector as been removed. A menu entry now permits the user to navigate between databases. Several bugs were fixed, like the empty graph bug. Note that the configuration file has changed since the previous release.

For the complete list of changes, please checkout the release notes

For complete installation and upgrading instructions, please checkout the documentation

Credits

DALIBO would like to thank the users and developers who contributed to this release, especially Christopher Liu, menardorama, Victor D, Justin Miller, Arthur Lutz.

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@dalibo.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