[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Database monitor (again)
From:       Nic Ferrier <nferrier () tapsellferrier ! co ! uk>
Date:       2005-03-31 22:01:20
Message-ID: 871x9vh3v3.fsf () tapsellferrier ! co ! uk
[Download RAW message or body]

Philip Hallstrom <postgresql@philip.pjkh.com> writes:

>>
>>> 2.  Statistics monitor (this is built in to the product):
>>> http://www.postgresql.org/docs/current/static/monitoring-stats.html
>>
>> Does anyone think an SNMP interface to these would be useful?
>
> I do.  Would make it easy to hook it up to MRTG, Cacti, or some other
> monitoring system.  Would be nice for graphing number of queries,
> average query length, queries per second that sort of stuff...

I don't think it would be difficult to spec a MIB for pg's stats.

I don't have much time for pg hacking... but I would think about doing
this if someone already involved in pg development were to help out.


Nic


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match
[prev in list] [next in list] [prev in thread] [next in thread]