Re: Performance Monitoring of PostGRE

In response to Bobby Dewitt <Bdewitt(at)appriss(dot)com>:

> I think by AWR he is referring to Oracle's Automatic Workload Repository. It automatically gathers information on wait events, object usage, session and system statistics, etc. It also provides a nice report of what is going on in your database and can help identify bottlenecks that may be causing performance issues. I'm still new to PostgreSQL, but I don't believe there is anything available like this.
>
> As far as monitoring database availability goes, I'm working on a plugin for Oracle's OEM (Oracle Enterprise Manager) that monitors if the server is up or down, if there are any blocking sessions, and what percentage of max_connections is being used. It sends alerts for these events based on different thresholds. However, I'm still in the beginning stages of development and it probably won't be available for a few months.
>
> I've heard of others using Nagios to monitor PostgreSQL, and EnterpriseDB is supposedly building an OEM type tool but it won't be available until later this year.
>
> Monitoring PostgreSQL has been a big issue for us since beginning to migrate from Oracle, so if anyone else has any experience with this I would love to hear other suggestions.

Most of our monitoring is done through Nagios and Cacti by extracting data
from log files or pg_stat_activity, pg_locks and other system tables. It
takes a bit of know-how to know what tables to get the data you want from,
and a comprehensive monitoring tool would definitely make it easier on
newbies.

--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/