public inbox for [email protected]
help / color / mirror / Atom feedMonitoring tool for Postgres Database
10+ messages / 10 participants
[nested] [flat]
* Monitoring tool for Postgres Database
@ 2017-05-25 19:48 Ravi Tammineni <[email protected]>
2017-05-25 20:48 ` Re: Monitoring tool for Postgres Database Thomas Kellerer <[email protected]>
2017-05-25 23:05 ` Re: [PERFORM] Monitoring tool for Postgres Database Gary Evans <[email protected]>
2017-05-26 10:19 ` Re: Monitoring tool for Postgres Database Rick Otten <[email protected]>
2017-05-26 14:28 ` Re: [ADMIN] Monitoring tool for Postgres Database Ashish Tiwari <[email protected]>
2017-05-26 14:32 ` Re: [PERFORM] Monitoring tool for Postgres Database Sunkara, Amrutha <[email protected]>
2017-06-03 08:37 ` Re: Monitoring tool for Postgres Database Nikolay Samokhvalov <[email protected]>
0 siblings, 6 replies; 10+ messages in thread
From: Ravi Tammineni @ 2017-05-25 19:48 UTC (permalink / raw)
To: [email protected] <[email protected]>; 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] 10+ messages in thread
* Re: Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
@ 2017-05-25 20:48 ` Thomas Kellerer <[email protected]>
5 siblings, 0 replies; 10+ messages in thread
From: Thomas Kellerer @ 2017-05-25 20:48 UTC (permalink / raw)
To: [email protected]
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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 10+ messages in thread
* Re: [PERFORM] Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
@ 2017-05-25 23:05 ` Gary Evans <[email protected]>
5 siblings, 0 replies; 10+ messages in thread
From: Gary Evans @ 2017-05-25 23:05 UTC (permalink / raw)
To: Ravi Tammineni <[email protected]>; +Cc: [email protected] <[email protected]>; 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] 10+ messages in thread
* Re: Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
@ 2017-05-26 10:19 ` Rick Otten <[email protected]>
2017-05-26 14:31 ` Re: Monitoring tool for Postgres Database gevans <[email protected]>
5 siblings, 1 reply; 10+ 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 <
[email protected]> 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] 10+ messages in thread
* Re: Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
2017-05-26 10:19 ` Re: Monitoring tool for Postgres Database Rick Otten <[email protected]>
@ 2017-05-26 14:31 ` gevans <[email protected]>
0 siblings, 0 replies; 10+ 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.
[email protected]
On 5/26/17 5:19 AM, Rick Otten wrote:
> On Thu, May 25, 2017 at 3:48 PM, Ravi Tammineni
> <[email protected]
> <mailto:[email protected]>> 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] 10+ messages in thread
* Re: [ADMIN] Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
@ 2017-05-26 14:28 ` Ashish Tiwari <[email protected]>
5 siblings, 0 replies; 10+ messages in thread
From: Ashish Tiwari @ 2017-05-26 14:28 UTC (permalink / raw)
To: Ravi Tammineni <[email protected]>; +Cc: pgsql-performance; [email protected]
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" <[email protected]>
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] 10+ messages in thread
* Re: [PERFORM] Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
@ 2017-05-26 14:32 ` Sunkara, Amrutha <[email protected]>
2017-05-27 04:58 ` Re: [PERFORM] Monitoring tool for Postgres Database Dave Stibrany <[email protected]>
5 siblings, 1 reply; 10+ messages in thread
From: Sunkara, Amrutha @ 2017-05-26 14:32 UTC (permalink / raw)
To: Ravi Tammineni <[email protected]>; +Cc: [email protected] <[email protected]>; 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 <
[email protected]> 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] 10+ messages in thread
* Re: [PERFORM] Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
2017-05-26 14:32 ` Re: [PERFORM] Monitoring tool for Postgres Database Sunkara, Amrutha <[email protected]>
@ 2017-05-27 04:58 ` Dave Stibrany <[email protected]>
2017-05-27 15:42 ` Re: Monitoring tool for Postgres Database phb07 <[email protected]>
0 siblings, 1 reply; 10+ messages in thread
From: Dave Stibrany @ 2017-05-27 04:58 UTC (permalink / raw)
To: Sunkara, Amrutha <[email protected]>; +Cc: Ravi Tammineni <[email protected]>; [email protected] <[email protected]>; 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 <[email protected]>
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 <
> [email protected]> 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] 10+ messages in thread
* Re: Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
2017-05-26 14:32 ` Re: [PERFORM] Monitoring tool for Postgres Database Sunkara, Amrutha <[email protected]>
2017-05-27 04:58 ` Re: [PERFORM] Monitoring tool for Postgres Database Dave Stibrany <[email protected]>
@ 2017-05-27 15:42 ` phb07 <[email protected]>
0 siblings, 0 replies; 10+ messages in thread
From: phb07 @ 2017-05-27 15:42 UTC (permalink / raw)
To: Ravi Tammineni <[email protected]>; +Cc: [email protected] <[email protected]>; 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
> <[email protected] <mailto:[email protected]>> 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
> <[email protected]
> <mailto:[email protected]>> 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] 10+ messages in thread
* Re: Monitoring tool for Postgres Database
2017-05-25 19:48 Monitoring tool for Postgres Database Ravi Tammineni <[email protected]>
@ 2017-06-03 08:37 ` Nikolay Samokhvalov <[email protected]>
5 siblings, 0 replies; 10+ messages in thread
From: Nikolay Samokhvalov @ 2017-06-03 08:37 UTC (permalink / raw)
To: Ravi Tammineni <[email protected]>; +Cc: [email protected] <[email protected]>; pgsql-performance
We use OKmeter.io, their Postgres monitoring is really good.
On Thu, May 25, 2017 at 10:48 PM, Ravi Tammineni <
[email protected]> wrote:
> Hi,
>
>
>
> What is the best monitoring tool for Postgres database?
>
^ permalink raw reply [nested|flat] 10+ messages in thread
end of thread, other threads:[~2017-06-03 08:37 UTC | newest]
Thread overview: 10+ messages (download: 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 <[email protected]>
2017-05-25 20:48 ` Thomas Kellerer <[email protected]>
2017-05-25 23:05 ` Gary Evans <[email protected]>
2017-05-26 10:19 ` Rick Otten <[email protected]>
2017-05-26 14:31 ` gevans <[email protected]>
2017-05-26 14:28 ` Ashish Tiwari <[email protected]>
2017-05-26 14:32 ` Sunkara, Amrutha <[email protected]>
2017-05-27 04:58 ` Dave Stibrany <[email protected]>
2017-05-27 15:42 ` phb07 <[email protected]>
2017-06-03 08:37 ` Nikolay Samokhvalov <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox