Re: Database monitor (again)

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