Re: Big number of connections

Moreno Andreo <moreno.andreo@xxxxxxxxxx> · Mon, 4 Apr 2016 17:00:45 +0200



    Il 04/04/2016 16:54, Artem Tomyuk ha
      scritto:

    
          2016-04-04 17:43 GMT+03:00 Moreno
            Andreo <moreno.andreo@xxxxxxxxxx>:

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