Re: [PERFORM] Monitoring tool for Postgres Database

[Gary Evans <garyevans.au@xxxxxxxxx>]

Hi Ravi, 

 

What is the best monitoring tool for Postgres database? Something like Oracle Enterprise Manager.

If you're an existing user of OEM, there is a PostgreSQL plugin for it by Blue Medora (believe it is commercial).  You might like to have a look at it. 

 

Specifically I am interested in tools to help:

 

Alert DBAs to problems with both configuration and performance issues

Deadlocks, Long running queries etc.,

Monitoring of overall system performance

General performance tuning

Storage/Disk latencies

 

 

Thanks

ravi

Cheers

Gary