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.

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.