PoWA 1.2.1 released

Posted on 2015-01-20 by Dalibo

Paris, Jan. 20 2015

DALIBO is proud to present a new release of PoWA, a performance tool for PostgreSQL.

Please also note that the project has a new dedicated mailing list, available at powa-users@googlegroups.com (https://groups.google.com/forum/?hl=fr#!forum/powa-users)

Feel free to join and ask any question.

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 features and changed in UI

  • UI is now compatible with mojolicious 5.0 and more
  • UI can now connect to multiple servers, and credentials can be specified for each server
  • The timestamps are now displayed in ISO 8601 format
  • POWA_CONFIG_FILE variable has been added to allow a specific config file location and/or name
  • Better charts display on smaller screens

Credits

DALIBO would like to thank the users and developpers who contributed to this release, especially Ahmed Bessifi and Luis Pinto Da Costa.

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 to powa-users@googlegroups.com (https://groups.google.com/forum/?hl=fr#!forum/powa-users)

Links

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