public inbox for pgsql-admin@postgresql.org  

help / color / mirror / Atom feed

From: Raj <rajeshkumar.dba09@gmail.com>
To: Shubhang Joshi <shubhangjoshi2405@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Load test
Date: Thu, 7 May 2026 12:36:33 +0530
Message-ID: <CAJk5AtbVLoB3967TFfhnSXp+ke0U78jGbHndo8iR_WQBGdDpow@mail.gmail.com> (raw)
In-Reply-To: <CAOJCrX_HLFOHdLLo0cY9ASYp2bAy6gM0cYwfAQ93q9=UnZZp2w@mail.gmail.com>
References: <CAJk5AtYgXunW=dkXuZ9q5kcaep8Xbt4Fb8rqHtZ_gOtDKidTMw@mail.gmail.com>
	<CAOJCrX_HLFOHdLLo0cY9ASYp2bAy6gM0cYwfAQ93q9=UnZZp2w@mail.gmail.com>

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 pm Raj, <rajeshkumar.dba09@gmail.com> wrote:
>
>> 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.
>>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: rajeshkumar.dba09@gmail.com, shubhangjoshi2405@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Load test
  In-Reply-To: <CAJk5AtbVLoB3967TFfhnSXp+ke0U78jGbHndo8iR_WQBGdDpow@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox