MIME-Version: 1.0
References: <CAKgGyB9z_dN_5vOGS34CNMrT74F4OQWBToCHoSjsWShVDOGZyQ@mail.gmail.com>
 <00fe13de-cbfb-4652-8d62-7b7b15dddd39@aklaver.com>
In-Reply-To: <00fe13de-cbfb-4652-8d62-7b7b15dddd39@aklaver.com>
From: KK CHN <kkchn.in@gmail.com>
Date: Sat, 24 Jan 2026 01:17:19 +0530
Message-ID: <CAKgGyB8JRMO3uKGYpmHXSuWE-xgt8OQiztSJP7tNwzd4u8L2Eg@mail.gmail.com>
Subject: Re: Resource Usage same In spite of fronting my DB server with
 Pgbouncer ?
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000722a45064913575a"
Archived-At: <https://www.postgresql.org/message-id/CAKgGyB8JRMO3uKGYpmHXSuWE-xgt8OQiztSJP7tNwzd4u8L2Eg%40mail.gmail.com>
Precedence: bulk

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

On Sat, Jan 24, 2026 at 12:18=E2=80=AFAM Adrian Klaver <adrian.klaver@aklav=
er.com>
wrote:

>
>
> On 1/23/26 10:14 AM, KK CHN wrote:
> >
> >
> >
> > List,
> > I am fronting my postgres 16 server with  pgbouncer1.23.1
> >
> > What surprises me,  even though I am deploying  pgbouncer as a separate
> > VM in front of DB server VM,  the top command shows the almost same
> > resource usage statistics in the case of load averages, Memory usage et=
c
> > on the DB Server,  whether I am infronting DB server with pgbouncer or
> not.
> >
> > Please find the top  output from the db server pasted here.
> >
> > https://glot.io/snippets/hf4ilogbz0 <https://glot.io/snippets/hf4ilogbz=
0
> >
> >
> > My Pgbouncer server  top output  shows littler resource usages in terms
> > of CPU, MEM usage
> > on the top out put of  pgbouncer VM ( load averagaes  less than 3
> > always,  and Ram usage is very low,  swap usage almost nil..
> >
> >
> > Why eventhough I have deployed  pgbouncer  for this setup why DB server
> > still shows large resource usage as in the pasted out put.
>
> That would seem logical to me as pgBouncer is just passing the
> connections to the Postgres server, the server is doing the heavy
> lifting of dealing with statements in the connections.
>

You mean to say the SQL statements are making this issue ?  I also
suspected wrongly formed query statements making this much load on the DB
server.
 I also suspect this,  as the developers who write queries are not so
expertised for writing optimized queries, needs to be addressed separately.

How can I find out which query statements are making the DB server on its
knees ?  Any method to find the bad queries? what parameters/behaviours to
be checked for finding those query statements which really makes the
db server to its knees  by the heavy lifting ?   any hints most welcome, I
can explore and fix those ones.


>
>  From the top output it looks like you are working with some form of a
> EDB product. You need to specify what that product is and it's version.


Sorry I missed to mention it, this is an EDB 16 server.   Eventhoug I
prefer to use any piece of S/W that is FOSS community editions, sometimes
it is demanded to manage these products  too.


>
> This list is for the community version of Postgres and people will
> assume that is what you are talking about. There are folks that maybe
> able to help with EDB versions, but they need to know what it is.
>
>
> > Regards,
> > Krishane
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><div><br></div><div class=3D"gmail_quote"=
><div dir=3D"ltr" class=3D"gmail_attr">On Sat, Jan 24, 2026 at 12:18=E2=80=
=AFAM Adrian Klaver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com" target=
=3D"_blank">adrian.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote c=
lass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px soli=
d rgb(204,204,204);padding-left:1ex"><br>
<br>
On 1/23/26 10:14 AM, KK CHN wrote:<br>
&gt; <br>
&gt; <br>
&gt; <br>
&gt; List,<br>
&gt; I am fronting my postgres 16 server with=C2=A0 pgbouncer1.23.1<br>
&gt; <br>
&gt; What surprises me,=C2=A0 even though I am deploying=C2=A0 pgbouncer as=
 a separate <br>
&gt; VM in front of DB server VM,=C2=A0 the top command shows the almost sa=
me <br>
&gt; resource usage statistics in the case of load averages, Memory usage e=
tc <br>
&gt; on the DB Server,=C2=A0 whether I am infronting DB server with pgbounc=
er or not.<br>
&gt; <br>
&gt; Please find the top=C2=A0 output from the db server pasted here.<br>
&gt; <br>
&gt; <a href=3D"https://glot.io/snippets/hf4ilogbz0" rel=3D"noreferrer" tar=
get=3D"_blank">https://glot.io/snippets/hf4ilogbz0</a> &lt;<a href=3D"https=
://glot.io/snippets/hf4ilogbz0" rel=3D"noreferrer" target=3D"_blank">https:=
//glot.io/snippets/hf4ilogbz0</a>&gt;<br>
&gt; <br>
&gt; My Pgbouncer server=C2=A0 top output=C2=A0 shows littler resource usag=
es in terms <br>
&gt; of CPU, MEM usage<br>
&gt; on the top out put of=C2=A0 pgbouncer VM ( load averagaes=C2=A0 less t=
han 3=C2=A0 <br>
&gt; always,=C2=A0 and Ram usage is very low,=C2=A0 swap usage almost nil..=
<br>
&gt; <br>
&gt; <br>
&gt; Why eventhough=C2=A0I have deployed=C2=A0 pgbouncer=C2=A0 for this set=
up why DB server <br>
&gt; still shows large resource usage as in the pasted out put.<br>
<br>
That would seem logical to me as pgBouncer is just passing the <br>
connections to the Postgres server, the server is doing the heavy <br>
lifting of dealing with statements in the connections.<br></blockquote><div=
>=C2=A0</div><div>You mean to say the SQL statements are making this issue =
?=C2=A0 I also suspected wrongly formed query statements making this much l=
oad on the DB server.=C2=A0=C2=A0</div><div>=C2=A0I also suspect this,=C2=
=A0 as the developers who write queries are not so expertised for writing o=
ptimized queries, needs to be addressed separately.=C2=A0</div><div><br></d=
iv><div>How can I find out which query statements are making the DB server =
on its knees ?=C2=A0 Any method to find the bad queries? what parameters/be=
haviours to be checked for finding those query statements which really make=
s the db=C2=A0server to its=C2=A0knees=C2=A0 by the heavy lifting ?=C2=A0 =
=C2=A0any hints most welcome, I can explore and fix those ones.=C2=A0</div>=
<div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px =
0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
=C2=A0From the top output it looks like you are working with some form of a=
 <br>
EDB product. You need to specify what that product is and it&#39;s version.=
</blockquote><div>=C2=A0</div>Sorry I missed to mention it, this is an EDB =
16 server.=C2=A0 =C2=A0Eventhoug=C2=A0I prefer to use any=C2=A0piece of S/W=
 that is FOSS community editions, sometimes it is demanded to manage these =
products=C2=A0 too.=C2=A0 =C2=A0<br class=3D"gmail-Apple-interchange-newlin=
e"><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"> <br>
This list is for the community version of Postgres and people will <br>
assume that is what you are talking about. There are folks that maybe <br>
able to help with EDB versions, but they need to know what it is.<br>
<br>
<br>
&gt; Regards,<br>
&gt; Krishane<br>
<br>
</blockquote></div></div>
</div>

--000000000000722a45064913575a--