Re: Big number of connections

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 14:54:46
Message-ID: CANYYVqKn9i9kkmxCBwUcd6g5FbgXmTBRxYrAVD2p6wLgLh4BrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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'

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Moreno Andreo 2016-04-04 15:00:45 Re: Big number of connections
Previous Message Moreno Andreo 2016-04-04 14:43:07 Re: Big number of connections