Skip to content

Version 3.3

Compare
Choose a tag to compare
@darold darold released this 02 Jun 08:49
· 57 commits to master since this release

2022-06-02 - Version 3.3

This release is a maintenance release that fixes issues reported since previous release. It also adds new reports and features.

  - Add TCP utilization and TCP errors reports, from sar -nTCP,ETCP.
  - Add a comment in the suggested index if it could be redundant
    with existing ones.
  - Add support to run pgcluu_collect as user with the pg_monitor role.

Here is the full list of changes since previous release.

  - Add support to run pgcluu_collect as user with the pg_monitor role.
    Thanks to Nicolas Gollet for the report.
  - Fix redundant index query to work with PG < 10, regexp_match() must be
    replaced by regexp_matches() with some additional rewrite.
  - Replace call to pg_ls_dir by pg_ls_waldir to be able to use pg_monitor
    privilege starting from PG10. Thanks to Nicolas Gollet for the report.
  - Fix impossibility to use --lock-timeout. Thanks to Christophe Courtois
    for the report.
  - Remove lock_timeout from internally set of PGOPTIONS when querying
    pgbouncer, the old value is restored after. Thanks to Christophe Courtois
    for the report.
  - Fix empty pgbouncer statistics file when running in interactive mode.
    Thanks to Christophe Courtois for the report.
  - Add a comment in the CREATE INDEX when the suggested index may be redundant
    with existing ones. Thanks to Christophe Courtois for the patch.
  - Fix false report of redundant index when the WHERE clause is different.
    Thanks to Guillaume Lelarge for the report.
  - Fix in pgcluu for OUTPUT_DIR always be quoted, especially if their value
    may contain a white space or separator character. Thanks to Nicolas Gollet
    for the patch.
  - Fix network errors disabled. Thanks to Christophe Courtois for the patch.
  - Add TCP utilization and TCP errors reports, from sar -nTCP,ETCP. Thanks to
    Christophe Courtois for the patch.
  - Fix pgbouncer command. Thanks to Nicolas Gollet for the patch.
  - Modification of the query on pg_stat_statement so that under PostgreSQL 13
    and higher total_time = total_plan_time + total_execution_time. Thanks to
    Nicolas Gollet for the patch.
  - Fix STATS_REPORT_RETENTION directory in config file. Don't prepend DESTDIR
    to paths in config file. Thanks to Christoph Berg for the patch.