From: | Artem Tomyuk <admin(at)leboutique(dot)com> |
---|---|
To: | Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Big number of connections |
Date: | 2016-04-04 15:03:57 |
Message-ID: | CANYYVqJqM-bYf1uGyeeH_B4YgBsxJbdDaz4hVxj07f=_Oc6XVg@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
there are two ways:
1. to write bash script with condition if number of conn. is > 1000 send
me email and put that script in crontab
2. monitor it with external monitoring system like zabbix, nagios etc....
2016-04-04 18:00 GMT+03:00 Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>:
> Il 04/04/2016 16:54, Artem Tomyuk ha scritto:
>
>
> 2016-04-04 17:43 GMT+03:00 Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>:
>
>> s there a way to monitor active connections, or at least to report when
>> they grow too much?
>> (say, I have an 8-core system and want to track down if, and when, active
>> connections grow over 80)
>>
>
> You can achieve that just running simple query like
> select count(*) from pg_stat_activity where state = 'active'
>
>
>
>
> Thanks, but this way I get the "sample" on that actual moment: what I'd
> need is to monitor, or to have something warning me like "Hey, You've got
> 2000 active connections! Time to grow up!" :-)
>
> Cheers,
> Moreno.-
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2016-04-04 15:06:30 | Re: Big number of connections |
Previous Message | Moreno Andreo | 2016-04-04 15:00:45 | Re: Big number of connections |