Re: Performance Monitoring of PostGRE

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.

Thanks,
Bobby

From: Michael Nolan <htfoot(at)gmail(dot)com<mailto:htfoot(at)gmail(dot)com>>
Date: Wed, 6 Jul 2011 09:16:40 -0500
To: BangarRaju Vadapalli <BangarRaju(dot)Vadapalli(at)infor(dot)com<mailto:BangarRaju(dot)Vadapalli(at)infor(dot)com>>
Cc: "pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>" <pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>>
Subject: Re: Performance Monitoring of PostGRE

On Wed, Jul 6, 2011 at 3:57 AM, BangarRaju Vadapalli <BangarRaju(dot)Vadapalli(at)infor(dot)com<mailto:BangarRaju(dot)Vadapalli(at)infor(dot)com>> wrote:
Hi Everybody,

We want to monitor the performance of PostGRE database. Could anyone please suggest any tools tried/working successfully…

1. We want AWR kind ofreport in Postgres

By AWR do you mean something like AWStats?

The impression I got at PGCon 11 is that all of the major log file analysis tools have their fans and their weaknesses. Splunk is on my 'I want to test this' list, but it gets pricey.

2. We would like to do CPU Utilization monitoring based on the postgres processes

I don't think log file analysis tools can gather information about CPU usage.. You'd need something that gathered real time data from the OS, eg from /proc on a linux kernel.

sar doesn't tell you a lot about what postgres is up to.
--
Mike Nolan
nolan(at)tssi(dot)com<mailto:nolan(at)tssi(dot)com>