POWA 1.2 is out !

Paris, October 28th 2014

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(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