Re: [PERFORM] Monitoring tool for Postgres Database

Поиск
Список
Период
Сортировка
От Sunkara, Amrutha
Тема Re: [PERFORM] Monitoring tool for Postgres Database
Дата
Msg-id CA+wvBw0WwodLuM97xxvoLGa_qBq99oqAqvH3f0LPnkSKPcpS9g@mail.gmail.com
обсуждение исходный текст
Ответ на [PERFORM] Monitoring tool for Postgres Database  (Ravi Tammineni <rtammineni@partner.aligntech.com>)
Ответы Re: [PERFORM] Monitoring tool for Postgres Database  (Dave Stibrany <dstibrany@gmail.com>)
Список pgsql-performance
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@partner.aligntech.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


В списке pgsql-performance по дате отправления:

Предыдущее
От: gevans
Дата:
Сообщение: Re: [PERFORM] Monitoring tool for Postgres Database
Следующее
От: "ldh@laurent-hasson.com"
Дата:
Сообщение: Re: [PERFORM] More cores or higer frequency ?