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