Softpedia >Linux >System >Monitoring >pgCluu >  Changelog

pgCluu Changelog

What's new in pgCluu 2.4

Jan 6, 2016
  • Transfers per second (read/write/both) on all devices from sar -b
  • Transfers per second for each device from sar -d .
  • Number of tasks created per second
  • Number of context switches per seconds.
  • Improve pg_stat_statement report by adding all shared block stats and read/write I/O timing per query when track_io_timing is enabled.
  • Add device with highest tps on overall system information.

New in pgCluu 2.3 (Feb 6, 2015)

  • Report default parameters values set with ALTER DATABASE and ALTER ROLE in new menu item: "Database/Role Settings". Thanks to Thomas Reiss for the feature request.
  • Fix detection of disk device in sar file.
  • Add boot value to the settings report
  • Add Unit and Reset value in pg_settings report to highlight parameters where values have been changes outside the configuration file.
  • Fix handling of sysinfo information, and enhance .gitignore. Thanks to Julien Rouhaud for the patch.
  • Fix kernel.* and transparent_hugepage display on Sysinfo section. Thanks to Julien Rouhaud for the patch.

New in pgCluu 2.2 (Jan 5, 2015)

  • Increase copyright year to 2015.
  • Fix bug in database list extraction.
  • Fix query to get missing foreign key indexes. Thanks to Ronan Dunklau for the patch.
  • Add collect of transparent_hugepage information into sysinfo.txt file. (read from /sys/kernel/mm/transparent_hugepage/-)
  • Fix overwriting of idle_in_xact for all database, should be idle. Thanks to Guillaume Lelarge for the patch.
  • Fix query for missing indexes on FKs. The previous query reported every index that SHOULD exist for FKs, but was not filtering out the already existing ones. Thanks to Ronan Dunklau for the patch.
  • Do not report redundant indexes when one is partial and not the other one. Thanks to Ronan Dunklau for the report.
  • Fix statement to search redundant index by not reporting index that has uniqueness and not the other one. The statement now also reports duplicate indexes on the same column and not only composite indexes. Thanks to Ronan Dunklau for the report.
  • Divide Devices menu by part of 10 devices. Useful when there is plenty of disk devices.
  • Add --from-sa-file to allow parsing of sar output coming from a sa daily file.
  • Fix call to local sar command and limit test on application_name for pg version >= 9.0. Thanks to Julien Rouhaud for the report.
  • Set application_name to pgcluu before collecting data and exclude from pg_stat_activity queries generated by pgcluu.

New in pgCluu 2.1 (Dec 11, 2014)

  • This new release adds lot of report improvements and bug fixes. There is also several new features or reports :
  • Allow system information commands to be executed remotely.
  • Allow sar to be executed on a remote server using a ssh connection.
  • New report of connections waiting for a lock.
  • Add average duration time in statement report.
  • New pg_stat_statements report.
  • Add pg_default and pg_global to tablespace size report.
  • New options to pgcluu_collectd:
  • -M or --max-size option to allow an output directory size limit.
  • --no-database to avoid collecting statistics from a database.
  • -C count to terminate program after collecting data for X times.
  • -E or --end-after to terminate program after for some time.
  • -V or --version to show version information.
  • And some more changes/fixes!

New in pgCluu 1.1 (Jan 30, 2014)

  • Format mouse tracker on graphs to show all dataset values at a time.
  • Add run queue length report to system menu.
  • Add checkpoint write and sync times reports.
  • Add report of PostgreSQL version
  • Split background writer buffer and count statistics into separated reports.
  • Add report of maxwritten_clean into bgwriter reports.
  • Add report of kernel parameters to the system info page.
  • Add collect of system kernel tuning parameters.
  • Remove embedded CSS and javascript on each HTML page, resources are now automatically copied into the output directory if not already present. Thanks to Guillaume Lelarge for the suggestion.
  • Allow pgcluu to parse sar file generated from sa file, use commands like "sar -A -p -f /var/log/sysstat/sa*". Thanks to Julien Rouhaud for the feature request.
  • Split commit, rollback and backend graph by using a second yaxis for backend. Thanks to GUillaume Lelarge for the report.
  • Add System Information report.
  • Move Cache hit/miss ratio on second yaxis and change dataset colors. Thanks to Guillaume Lelarge for the report.
  • Add collect of OS release information.
  • Allow pgcluu_collectd to grab OS information (cpu, memory, etc.) and add --os-info option to only grab that information (for testing).
  • Reformat dashboard information.
  • Add -z | --timezone to set the hour(s) from GMT time to adjust times on sar report. Thanks to Bricklen for the feature request. and some more changes/fixes:
  • Add vertical crosshair on graph.
  • Update copyright date to 2014
  • Disable database report of number of canceled queries when not on hot standby node.
  • Disable checkpoint write report following the pg version (< 9.2).
  • Disable temporary files and deadlocks reports following the postgresql version (< 9.2).
  • Add storage of pg version into sysinfo.txt
  • Fix missing legend of checkpoints_timed in checkpoint report.
  • Fix warning on META_MERGE for ExtUtils::MakeMaker < 6.46. Thanks to Julien Rouhaud for the patch.
  • Fix typo in pgcluu_collectd calls. Thanks to Jacky Rigoreau for the report.
  • Fix issue where information slide was not displayed when clicking on the information button.
  • Change documentation about resources files that are now autogenerated.
  • Fix grab of statistics from an 8.4 cluster (access to not-available-yet statistics catalogs). Thanks to Guillaume Lelarge for the report.
  • Fix issue on parsing CentOs release. Thanks to bricklen for the help.
  • Fix issue "Use of uninitialized value $val in substitution line 3312". Thanks to bricklen for the report.
  • Fix call method "print" on an undefined value at ./pgcluu line 1303. Thanks to Guillaume Lelarge for the report.
  • Fix sar dashboard report.
  • Remove decimal from hit cache ratio report. Thanks to Guillaume Lelarge for the report.
  • Dashboard review: cluster label rewrite, remove empty values from report, add start/end date of database stats and sar stats. Thanks to Guillaume Lelarge for the feature/change requests.
  • Fix some warning on uninitialized value on dashboard. Thanks to Julien Rouhaud for the report.
  • Fix Illegal division by zero at ./pgcluu line 1132. Thanks to Julien Rouhaud for the report.
  • Fix issue in building timestamps in sar data. Thanks to Bricklen for the report.
  • Fix sysstat version execution error with locale different to C or en_*. Thanks to forall for the report.
  • Fix broken sar charts when collect time is greater than 24 hours.
  • Add -z | --timezone option to documentation.
  • Fix error: print() on closed filehandle GEN9 at pgcluu line 1942. Thanks to Bricklen for the report.