Paris, April 27th 2016 pgCluu 2.5 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. This release fixes some issues reported by users over past year and a full replacement of the flotr2 javascript chart library with jqplot. There's also some new interesting reports: * Add report for hash indexes. * Keep track of pg_settings and database/roles settings changes and show diff in the the reports. * Add report of pending restart in pg settings view. * Add information about percentage of timed against requested checkpoints. * Split database menu in submenu per set of 10 databases. * Add report of tables without indexes and tables with more than five indexes. * Add report about invalid index after concurrency build. * Add report of system and PostgreSQL uptime. * Add report of last statistics reset per database and report of last autovacuum and autoanalyze. * Add report of bgwriter last statistics reset in Home/Cluster view. * Add a non default configuration settings report. and useful features: * Autodetect timezone from csv data files and automatic adjustment of chart axis. * Add systemd start script. * Add collect of crontab information. * Add support to daylight saving. * Add compatibility with PostgreSQL 9.5 * Add ablity to export plots data as csv * Set legend table outside the graph. * Display specific titles and description for overall graphs. Note that a CGI script have been added to be able to perform temporal lookup in incremental pgCluu statistics, with predefined year, month, day and hour views. This is a work in progress, it will be available in next major release. Upgrade: you can safely override previous installation, backward compatibility with 2.4 version is preserved. See ChangeLog for a complete list of changes and bug fixes. The goal of this project is to provide a complete PostgreSQL auditing tool that don't need any dependency to be run easily to audit a local or remote server. 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 and maintained by Gilles Darold. * Web/Demo site: http://pgcluu.darold.net/ * Download: https://github.com/darold/pgcluu/releases * Development: https://github.com/darold/pgcluu * Documentation: https://github.com/darold/pgcluu/blob/master/README -- Gilles Darold Consultant PostgreSQL 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