Re: Monitoring Postgresql performance

Arnau wrote:

> Hi all,
>
> I have been "googling" a bit searching info about a way to monitor
> postgresql (CPU & Memory, num processes, ... ) and I haven't found
> anything relevant. I'm using munin to monitor others parameters of my
> servers and I'd like to include postgresql or have a similar tool. Any
> of you is using anything like that? all kind of hints are welcome :-)

Probably, as you said, this is not so much relevant,
as it is something at *early* stages of usability :-)
but have you looked at pgtop?

The basic requirement is that you enable your postmaster
stats collector and query command strings.

Here is the first announcement email:
http://archives.postgresql.org/pgsql-announce/2005-05/msg00000.php

And its home on the CPAN:
http://search.cpan.org/dist/pgtop/pgtop

--
Cosimo