Toronto, Canada July 11th 2023
## pgCluu - 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 is a maintenance release that fixes issues reported since the past
six months and adds support to PostgreSQL 16.
- Fix pgcluu for PG16 changes on pg_stat_user_indexes.
- Fix live/dead tuples statistics.
- Add e as expression for kind of extended statistics.
- Add --disable-pidstat option to disable the collect of metrics from the
pidstat command. This can be useful with old versions of pidstat that do
not support the -U option.
- If on a secondary server, don't execute pg_current_wal_lsn().
- Use relispartition only for PG version 10 and upper.
Upgrade: you can safely override previous installation, backward
compatibility with previous versions 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
[https://pgcluu.darold.net/](https://pgcluu.darold.net/)
View a sample report at http://pgcluu.darold.net/example/index.html
## Links & Credits
I would like to thank all users who submitted patches and users
who reported bugs and feature requests, they are all cited
the ChangeLog file.
pgCluu is an open project. Any contribution to build a better tool is
welcome. You just have to send your ideas, features requests or patches
using the GitHub tools or directly to gil...@darold.net.
Links:
## About:
pgCluu is created and maintained by Gilles Darold.
* Web/Demo site: [https://pgcluu.darold.net/](https://pgcluu.darold.net/)
* Download:
[https://github.com/darold/pgcluu/releases](https://github.com/darold/pgcluu/releases)
* Development:
[https://github.com/darold/pgcluu](https://github.com/darold/pgcluu)
* Documentation:
[https://github.com/darold/pgcluu/blob/master/README](https://github.com/darold/pgcluu/blob/master/README)
