pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Monitoring tool for Postgres Database
15+ messages / 15 participants
[nested] [flat]

* Monitoring tool for Postgres Database
@ 2017-05-25 19:48 Ravi Tammineni <rtammineni@partner.aligntech.com>
  2017-05-25 20:48 ` Re: Monitoring tool for Postgres Database Thomas Kellerer <spam_eater@gmx.net>
  2017-05-25 23:05 ` Re: [PERFORM] Monitoring tool for Postgres Database Gary Evans <garyevans.au@gmail.com>
  2017-05-26 10:19 ` Re: Monitoring tool for Postgres Database Rick Otten <rottenwindfish@gmail.com>
  2017-05-26 14:28 ` Re: [ADMIN] Monitoring tool for Postgres Database Ashish Tiwari <tashish786@gmail.com>
  2017-05-26 14:32 ` Re: [PERFORM] Monitoring tool for Postgres Database Sunkara, Amrutha <amrutha@nytimes.com>
  2017-06-03 08:37 ` Re: Monitoring tool for Postgres Database Nikolay Samokhvalov <samokhvalov@gmail.com>
  0 siblings, 6 replies; 15+ messages in thread

From: Ravi Tammineni @ 2017-05-25 19:48 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgsql-performance

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

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
@ 2017-05-25 20:48 ` Thomas Kellerer <spam_eater@gmx.net>
  5 siblings, 0 replies; 15+ messages in thread

From: Thomas Kellerer @ 2017-05-25 20:48 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org

Ravi Tammineni schrieb am 25.05.2017 um 21:48:
> 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

Take a look at PoWA: http://dalibo.github.io/powa/
and OPM: http://opm.io/




-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: [PERFORM] Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
@ 2017-05-25 23:05 ` Gary Evans <garyevans.au@gmail.com>
  5 siblings, 0 replies; 15+ messages in thread

From: Gary Evans @ 2017-05-25 23:05 UTC (permalink / raw)
  To: Ravi Tammineni <rtammineni@partner.aligntech.com>; +Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgsql-performance

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

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
@ 2017-05-26 10:19 ` Rick Otten <rottenwindfish@gmail.com>
  2017-05-26 14:31   ` Re: Monitoring tool for Postgres Database gevans <gevans@enova.com>
  5 siblings, 1 reply; 15+ messages in thread

From: Rick Otten @ 2017-05-26 10:19 UTC (permalink / raw)
  To: pgsql-performance

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
>

We use Datadog.  Their PostgreSQL plugin covers most of the most relevant
stats.  It is easy to configure and not very expensive at all.  They have
an easy GUI based configuration for monitors and alerts, and you can link
it with something like Victorops and Slack for additional pager escalation
policies.  We have all of our batch processing tied into Datadog as well,
so we can get a picture of events, systems, and database internals all in
one dashboard.

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
  2017-05-26 10:19 ` Re: Monitoring tool for Postgres Database Rick Otten <rottenwindfish@gmail.com>
@ 2017-05-26 14:31   ` gevans <gevans@enova.com>
  0 siblings, 0 replies; 15+ messages in thread

From: gevans @ 2017-05-26 14:31 UTC (permalink / raw)
  To: pgsql-performance

+1 for Datadog.  It is highly configurable, but out of the box the 
postgres integration collects a good amount of useful stuff. Tech 
support is also good.

http://docs.datadoghq.com/integrations/postgresql/

Grant Evans

Enova Inc.

gevans@enova.com


On 5/26/17 5:19 AM, Rick Otten wrote:
> On Thu, May 25, 2017 at 3:48 PM, Ravi Tammineni 
> <rtammineni@partner.aligntech.com 
> <mailto: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
>
>
> We use Datadog.  Their PostgreSQL plugin covers most of the most 
> relevant stats.  It is easy to configure and not very expensive at 
> all.  They have an easy GUI based configuration for monitors and 
> alerts, and you can link it with something like Victorops and Slack 
> for additional pager escalation policies.  We have all of our batch 
> processing tied into Datadog as well, so we can get a picture of 
> events, systems, and database internals all in one dashboard.
>

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: [ADMIN] Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
@ 2017-05-26 14:28 ` Ashish Tiwari <tashish786@gmail.com>
  5 siblings, 0 replies; 15+ messages in thread

From: Ashish Tiwari @ 2017-05-26 14:28 UTC (permalink / raw)
  To: Ravi Tammineni <rtammineni@partner.aligntech.com>; +Cc: pgsql-performance; pgsql-admin@postgresql.org

Hi Ravi,

We use the nagios to monitor the Postgresql Database . Nagios provide the
dedicated API for Postgresql and you can customize the same.

Thanks.

On May 26, 2017 1:19 AM, "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
>

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: [PERFORM] Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
@ 2017-05-26 14:32 ` Sunkara, Amrutha <amrutha@nytimes.com>
  2017-05-27 04:58   ` Re: [PERFORM] Monitoring tool for Postgres Database Dave Stibrany <dstibrany@gmail.com>
  5 siblings, 1 reply; 15+ messages in thread

From: Sunkara, Amrutha @ 2017-05-26 14:32 UTC (permalink / raw)
  To: Ravi Tammineni <rtammineni@partner.aligntech.com>; +Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; 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
>

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: [PERFORM] Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
  2017-05-26 14:32 ` Re: [PERFORM] Monitoring tool for Postgres Database Sunkara, Amrutha <amrutha@nytimes.com>
@ 2017-05-27 04:58   ` Dave Stibrany <dstibrany@gmail.com>
  2017-05-27 15:42     ` Re: Monitoring tool for Postgres Database phb07 <phb07@apra.asso.fr>
  0 siblings, 1 reply; 15+ messages in thread

From: Dave Stibrany @ 2017-05-27 04:58 UTC (permalink / raw)
  To: Sunkara, Amrutha <amrutha@nytimes.com>; +Cc: Ravi Tammineni <rtammineni@partner.aligntech.com>; pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgsql-performance

We've found pghero to be a good first line of defence. It doesn't have
alerting yet, but it's great for a quick high level healthcheck.

Also +1 for Datadog. Extremely flexible and elegant UI + powerful alerting
capabilities.

On Fri, May 26, 2017 at 10:32 AM, Sunkara, Amrutha <amrutha@nytimes.com>
wrote:

> 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
>>
>
>

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
  2017-05-26 14:32 ` Re: [PERFORM] Monitoring tool for Postgres Database Sunkara, Amrutha <amrutha@nytimes.com>
  2017-05-27 04:58   ` Re: [PERFORM] Monitoring tool for Postgres Database Dave Stibrany <dstibrany@gmail.com>
@ 2017-05-27 15:42     ` phb07 <phb07@apra.asso.fr>
  0 siblings, 0 replies; 15+ messages in thread

From: phb07 @ 2017-05-27 15:42 UTC (permalink / raw)
  To: Ravi Tammineni <rtammineni@partner.aligntech.com>; +Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgsql-performance

Hi Ravi,

We, at Dalibo, are contributing to the postgres community mostly through 
open source administration tools development.

Among them :
- pgBadger, from Gilles Darold, extracts a lot of data from the postgres 
logs and restitutes them via a web interface 
(https://github.com/dalibo/pgbadger and http://dalibo.github.io/pgbadger/),
- OPM - Open PostgreSQL Monitoring - monitors the activity of instances 
and sends alerts if needed (http://opm.io/, https://github.com/OPMDG and 
http://opm.readthedocs.io/index.html). It uses the check_pgactivity agent,
- PoWA - PostgreSQL Workload Analyzer - captures and stores the SQL 
activity of instances (using the pg_stat_statements extension) and 
reports it through a web interface. 
(http://powa.readthedocs.io/en/latest/ and 
https://github.com/dalibo/powa). Several plugins help the DBA in 
understanding and improving SQL statements performance:
    - pg_qualstats evaluates the selectivity of predicates or where 
clause encountered in SQL statements,
    - pg_stat_kcache captures additional statistics from the OS, like 
CPU and physical I/Os,
    - HypoPG allows to create hypothetical indexes and shows the access 
plan that the postgres optimizer would choose if these indexes would exist.
- PgCluu, from Gilles Darold, performs a full audit of a PostgreSQL 
Cluster performances. A collector grabs statistics on the PostgreSQL 
cluster using psql and sar, a grapher generates all HTML and charts 
output. (http://pgcluu.darold.net/ and https://github.com/darold/pgcluu)

FYI, we are also working on a new project named TemBoard 
(http://temboard.io/ and https://github.com/dalibo/temboard). It is not 
yet production ready. But it has been presented at the latest postgres 
conference in Russia (https://pgconf.ru/en/2017/93881).

Philippe Beaudoin.

Le 27/05/2017 à 06:58, Dave Stibrany a écrit :
> We've found pghero to be a good first line of defence. It doesn't have 
> alerting yet, but it's great for a quick high level healthcheck.
>
> Also +1 for Datadog. Extremely flexible and elegant UI + powerful 
> alerting capabilities.
>
> On Fri, May 26, 2017 at 10:32 AM, Sunkara, Amrutha 
> <amrutha@nytimes.com <mailto:amrutha@nytimes.com>> wrote:
>
>     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
>     <mailto: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
>
>
>

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: Monitoring tool for Postgres Database
  2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
@ 2017-06-03 08:37 ` Nikolay Samokhvalov <samokhvalov@gmail.com>
  5 siblings, 0 replies; 15+ messages in thread

From: Nikolay Samokhvalov @ 2017-06-03 08:37 UTC (permalink / raw)
  To: Ravi Tammineni <rtammineni@partner.aligntech.com>; +Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>; pgsql-performance

We use OKmeter.io, their Postgres monitoring is really good.

On Thu, May 25, 2017 at 10:48 PM, Ravi Tammineni <
rtammineni@partner.aligntech.com> wrote:

> Hi,
>
>
>
> What is the best monitoring tool for Postgres database?
>

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: [ADMIN] Monitoring tool for Postgres Database
@ 2017-05-25 20:00 Scott Whitney <scott@journyx.com>
  2017-05-26 01:20 ` Re: [ADMIN] Monitoring tool for Postgres Database Steven Chang <stevenchang1213@gmail.com>
  0 siblings, 1 reply; 15+ messages in thread

From: Scott Whitney @ 2017-05-25 20:00 UTC (permalink / raw)
  To: Ravi Tammineni <rtammineni@partner.aligntech.com>; +Cc: pgsql-performance; pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>

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.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com

p 512.834.8888
f 512-834-8858

Do you receive our promotional emails? You can subscribe or unsubscribe to those emails at http://go.journyx.com/emailPreference/e/4932/714/


^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: [ADMIN] Monitoring tool for Postgres Database
  2017-05-25 20:00 Re: [ADMIN] Monitoring tool for Postgres Database Scott Whitney <scott@journyx.com>
@ 2017-05-26 01:20 ` Steven Chang <stevenchang1213@gmail.com>
  2017-05-26 02:15   ` Re: Monitoring tool for Postgres Database Scott Mead <scottm@openscg.com>
  0 siblings, 1 reply; 15+ messages in thread

From: Steven Chang @ 2017-05-26 01:20 UTC (permalink / raw)
  To: Scott Whitney <scott@journyx.com>; +Cc: Ravi Tammineni <rtammineni@partner.aligntech.com>; pgsql-performance; pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>

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,
Steven

2017-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.
> 7600 Burnet Road #300
> Austin, TX 78757
> www.journyx.com
>
> p 512.834.8888 <(512)%20834-8888>
> f 512-834-8858 <(512)%20834-8858>
>
> Do you receive our promotional emails? You can subscribe or unsubscribe to
> those emails at http://go.journyx.com/emailPreference/e/4932/714/
>

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: Monitoring tool for Postgres Database
  2017-05-25 20:00 Re: [ADMIN] Monitoring tool for Postgres Database Scott Whitney <scott@journyx.com>
  2017-05-26 01:20 ` Re: [ADMIN] Monitoring tool for Postgres Database Steven Chang <stevenchang1213@gmail.com>
@ 2017-05-26 02:15   ` Scott Mead <scottm@openscg.com>
  2017-05-26 11:31     ` Re: [ADMIN] Monitoring tool for Postgres Database Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 1 reply; 15+ messages in thread

From: Scott Mead @ 2017-05-26 02:15 UTC (permalink / raw)
  To: Steven Chang <stevenchang1213@gmail.com>; +Cc: Scott Whitney <scott@journyx.com>; Ravi Tammineni <rtammineni@partner.aligntech.com>; pgsql-performance; pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>

On Thu, May 25, 2017 at 9:20 PM, Steven Chang <stevenchang1213@gmail.com>
wrote:

> 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,
> Steven
>
> 2017-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.
>>
>
Personally, I'm a huge fan of grafana and collectd It's definitely not a
pre-packaged solution, but it's simple, easy to use and very, VERY fast.
Alerts with nagios work, but, nagios is awful with history and trending,
but, it beats most others for just alerts


>
>> 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.
>> 7600 Burnet Road #300
>> Austin, TX 78757
>> www.journyx.com
>>
>> p 512.834.8888 <(512)%20834-8888>
>> f 512-834-8858 <(512)%20834-8858>
>>
>> Do you receive our promotional emails? You can subscribe or unsubscribe
>> to those emails at http://go.journyx.com/emailPreference/e/4932/714/
>>
>
>


-- 
--
Scott Mead
Sr. Architect
*OpenSCG <http://openscg.com>*
http://openscg.com

^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: [ADMIN] Monitoring tool for Postgres Database
  2017-05-25 20:00 Re: [ADMIN] Monitoring tool for Postgres Database Scott Whitney <scott@journyx.com>
  2017-05-26 01:20 ` Re: [ADMIN] Monitoring tool for Postgres Database Steven Chang <stevenchang1213@gmail.com>
  2017-05-26 02:15   ` Re: Monitoring tool for Postgres Database Scott Mead <scottm@openscg.com>
@ 2017-05-26 11:31     ` Joshua D. Drake <jd@commandprompt.com>
  2017-05-26 14:14       ` Re: [ADMIN] Monitoring tool for Postgres Database Tatsuo Ishii <ishii@sraoss.co.jp>
  0 siblings, 1 reply; 15+ messages in thread

From: Joshua D. Drake @ 2017-05-26 11:31 UTC (permalink / raw)
  To: Scott Mead <scottm@openscg.com>; Steven Chang <stevenchang1213@gmail.com>; +Cc: Scott Whitney <scott@journyx.com>; Ravi Tammineni <rtammineni@partner.aligntech.com>; pgsql-performance; pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>

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.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



^ permalink  raw  reply  [nested|flat] 15+ messages in thread

* Re: [ADMIN] Monitoring tool for Postgres Database
  2017-05-25 20:00 Re: [ADMIN] Monitoring tool for Postgres Database Scott Whitney <scott@journyx.com>
  2017-05-26 01:20 ` Re: [ADMIN] Monitoring tool for Postgres Database Steven Chang <stevenchang1213@gmail.com>
  2017-05-26 02:15   ` Re: Monitoring tool for Postgres Database Scott Mead <scottm@openscg.com>
  2017-05-26 11:31     ` Re: [ADMIN] Monitoring tool for Postgres Database Joshua D. Drake <jd@commandprompt.com>
@ 2017-05-26 14:14       ` Tatsuo Ishii <ishii@sraoss.co.jp>
  0 siblings, 0 replies; 15+ messages in thread

From: Tatsuo Ishii @ 2017-05-26 14:14 UTC (permalink / raw)
  To: jd@commandprompt.com; +Cc: scottm@openscg.com; stevenchang1213@gmail.com; scott@journyx.com; rtammineni@partner.aligntech.com; pgsql-performance; pgsql-admin@postgresql.org

> 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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



^ permalink  raw  reply  [nested|flat] 15+ messages in thread


end of thread, other threads:[~2017-06-03 08:37 UTC | newest]

Thread overview: 15+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <rtammineni@partner.aligntech.com>
2017-05-25 20:48 ` Thomas Kellerer <spam_eater@gmx.net>
2017-05-25 23:05 ` Gary Evans <garyevans.au@gmail.com>
2017-05-26 10:19 ` Rick Otten <rottenwindfish@gmail.com>
2017-05-26 14:31   ` gevans <gevans@enova.com>
2017-05-26 14:28 ` Ashish Tiwari <tashish786@gmail.com>
2017-05-26 14:32 ` Sunkara, Amrutha <amrutha@nytimes.com>
2017-05-27 04:58   ` Dave Stibrany <dstibrany@gmail.com>
2017-05-27 15:42     ` phb07 <phb07@apra.asso.fr>
2017-06-03 08:37 ` Nikolay Samokhvalov <samokhvalov@gmail.com>
2017-05-25 20:00 Re: [ADMIN] Monitoring tool for Postgres Database Scott Whitney <scott@journyx.com>
2017-05-26 01:20 ` Steven Chang <stevenchang1213@gmail.com>
2017-05-26 02:15   ` Scott Mead <scottm@openscg.com>
2017-05-26 11:31     ` Joshua D. Drake <jd@commandprompt.com>
2017-05-26 14:14       ` Tatsuo Ishii <ishii@sraoss.co.jp>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox