Skip to content

Version 2.8
Compare
Choose a tag to compare
@darold darold released this 28 Nov 10:05
· 222 commits to master since this release
v2.8
bb07cc8

2018-11-28 - Version 2.8 released

This release is a minor release that fix some issues reported by
users over past months, it also adds some new reports:

  - Add disk space utilization report over time using df command
    for sysstat version older than 11.1.4.
  - Add report of percentage of disk space and inode used on each
    file system. The information is available in sar output since
    11.1.4 version.
  - Add PageTables information in SysInfo memory report.
  - Show database information about table/indexes in capture mode.
  - Add report of number of tasks currently blocked, waiting for I/O
    to complete "Run queue" report.
  - Add new report about system dirty memory that need to be written
    to disk as well as amount of active/inactive memory.
  - Show highest dirty memory to write and highest number of processes
    blocked in overall stats page.
  - Add report of crontab entries for the user running pgcluu.
  - Add report of installed PostgreSQL packages in main page.

New pgcluu_collectd command line option:

  - Add command line option --package-list to be able to set a custom
    command to list PostgreSQL packages. Default is to auto-detect
    package type between rpm and dpkg, using command 'rpm -qa' or
    'dpkg -l'. If you have an other system you can use this option to
    set a custom command. A filter on keyword 'postgres' is appended
    to the command: ' | grep postgres'.

Here are the complete list of bug fixes in this release:

  - Change the way sysstat version is checked and save the version
    into to sysinfo.txt file for use in pgcluu script.
  - Remove extra new line at end of data file generated by the
    patch on search_path securing.
  - Add collect of disk space and inode used over time stored in file
    fs_stat_use.csv. Need more work to avoid duplicate data with new
    versions of sar that already report fs space use.
  - Replace all call to Perl ternary operator with usual if-then-else
    statement. In some condition this operator do not works and makes
    pgcluu return negative values in overall stats. This was happening
    only when pgcluu encounter a stat reset in the data files. Thanks
    to Guillaume Lelarge for the report.
  - Remove /dev/loop from devices statistics report.
  - Add PageTables information in SysInfo memory report. Thanks to
    Adrien Neyrat for the patch.
  - Remove some unwanted metrics displayed in capture mode.
  - Show database information about table/indexes in capture mode.
  - Exclude /dev/loop from result of "df" command and squashfs from
    "mount -l" command.
  - Prevent pgcluu_collectd to stop before that all metrics collected
    from the current loop have been written to disk. When it receives
    the terminate signal (-k option) it previously stops immediately,
    the problem was that this can conduct to empty or incomplete data
    file. Now it waits until the loop is terminated before exiting.
  - Fix compression of hourly directory when -R | --rotate-hourly and
    -z | --compress options are enabled. The compression was called
    each loop and not at each hour rotation.
  - Add warning about mandatory use of -d option when pg_buffercache
    reports are enabled (-B) but pg_buffercache extention is not found
    in the connection database.
  - Fix missing buffercache statistics since secure path has been
    included in commit b61bf44. This required that pg_buffercache
    table call was prefixed by the public schema. Thanks to
    lobojohnson for the report.
  - Fix unwanted print of tablespace path in cluster reports.
  - Remove not useful information in buffercache graph legends.
  - CSS: Increase size of the sysinfo panel.
  - Adapt automatically pgCluu to changes in sar sysstat tool since
    version 11.5.7. As per sysstat commit 8d635e0: Replace "rd_sec/s"
    and "wr_sec/s" fields with "rkB/s" and "wkB/s". These fields are
    now expressed in kilobytes instead of sectors. Replace "avgrq-sz"
    field with "areq-sz". This field is now expressed in kilobytes
    instead of sectors. Rename "avgqu-sz" field to "aqu-sz" to make
    it consistent with iostat's output.
  - Add report of number of tasks currently blocked, waiting for I/O
    to complete to "Run queue" report. This information is available
    with sysstat >= 9.1.7
  - Show also highest dirty memory to write and highest number of
    processes blocked in main page.
  - Add new report about system dirty memory that need to be written
    to disk as well as amount of active/inactive memory. These metrics
    are available in recent sar/sysstat versions.
  - Add report of crontab entries.
  - Change icon for packages report.
  - Add report of PostgreSQL installed package in main page.
  - Add storage information about PostgreSQL packages installed on
    the system.
  - Add command line option --package-list to be able to set a custom
    command to list PostgreSQL packages. Default is to auto-detect
    package type between rpm and dpkg, using command 'rpm -qa' or
    'dpkg -l'. If you have an other system you can use this option to
    set a custom command. A filter on keyword 'postgres' is appended
    to the command: ' | grep postgres'.
Assets 2
Loading