Enhancement proposition

[menardorama]

Hi,
I'm glad to see that dalibo is trying to build a tool that is lacking actually on postgresql.

We worked on a similar approach in my company few month ago and added several enhancements that I would like to propose :

• Implement pg_proctab (https://github.com/markwkm/pg_proctab) to add metrics for the sessions (cpu, memory, IO ...). This help a lot on identifing heavy sessions
• Add per object and per database statistics
• Add the functionnality to graph on all the metrics available
• Add a centralised repository
• Add a feature to send metrics to statd in order to generates dashboard in graphite (this help a lot for very big production systems). : http://pgxn.org/dist/pg_statsd
• Add an alerting system that we can couple with a nagios or zabbix....
• And even if it's not the same project : couple pgbadger to this tool !

[marco44]

Hi, and thanks for these ideas.

The centralized repository is already the subject of issue powa-team/powa#16.

Adding system metrics is already something we were thinking of. pg_proctab may be the right tool for the job, thanks.

The rest is harder to decide (and not a priority for the moment). We don't want to make a mess of the GUI too fast, so we are cautious about what metrics to add :)

pgbadger is made to generate static pages, so it would be hard to do this coupling. We discussed it with Gilles Darold, as he is one of the Dalibo crew too, while building POWA. I can't say "never", but not for now.

[menardorama]

OK thanks for your reply

[rjuju]

I'm moving this issue to powa-archivist repository.

Note also that the centralised repository has been introduced as of 4.0.0.