Re: Innotop for postgresl - Mailing list pgsql-general

From Erik Jones
Subject Re: Innotop for postgresl
Date
Msg-id 2C9D7AD7-442C-4FEB-A1CF-B58957EA54D9@engineyard.com
Whole thread Raw
In response to Innotop for postgresl  (Alexis Michon <alexis.michon@ibcp.fr>)
List pgsql-general
On Jan 3, 2010, at 4:10 AM, Alexis Michon wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Hello,
>
> Is there any software for postgresql like innotop for mysql ?
> I would like to monitor postgresql with Cacti, but i didn't find any
> module for that in cacti, do you know a module for that ?

While some templates that already do this are fine, it's not hard to write some cacti graph templates that simply
executescripts that get their values from the pg_stat_get_*() functions directly:
http://www.postgresql.org/docs/8.4/interactive/monitoring-stats.html#MONITORING-STATS-VIEWS

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k






pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore
Next
From: "Bergbom Staffan"
Date:
Subject: Question on how to conditionally commit or rollback a sql-request