Re: [PERFORM] Big number of connections

[Moreno Andreo]

Il 04/04/2016 16:54, Artem Tomyuk ha scritto: 2016-04-04 17:43 GMT+03:00 Moreno Andreo <moreno.and...@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'  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.-