Re: PostgreSQL monitoring

On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins <pglists@zeroaccess.org> wrote:

> Do you guys have any suggestions on monitoring tools for postgresql that
> would provide graphing of data & alerts ?
> I have looked and tried out hyperic, munin, Nimbus but was hoping to
> something better.

To monitor I use the following:

- pg_osmem: http://www.kennygorman.com/wordpress/?p=250
- pg_buffercache (contrib package in Debian)
- pg_top: http://ptop.projects.postgresql.org/
- ps
- pgd: http://www.kennygorman.com/wordpress/?p=260
- iotop: http://guichaz.free.fr/iotop/

And I am in the process of writing a bunch of scripts that the Zabbix
agent will execute to feed the server with information, so that alerts
and graphs can be produced.

--
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"