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

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

How do we check latency and throughput?

On Thu, 7 May 2026, 09:52 Shubhang Joshi, <shubhangjoshi2405@gmail.com>
wrote:

> 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> w=
rote:
>
>> 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.
>>
>

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

<div dir=3D"auto"><div>How do we check latency and throughput?<br><br><div =
class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail=
_attr">On Thu, 7 May 2026, 09:52 Shubhang Joshi, &lt;<a href=3D"mailto:shub=
hangjoshi2405@gmail.com">shubhangjoshi2405@gmail.com</a>&gt; wrote:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:=
1px #ccc solid;padding-left:1ex"><div dir=3D"auto">Hi Raj,<br><br>During th=
e load test, we should monitor the following key metrics:<br><br>=C2=A0 - Q=
uery Performance: Latency and throughput.<br>=C2=A0 - System Resources: CPU=
 and memory utilization, disk I/O, and cache efficiency.<br>=C2=A0 - Databa=
se Activity: Active connections and locking/blocking behavior.<br>=C2=A0 - =
Logs: Any errors or anomalies observed.<br><br>Additionally, we will need t=
o compare the baseline performance with the load test results to identify p=
otential bottlenecks and areas for optimization.<br><br>Best regards,<br>Sh=
ubhang Joshi<div><br></div></div><br><div class=3D"gmail_quote"><div dir=3D=
"ltr" class=3D"gmail_attr">On Wed, 6 May, 2026, 2:20=E2=80=AFpm Raj, &lt;<a=
 href=3D"mailto:rajeshkumar.dba09@gmail.com" target=3D"_blank" rel=3D"noref=
errer">rajeshkumar.dba09@gmail.com</a>&gt; wrote:<br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pad=
ding-left:1ex"><div dir=3D"auto">Hi team,<div dir=3D"auto"><br></div><div d=
ir=3D"auto">What are things we (dba) need to monitor during load test by ap=
plication 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>
</blockquote></div></div></div>

--000000000000673bf4065134ec17--