-----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----- -- Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-announce
