Re: Big number of connections
| От | Artem Tomyuk |
|---|---|
| Тема | Re: Big number of connections |
| Дата | |
| Msg-id | CANYYVqJqM-bYf1uGyeeH_B4YgBsxJbdDaz4hVxj07f=_Oc6XVg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Big number of connections (Moreno Andreo <moreno.andreo@evolu-s.it>) |
| Список | pgsql-performance |
there are two ways:
- to write bash script with condition if number of conn. is > 1000 send me email and put that script in crontab
- monitor it with external monitoring system like zabbix, nagios etc....
2016-04-04 18:00 GMT+03:00 Moreno Andreo <moreno.andreo@evolu-s.it>:
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!" :-)Il 04/04/2016 16:54, Artem Tomyuk ha scritto:2016-04-04 17:43 GMT+03:00 Moreno Andreo <moreno.andreo@evolu-s.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'
Cheers,
Moreno.-
В списке pgsql-performance по дате отправления: