| From: | "Jaume Sabater" <jsabater(at)gmail(dot)com> |
|---|---|
| To: | "Marcelo Martins" <pglists(at)zeroaccess(dot)org> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL monitoring |
| Date: | 2009-01-19 15:56:23 |
| Message-ID: | 3786f7bb0901190756h5079eb3ap12bcedbe4ff2053@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins <pglists(at)zeroaccess(dot)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"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cédric Villemain | 2009-01-19 16:10:07 | Re: PostgreSQL monitoring |
| Previous Message | Scott Marlowe | 2009-01-19 15:54:30 | Re: tuning tips, speed problem |