Thread: Re: [PERFORM] [ADMIN] Monitoring tool for Postgres Database
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
Austin, TX 78757
www.journyx.com
Personally I push those off to my network monitor. Nagios in my case.I find a single integrated alert and escalation framework is better than individual tools, but that's just me.If you're using Nagios, let me know, and I can pop you several stub scripts to help.On May 25, 2017 2:50 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
Journyx, Inc.Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
Hello Scott,Nagios is an alert system, I guess the check_postgres module is in use.EM Grid is a management console whose functions are not just alert , but also remote control, etc.Hello Ravi,From a open source standing, I propose pgcluu. But it doesn't include remote control .Best Regards,Steven2017-05-26 4:00 GMT+08:00 Scott Whitney <scott@journyx.com>:Personally I push those off to my network monitor. Nagios in my case.I find a single integrated alert and escalation framework is better than individual tools, but that's just me.If you're using Nagios, let me know, and I can pop you several stub scripts to help.
On May 25, 2017 2:50 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
Journyx, Inc.Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/
On 05/25/2017 07:15 PM, Scott Mead wrote: > Thanks > > ravi > We use Zabbix. JD > > > -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full stack support, consulting and development. Everyone appreciates your honesty, until you are honest with them.
> We use Zabbix. There's a Zabbix template for PostgreSQL called "pg_monz". http://pg-monz.github.io/pg_monz/index-en.html Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp