Re: [PERFORM] Monitoring tool for Postgres Database

We have been using Nagios to monitor the system level stats. The database
level stats that we gather are custom scripts that we have nagios poll to
get the database health. You could use pg badger to generate reports
against your database logs as well. Pg_badger reports are your bffs for
performance related specs.. very close to AWR reports that oracle provides.

Sotrage/Disk latencies -- we have oracle's os watcher we running regularly
on these hosts to generate iostats as well.

Thanks.
-Amrutha.

On Thu, May 25, 2017 at 3:48 PM, Ravi Tammineni <
rtammineni(at)partner(dot)aligntech(dot)com> wrote:

> Hi,
>
>
>
> What is the best monitoring tool for Postgres database? Something like
> Oracle Enterprise Manager.
>
>
>
> 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
>