Re: Database and OS monitoring

From: Joseph Kregloh <jkregloh(at)sproutloud(dot)com>
To: Tim Smith <randomdev4+postgres(at)gmail(dot)com>
Cc: Vick Khera <vivek(at)khera(dot)org>, Edson Carlos Ericksson Richter <edsonrichter(at)hotmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database and OS monitoring
Date: 2014-12-15 16:46:35
Message-ID: CAAW2xfdLsHfhmKcmC1eSU7Qf_wHgYwmx=8hcwUCPithA0V_U3g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I use Zabbix a lot. There is very nice template for Postgres
http://pg-monz.github.io/pg_monz/index-en.html

On Sun, Dec 14, 2014 at 12:13 PM, Tim Smith <randomdev4+postgres(at)gmail(dot)com>
wrote:

> Try http://brendangregg.com/
>
> Lots of great tidbits there from a guy who really knows his performance
> stuff (ex-Sun, now Netflix)
>
> On Sunday, 14 December 2014, Vick Khera <vivek(at)khera(dot)org> wrote:
>
>>
>> On Sat, Dec 13, 2014 at 1:55 PM, Edson Carlos Ericksson Richter <
>> edsonrichter(at)hotmail(dot)com> wrote:
>>>
>>> I've been searching in web for guidelines on OS (Linux) and PostgreSQL
>>> (9.3.5) active monitoring best practices.
>>>
>>
>> Recent trends are more toward monitoring response latency by first
>> establishing a baseline level of activity and latency, then alerting when
>> those numbers get out of acceptable range.
>>
>> There are some open source tools to collect and sort and report this way
>> (see Kibana and Grafana and their underlying data stores). I've not seen
>> alerting tools based on this that are non-commercial, though. Two services
>> I know of are Ruxit and Circonus.
>>
>> Personally I still use Nagios to tell my staff when things are down or
>> not responding, but often that is too late to proactively fix things.
>>
>> One thing that'd be really cool is to use the new binary JSON storage in
>> the upcoming Pg release to store the time series data for use with
>> Grafana... but then you'd have a chicken/egg problem with monitoring
>> itself. :)
>>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joseph Kregloh 2014-12-15 17:12:30 Pausing log shipping for streaming replication
Previous Message Vijay 2014-12-15 10:34:58 Re: Error - could not get socket error status: Invalid argument