PoWA 3.0.0 released

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Paris, December 07 2015

DALIBO is proud to present the third release of PoWA, the PostgreSQL
Workload Analyzer.

Realtime traffic analysis and dynamic graphs
- --------------------------------------------

PoWA is a workload analyzer that gives a clear view of the activity of
your PostgreSQL servers with a query runtime graph and a block
hit/read graph along with a chart of time-consuming queries 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.

Better predicate analyzer
- -------------------------

The pg_qualstats (https://github.com/dalibo/pg_qualstats) extension
stores new counters. It's now possible to know the most executed
predicates in relation to all the related queries. It also tracks
non-normalized queries so that it’s possible to execute an EXPLAIN of
any query tracked by pg_stat_statements.

Database global optimization
- ----------------------------

PoWA is now able to use statistics about every predicate used by any
query executed on a database to suggest the smallest index set that
optimizes every one of those predicates.

In particular, the heuristics place heavy emphasis in consolidating
many indexes into one by giving preference to definitions spanning
multiple columns. This can provide new information about the actual
load and correlation between predicates that are traditionally hard to
discover for the DBA.

Index suggestion check
- ----------------------

Thanks to the HypoPG (https://github.com/dalibo/hypoopg) extension,
the benefits of the suggested index creations can automatically be
checked by running the queries against hypothetical indexes.

You can see instantly if the suggested index is relevant and how much
it'll improve the query.

Credits
- -------

DALIBO would like to thank the users and developers who contributed to
this release.

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, patches or features requests using the GitHub tools or to
https://groups.google.com/forum/?hl=fr#!forum/powa-users

Links
- -----

For PoWA 3.0.0:

- - Download: http://dalibo.github.io/powa/
- - Demo: http://demo-powa.dalibo.com (login/pass = powa/demo)
- - Doc: http://powa.readthedocs.org
- - Mailing list: https://groups.google.com/forum/?hl=fr#!forum/powa-users
- - Issues: https://github.com/dalibo/powa/issues

For the stats extensions:

- - pg_qualstats: https://github.com/dalibo/pg_qualstats
- - pg_stat_kcache: https://github.com/dalibo/pg_stat_kcache
- - HypoPG: https://github.com/dalibo/hypopg

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.

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/
- --
Julien Rouhaud
http://dalibo.com - http://dalibo.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (GNU/Linux)

iQEcBAEBAgAGBQJWZb2RAAoJELGaJ8vfEpOqX/8H/3roKwa/Q9yIZtjQoIPjB09/
OyAt/Qhi34XiQc5Z+ypOGb/r8za3GcIPZZSC3Pxb77wjZ6EYJPIlpjxxf2vwGKC6
AaRQQS49zIqXfA/ZBcgXVTnaxlu6+2M251XiVisM0A3VBl5FojhfA/2HTMP54e5H
2Hi1lOBRY0eRKC5HdfPiG8iRTBDRR1KuizoLjBNqzi3aDjfd/7qjdFccJe0oa/S5
+Fg2lCXGnt8tnM3Qi9t4g1nx9K7lXmvYo2CivZ1b02zqZ9GDY6iJyaKlxfA8mEoa
rAsPyFa5cI1hHQp977BIcRlSHqGPTXQ2JZyco8bhaRmJTLDmF8NsaQyNuzdCuTs=
=NJhG
-----END PGP SIGNATURE-----