pgCluu 1.1 released ------------------- PostgreSQL Cluster Utilization
pgCluu is a Perl program used to perform a full audit of a PostgreSQL Cluster performances. It is divided in two parts, a collector used to grab statistics on the PostgreSQL server using psql and sar, a reports builder that will generate all HTML and charts output. A demo site is available at http://pgcluu.darold.net/example/index.html This new release adds lot of report improvements and bug fixes. There is also several new features or reports : - 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. - Allow pgcluu to parse sar file generated from sa file, use commands like "sar -A -p -f /var/log/sysstat/sa*". - Split commit, rollback and backend graph by using a second yaxis for backend. - Add System Information report. - Move Cache hit/miss ratio on second yaxis and change dataset colors. - 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. and some more changes/fixes, see ChangeLog for a complete list. There's lot of others reports to be included: - Statistics reports concerning tables. - Statistics reports about pg_stat_statement. - More Sar statistics reports. - ... This will comes in next releases. The goal of this project is to provide a complete PostgreSQL auditing tool that don't need any dependency to be run on any server easily, "a la pgBadger". If you just have a sar output file, pgCluu can be use to draw graphs about the system utilization only. pgCluu is an original collection of tools built during my work at Dalibo. Those tools are published under the PostgreSQL License to be shared, any one is welcome to contribute. For more information take a look at http://pgcluu.darold.net/ View a sample report at http://pgcluu.darold.net/example/index.html About: ------ pgCluu is created by Gilles Darold (also author of ora2pg and pgbadger). * Web/Demo site: http://pgcluu.darold.net/ * Download: https://sourceforge.net/projects/pgcluu/ * Development: https://github.com/darold/pgcluu * Documentation: https://github.com/darold/pgcluu/blob/master/README -- Gilles Darold http://dalibo.com - http://dalibo.org -- Sent via pgsql-announce mailing list (pgsql-announce@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-announce