MIME-Version: 1.0
References: 
 <CAJk5AtZTgZbMv48953_Y8287_Q9UMiPCWZecKHBhCfdLBNb3iQ@mail.gmail.com>
In-Reply-To: 
 <CAJk5AtZTgZbMv48953_Y8287_Q9UMiPCWZecKHBhCfdLBNb3iQ@mail.gmail.com>
From: Muhammad Waqas <waqas.m@bitnine.net>
Date: Tue, 6 Aug 2024 10:43:06 +0500
Message-ID: 
 <CAHYHq4UVF035xUNuoN1w_VXO7VSuUDYipFq7WqWO3X4T1bVVJA@mail.gmail.com>
Subject: Re: Connection exceeded alert.
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000428334061efd45c7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHYHq4UVF035xUNuoN1w_VXO7VSuUDYipFq7WqWO3X4T1bVVJA%40mail.gmail.com>
Precedence: bulk

--000000000000428334061efd45c7
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Please check  maximum connection / Session parameter in postgreSQL.conf
file and you can increase maximum session/connection.

Please also check locking on database.

2024=EB=85=84 8=EC=9B=94 6=EC=9D=BC (=ED=99=94) =EC=98=A4=EC=A0=84 9:32, Ra=
jesh Kumar <rajeshkumar.dba09@gmail.com>=EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=
=B1:

> Hi all,
>
> I have been trying to find a steps or solution for past 1 year once we
> received a connection exceeded alert. Couldn't get any answer from anybod=
y
> or internet so far.
>
> Today I checked a pgbadger report and  matched the timeline and found
> that, at that time of sudden connection hike (not normal), there were 3
> queries running at that time (2 update queries on table a , took 5s each,
> one insert query on table b which took 2.5mns).
>
> Anybody provide me steps what all I have to do 1. At that time of
> connection hike 2. If I am been asked to check after sometime as connecti=
on
> dropped to analyse.
>


--=20
*Muhammad Waqas*
*Senior Technical Support Engineer - Tech Support Center (Karachi)*
Mobile: +92-322-2844150
Email:  *waqas.m@bitnine.net <waqas.m@bitnine.net>*
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,
75500 Pakistan.

--000000000000428334061efd45c7
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Please check=C2=A0 maximum connection / Session parameter =
in postgreSQL.conf file and you can increase maximum session/connection.<di=
v><br></div><div>Please also check locking on database.</div></div><br><div=
 class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">2024=EB=85=84 =
8=EC=9B=94 6=EC=9D=BC (=ED=99=94) =EC=98=A4=EC=A0=84 9:32, Rajesh Kumar &lt=
;<a href=3D"mailto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gmail.com=
</a>&gt;=EB=8B=98=EC=9D=B4 =EC=9E=91=EC=84=B1:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><div dir=3D"auto">Hi all,<div dir=3D"auto"=
><br></div><div dir=3D"auto">I have been trying to find a steps or solution=
 for past 1 year once we received a connection exceeded alert. Couldn&#39;t=
 get any answer from anybody or internet so far.</div><div dir=3D"auto"><br=
></div><div dir=3D"auto">Today I checked a pgbadger report and=C2=A0 matche=
d the timeline and found that, at that time of sudden connection hike (not =
normal), there were 3 queries running at that time (2 update queries on tab=
le a , took 5s each, one insert query on table b which took 2.5mns).</div><=
div dir=3D"auto"><br></div><div dir=3D"auto">Anybody provide me steps what =
all I have to do 1. At that time of connection hike 2. If I am been asked t=
o check after sometime as connection dropped to analyse.</div></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr"><div><img width=3D"96" height=3D"36" src=3D"https://ci3.goog=
leusercontent.com/mail-sig/AIorK4yAA065PNs0wTn63OKufwEq-K0rorlKQ3zGggLzUsOI=
5cf2JvOBaG3rALen-RF0aigXFyuy850"><div dir=3D"ltr"><div dir=3D"ltr"><div><b>=
<font size=3D"4">Muhammad Waqas</font></b></div><div><b>Senior Technical Su=
pport Engineer - Tech Support Center (Karachi)</b></div><div><font style=3D=
"vertical-align:inherit">Mobile: +92-322-2844150</font></div><div><font sty=
le=3D"vertical-align:inherit">Email:=C2=A0=C2=A0<u><a href=3D"mailto:waqas.=
m@bitnine.net" target=3D"_blank">waqas.m@bitnine.net</a></u></font>=C2=A0</=
div><div><font style=3D"vertical-align:inherit">1st floor, suit no F-04, CO=
LABS Karachi, 8-C Khayaban-e-Tanzeem,=C2=A0</font></div><div><font style=3D=
"vertical-align:inherit">DHA Phase 5 Tauheed Commercial Area,</font></div><=
div><font style=3D"vertical-align:inherit">Defense V Defense Housing Author=
ity, Karachi, Karachi City, Sindh,=C2=A0</font></div><div><font style=3D"ve=
rtical-align:inherit">75500 Pakistan.</font></div></div></div></div><div><b=
r style=3D"color:rgb(34,34,34)"></div></div></div>

--000000000000428334061efd45c7--