public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: KK CHN <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Heavy load on DB Cluster
Date: Thu, 05 Mar 2026 09:18:15 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAKgGyB-R5719p1viw0ZhhFD4i7SfOamFE8Vb3-2YsAARpj6SXw@mail.gmail.com>
References: <CAKgGyB-R5719p1viw0ZhhFD4i7SfOamFE8Vb3-2YsAARpj6SXw@mail.gmail.com>
On Thu, 2026-03-05 at 12:30 +0530, KK CHN wrote:
> I am experiencing heavy load on my database cluster and DB server performance degrading over the time.
> vCPUs 16 , Mem 32 G Swap : 8G storage 5T RHEL 9.4 postgres 16
>
>
> top - 11:55:18 up 175 days, 7:52, 3 users, load average: 11.07, 10.05, 9.56
> Tasks: 731 total, 14 running, 717 sleeping, 0 stopped, 0 zombie
> %Cpu(s): 28.8 us, 9.3 sy, 0.0 ni, 44.9 id, 13.7 wa, 0.8 hi, 2.5 si, 0.0 st
> MiB Mem : 31837.6 total, 531.8 free, 14773.3 used, 25392.0 buff/cache
> MiB Swap: 8060.0 total, 5140.4 free, 2919.6 used. 17064.2 avail Mem
>
> PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
> 3148533 postgre+ 20 0 8973544 7.3g 7.3g S 32.9 23.5 0:22.52 postgres
> 3150012 postgre+ 20 0 8991380 7.4g 7.4g S 32.9 23.9 0:26.16 postgres
> 3081907 postgre+ 20 0 9078400 8.0g 7.9g R 21.9 25.8 2:44.53 postgres
> 3125409 postgre+ 20 0 9075568 8.1g 8.0g S 21.3 26.0 2:34.63 postgres
> 3126500 postgre+ 20 0 9073928 8.0g 7.9g S 18.3 25.7 2:33.10 postgres
> 3081925 postgre+ 20 0 9059088 8.2g 8.2g S 17.6 26.5 6:38.79 postgres
>
> I have pgbackrest(2.52.1) running for incremental backups to a remote reposerver
> and local WAL replication configured to an onprem standalone instance on
> another VM in the same local LAN.
>
> archive_mode = on # enables archiving; off, on, or always
> # (change requires restart)
> # (empty string indicates archive_command should
> # be used)
> archive_command = 'pgbackrest --stanza=My_Repo archive-push %p'
>
> To identify the resource consuming queries I ran and found only one
> [40 days 17:22:59.029204 | START_REPLICATION 8E ] and rest all seems normal .
>
> How come this START_REPLICATION running for 40 days and 17:30 Hrs Is this normal ??
> Is this due to pgbackrest or WAL replication to local VM ?
That is an active replication - or pg_receivewal, which amounts to the same.
That's not really a query; the standby is streaming WAL from the primary and
has been doing that for over 40 days. Nothing to worry about.
> What may be the issue and how to resolve it ?
For that, configure pg_stat_statements and use it to find your most time-consuming
statements.
Yours,
Laurenz Albe
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: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Heavy load on DB Cluster
In-Reply-To: <[email protected]>
* 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