Re: Innotop for postgresl

From: Erik Jones <ejones(at)engineyard(dot)com>
To: Alexis Michon <alexis(dot)michon(at)ibcp(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Innotop for postgresl
Date: 2010-01-04 21:59:52
Message-ID: 2C9D7AD7-442C-4FEB-A1CF-B58957EA54D9@engineyard.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 execute scripts 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2010-01-04 22:02:13 Re: Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore
Previous Message Matthias Dietrich 2010-01-04 21:35:33 Upgraded from Leopard to Snow Leopard - PostgreSQL won't start anymore