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. :)
>>
>
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 |