Philip Hallstrom <[EMAIL PROTECTED]> 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