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...
-philip
---------------------------(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