pgCluu is an open source, free and platform-independent web-based and command-line application implemented in Perl and designed from the ground up to help users monitor and audit the performance of a PostgreSQL database server.
Features at a glance
The software is capable of performing a complete audit process of a PostgreSQL Cluster. It’s comprised of two tools, as well as a collector that can be used to grab statistics about the PostgreSQL cluster by using the sar and psql commands.
In addition, it comes with a grapher that will output the results as HTML reports and charts. The software displays statistics about global cluster information, statistics per database, and statistics about the hosting system. It is compatible with UNIX/Linux operating systems.
The web-based interface of the program is easy to use and intuitive, as you will always have quick access to system information, cluster, databases, pgBouncer and system components of the application. Access each one of them to get more options and get the job done without too much hassle.
Command-line options
A wide range of options are avaialble for the command-line component of the project, allowing the user to enable buffer cache statistics if the pg_buffercache plugin is installed, to specify the database name to connect to, to specify the database server host, to specify the socket directory, to specify the time to wait between runs, as well as to set a comma separated list of metrics to perform.
Among other command-line options, we can mention the ability to specify the database port to connect to, to disable collection of system statistics with sar and lookup of tablespace, to list available metrics actions that can be performed, to enable SSH and run sysstat remotely, to view a list of options to use for the SSH connection and to use a custom PID file.
What is new in this release:
New in pgCluu 2.3 (February 6th, 2015)
What is new in version 2.4:
- 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.
What is new in version 2.3:
- 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.
What is new in version 2.2:
- 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.
What is new in version 2.1:
- 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!
What is new in version 1.1:
- 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.
Requirements:
- Perl
Comments not found