Re: Max connections reached without max connections reached

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: James Sewell <james(dot)sewell(at)jirotech(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Max connections reached without max connections reached
Date: 2021-11-23 23:12:18
Message-ID: 29859e1f-d4ad-6c1a-b6f3-0b97e2f8d55f@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-11-23 23:14:31 Re: Max connections reached without max connections reached
Previous Message James Sewell 2021-11-23 22:56:29 Re: Max connections reached without max connections reached