From: Jaume Sabater <jsabater@gmail.com>
To: Marcelo Martins <pglists@zeroaccess.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL monitoring
Date: Mon, 19 Jan 2009 16:56:23 +0100
Message-ID: <3786f7bb0901190756h5079eb3ap12bcedbe4ff2053@mail.gmail.com> (raw)
In-Reply-To: <14369888-7712-48EC-966C-7A0878360C22@zeroaccess.org>
References: <14369888-7712-48EC-966C-7A0878360C22@zeroaccess.org>
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"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jsabater@gmail.com, pglists@zeroaccess.org
Subject: Re: PostgreSQL monitoring
In-Reply-To: <3786f7bb0901190756h5079eb3ap12bcedbe4ff2053@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox