pgBadger 6.3 is out! - Mailing list pgsql-announce

Paris, France - Mars 30th, 2015

DALIBO is proud to announce the release of pgBadger 6.3.

pgBadger is a PostgreSQL performance analyzer, built for speed with
fully detailed reports based on your PostgreSQL log files.

This new release fixes several issues and adds some new reports:

  * A new per user details (total duration and times executed) for
    each query reported in Top Queries reports. The details are
    visible from a new button called "User(s) involved".
  * Add "Average queries per session" and "Average queries duration
    per session" in Sessions tab of the Global statistics.
  * Add connection time histogram.
  * Use bar graph for Histogram of query times and sessions times.

There's also some cool new features and options:

  * Add -L | --logfile-list option to read a list of logfiles from
    an external file.
  * Add support to log_timezones with + and - signs for timestamp
    with milliseconds (%m).
  * Add --noreport option to instruct pgbadger to not build any
    HTML reports in incremental mode. pgBadger will only create
    binary files.
  * Add auto detection of client=%h or remote=%h from the log so
    that adding a prefix is not needed when it respect the default
    of pgbadger.
  * Redefine sessions duration histogram bound to be more accurate.
  * Add new option -M | --no-multiline to not collect multi-line
    statement and avoid storing and reporting garbage when needed.
  * Add --log-duration option to force pgbadger to associate log
    entries generated by both log_duration=on and log_statement=all.

The pgbadger_tools script have also been improve with new features:

  * Add a new tool to pgbadger_tool to output top queries in CSV
    format for follow-up analysis.
  * Add --explain-time-consuming and --explain-normalized options
    to generate explain statement about top time consuming and top
    normalized slowest queries.

For the complete list of changes, please checkout the release note
on https://github.com/dalibo/pgbadger/blob/master/ChangeLog

===== Links & Credits =====

DALIBO would like to thank the developers who submitted patches and
the users who reported bugs and feature requests, especially briklen,
Guillaume Le Bihan, Rodolphe Quiedeville, Mael Rimbault, mbecroft,
Grzegorz Garlewicz, Bill Mitchell, Julien Rouhaud, jacksonfoz, Hubert
Depesz Lubaczewski, Paolo Cavallini, MarcoTrek, jirihlinka, Josh
Kupershmid, jason, Guillaume Lelarge and Bruno Almeida,

pgBadger is an open project. 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 on our mailing list.

Links :

  * Download : http://dalibo.github.io/pgbadger/
  * Mailing List :
https://listes.dalibo.com/cgi-bin/mailman/listinfo/pgbagder

--------------

**About pgBadger** :

pgBagder is a new generation log analyzer for PostgreSQL, created by
Gilles Darold (also author of ora2pg, the powerful migration tool).
pgBadger is a fast and easy tool to analyze your SQL traffic and
create HTML5 reports with dynamics graphs. pgBadger is the perfect
tool to understand the behavior of your PostgreSQL servers and
identify which SQL queries need to be optimized.

Docs, Download & Demo at http://dalibo.github.io/pgbadger/

--------------

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

--
Gilles Darold
Consultant PostgreSQL
http://dalibo.com - http://dalibo.org