Re: Max connections reached without max connections reached - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Max connections reached without max connections reached
Date
Msg-id 29859e1f-d4ad-6c1a-b6f3-0b97e2f8d55f@aklaver.com
Whole thread Raw
In response to Re: Max connections reached without max connections reached  (James Sewell <james.sewell@jirotech.com>)
Responses Re: Max connections reached without max connections reached  (James Sewell <james.sewell@jirotech.com>)
List pgsql-general
On 11/23/21 14:56, James Sewell wrote:

> Sorry, I could have been clearer - pg_stat_activity is what I'm looking 
> at - I'm recording connection info from here every 15 seconds (from a 
> superuser account so I don't get locked out). It never peaks above 300 
> (in fact when the incident happens no new connections can come in so it 
> falls to around 100) - yet I'm seeing the log lines claim that I'm still 
> hitting 597 (600 - 3 reserved).

What is the query you are using against pg_stat_activity?

> 
> James
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: James Sewell
Date:
Subject: Re: Max connections reached without max connections reached
Next
From: Tom Lane
Date:
Subject: Re: Max connections reached without max connections reached