Re: Big number of connections - Mailing list pgsql-performance

From Artem Tomyuk
Subject Re: Big number of connections
Date
Msg-id CANYYVqKn9i9kkmxCBwUcd6g5FbgXmTBRxYrAVD2p6wLgLh4BrA@mail.gmail.com
Whole thread Raw
In response to Re: Big number of connections  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Responses Re: Big number of connections  (Moreno Andreo <moreno.andreo@evolu-s.it>)
List pgsql-performance

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' 




pgsql-performance by date:

Previous
From: Moreno Andreo
Date:
Subject: Re: Big number of connections
Next
From: Moreno Andreo
Date:
Subject: Re: Big number of connections