pgcluu
pgcluu copied to clipboard
darold
PostgreSQL Cluster performances monitoring and auditing tool
I have strange charts with pgcluu (CGI) - sometimes global connections and database sizes for Cluster is doubled for All (see below pictures for example - the orange line is...
Fix #154 With --rotate-daily: the OUT_DIR directory was overriden in the block dealing with --rotate-hourly Seems to be a consequence of 5e15d765
On Rocky 8, `--rotation-daily` spills data into `/var/lib/pgcluu/data` and the `2022/06/09` subdirectory. This is the same on Ubuntu. `--rotation-hourly` seems broken. I think that I have found why, PR in...
The missing indexes query is not partitioning_aware. In a db made with `pgbench --foreign-keys --partitions=2`, I get this: ```sql pgbench_accounts ║ CREATE INDEX CONCURRENTLY idx_pgbench_accounts_bid ON pgbench_accounts (bid) ; pgbench_accounts_1...
The WHERE clause doesn't seem to be checked. Here is a quick example: ``` CREATE TABLE t1 (id integer); CREATE INDEX ON t1(id) WHERE id=1; CREATE INDEX ON t1(id) WHERE...
About halt the time, the report generation fails with this error: FATAL: can't read file pgcluu_output_dir/./end-pg_stat_user_indexes.csv: No such file or directory I can create the file with `touch` and I...
Hi, Since version [4.20, linux kernel](https://kernelnewbies.org/Linux_4.20#Pressure_stall_information_for_better_overview_of_system_load) can provide pressure-stall information that could be useful to provide performance information about CPU, IO and memory starvation. It will be great to collect...
Leaving it here means it's specific to replication but, as far as I know, it's all the cancelled queries, with or without replication. It could stand on its own.
I succeeded in generating static html report,but got failed for cgi report. I used pgcluu_collectd command as below to collect statistics data,and made a cron task to generate bin file.But...
Hello, While reading Postgres [Don't do this wiki page](https://wiki.postgresql.org/wiki/Don't_Do_This) and this article https://www.depesz.com/2020/01/28/dont-do-these-things-in-postgresql/ : I came across this project https://gitlab.com/depesz/pgWikiDont Queries could be used in pgcluu to list antipatterns in...