MIME-Version: 1.0
References: <CAJk5AtYgXunW=dkXuZ9q5kcaep8Xbt4Fb8rqHtZ_gOtDKidTMw@mail.gmail.com>
In-Reply-To: <CAJk5AtYgXunW=dkXuZ9q5kcaep8Xbt4Fb8rqHtZ_gOtDKidTMw@mail.gmail.com>
From: Shubhang Joshi <shubhangjoshi2405@gmail.com>
Date: Thu, 7 May 2026 09:52:21 +0530
Message-ID: <CAOJCrX_HLFOHdLLo0cY9ASYp2bAy6gM0cYwfAQ93q9=UnZZp2w@mail.gmail.com>
Subject: Re: Load test
To: Raj <rajeshkumar.dba09@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001c66e1065132a178"
Archived-At: <https://www.postgresql.org/message-id/CAOJCrX_HLFOHdLLo0cY9ASYp2bAy6gM0cYwfAQ93q9%3DUnZZp2w%40mail.gmail.com>
Precedence: bulk

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

Hi Raj,

During the load test, we should monitor the following key metrics:

  - Query Performance: Latency and throughput.
  - System Resources: CPU and memory utilization, disk I/O, and cache
efficiency.
  - Database Activity: Active connections and locking/blocking behavior.
  - Logs: Any errors or anomalies observed.

Additionally, we will need to compare the baseline performance with the
load test results to identify potential bottlenecks and areas for
optimization.

Best regards,
Shubhang Joshi


On Wed, 6 May, 2026, 2:20=E2=80=AFpm Raj, <rajeshkumar.dba09@gmail.com> wro=
te:

> Hi team,
>
> What are things we (dba) need to monitor during load test by application
> team?
>
> If how we monitor, is addon for me.
>
> Thanks.
>

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

<div dir=3D"auto">Hi Raj,<br><br>During the load test, we should monitor th=
e following key metrics:<br><br>=C2=A0 - Query Performance: Latency and thr=
oughput.<br>=C2=A0 - System Resources: CPU and memory utilization, disk I/O=
, and cache efficiency.<br>=C2=A0 - Database Activity: Active connections a=
nd locking/blocking behavior.<br>=C2=A0 - Logs: Any errors or anomalies obs=
erved.<br><br>Additionally, we will need to compare the baseline performanc=
e with the load test results to identify potential bottlenecks and areas fo=
r optimization.<br><br>Best regards,<br>Shubhang Joshi<div><br></div></div>=
<br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=
=3D"gmail_attr">On Wed, 6 May, 2026, 2:20=E2=80=AFpm Raj, &lt;<a href=3D"ma=
ilto:rajeshkumar.dba09@gmail.com">rajeshkumar.dba09@gmail.com</a>&gt; wrote=
:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;bor=
der-left:1px #ccc solid;padding-left:1ex"><div dir=3D"auto">Hi team,<div di=
r=3D"auto"><br></div><div dir=3D"auto">What are things we (dba) need to mon=
itor during load test by application team?=C2=A0</div><div dir=3D"auto"><br=
></div><div dir=3D"auto">If how we monitor, is addon for me.</div><div dir=
=3D"auto"><br></div><div dir=3D"auto">Thanks.</div></div>
</blockquote></div>

--0000000000001c66e1065132a178--