postgresql wait event and high active connection

From: liam saffioti <liam(dot)saffiotti(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgresql wait event and high active connection
Date: 2021-12-17 07:24:24
Message-ID: CAGHjuaaM-3ARfiMy5V6eYuj-TWpGXCAFw+FyDvszJ_s8r1YBgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello team,
I have a problem with the number of active connections. There are more than
300 active connections in the database currently. When I checked, most
connections are waiting as buffer_mapping. (wait_event). This problem
happens from time to time, it's not a constant problem.

Can you help me figure out why the problem is occurring?
I can send you any other information you want about the database.

Thank you for your help,
Best,
Liam

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mahesh Sathe 2021-12-17 15:55:53 Re: Log Message
Previous Message Vivek Gadge 2021-12-16 23:56:50 Re: Log Message