Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfMSt-001nMj-Np for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 17:12:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tfMSs-00625q-R2 for pgsql-general@arkaria.postgresql.org; Tue, 04 Feb 2025 17:11:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tfMRG-005vsd-8j for pgsql-general@lists.postgresql.org; Tue, 04 Feb 2025 17:10:18 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tfMRC-0039sH-2a for pgsql-general@postgresql.org; Tue, 04 Feb 2025 17:10:17 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-6efe4e3d698so41486837b3.0 for ; Tue, 04 Feb 2025 09:10:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1738689014; x=1739293814; darn=postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=k1d8Wh3glS6Kd45NFao8davisXgS9ypXbe03JlD/VZg=; b=K/sy152CGEc5yUyeC1HxeyjNAy/epEWaLIO3ztB0Kh3FZKIGnKIBTKqx868q/5ihqd shj0meVH1uegB/JcSqA2b5piZyJjI9sMyhqLYU3hfJNm/paUvl0OYLQ04RQOhmIEopEz f2HtJJqFX954nALMUHMWHRUblFcgIBy5sQXbn0HBxZSyPpKJIWWzx4h2YLtTCaPWB43U boTZla0aSLtj6iwZSmJxDaDFp7T4J9/Hgwg1GZOyFy1n+eLhE6eIOtX9CMho4V4u18Li SxR9S4BQmBOaZo0Jsmr+ysUAsN/NAzJ90m6M8/blURRI12K503xjViwLP/XRDcIpVnij Gerw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1738689014; x=1739293814; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=k1d8Wh3glS6Kd45NFao8davisXgS9ypXbe03JlD/VZg=; b=nZRFyQZLUdJHwsICVVwyCYfB5OrPdMPCPfsI9wthWY2As89UwL+FLF5Xd29sURNlhR TGDFgExS8800tZ8lm7LoXjrUrlUBRzBa1k8Y7v93eKG7LQaLrpRpEDGuW1/N2ikqIfpR lqJXcalUXav3GmC1mu7sduhzo4GrC6UK7PUHllss6aAENuveTiZPHt/qKS2muI9vachD iVTcTArBE1ngAxvwt4mzzMmcN5ejxdQQW6r6UCz79EkKQtr6wxFycqGaltqTIQUE58zb 7/KC0uarFKPdkJtuOrsQhTZxiK9+QmTUl3EsBW7Kp9VaiunNnvUN5vlCflLuVLUx4DKJ L2ag== X-Gm-Message-State: AOJu0YzL7VsOKxjOJlYbU0hu7LDtxlQJMwFeVXjhbMens73tgQlHV0Rg +X9uG0oVhje04kwZXN6YUKI5pEgAFqCMcnnVmIV4aDOpp0GbC9F0xj6tHaJSnRtboaKSOEgUshU gU0gRErc+Ptwvw/Dt1CvVCndRwGsCr3SU X-Gm-Gg: ASbGncs0BH0n8/xH05rOv7wnT8ghSGQyclZKGP/ErHk8FiO7ZHit1dI37rhjDp/0Lnn z76KLKgUDNG1r3I07MBplo50LrirV+8gAUJJXPMKTp2lFgMOyvjAUwfw/DoHNaPdnagXFAuPv3g == X-Google-Smtp-Source: AGHT+IGlpASZOZ8IEEgXur/R+yoYroQtWsUHdl5VTiQaH2MNRMZ//2soMjUnpTLFQjBKgz1qx9EbNonMYpMOkj2wCBY= X-Received: by 2002:a05:690c:4d49:b0:6ef:7c4d:4cca with SMTP id 00721157ae682-6f7a8429466mr228525537b3.37.1738689014139; Tue, 04 Feb 2025 09:10:14 -0800 (PST) MIME-Version: 1.0 From: KK CHN Date: Tue, 4 Feb 2025 22:41:22 +0530 X-Gm-Features: AWEUYZmpxeVM1g8xDgbiu6QTIIWzQr3FytVGIAlviczKamFLcUkZALXB2ZZXaLo Message-ID: Subject: Postgres performance issue with High CPU usage To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000001015ba062d5415da" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001015ba062d5415da Content-Type: text/plain; charset="UTF-8" List, Could someone point out how can I trace what causes the edb-postgres process with %CPU usage reaching 73 to 80.1 percentage in this box. What's wrong with the server VM.. The clients connecting the databases experience slow responses .. The top out put of the DB server is pasted below.. Any hints much appreciated to trouble shoot this unusual load on the server instance. Thank you, Krishane. I top - 22:34:13 up 61 days, 7:43, 3 users, load average: 8.76, 9.92, 19.12 Tasks: 697 total, 9 running, 687 sleeping, 1 stopped, 0 zombie %Cpu(s): 34.3 us, 18.7 sy, 0.0 ni, 46.2 id, 0.0 wa, 0.5 hi, 0.3 si, 0.0 st MiB Mem : 31837.6 total, 1296.9 free, 11447.0 used, 27969.1 buff/cache MiB Swap: 8060.0 total, 7400.0 free, 660.0 used. 20390.5 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 4007576 enterpr+ 20 0 8944520 951764 941212 R 80.1 2.9 0:57.24 edb-postgres 4035945 enterpr+ 20 0 8943056 472108 463068 R 79.7 1.4 0:11.48 edb-postgres 4020721 enterpr+ 20 0 8925752 702836 689644 S 73.1 2.2 0:27.99 edb-postgres 4036409 enterpr+ 20 0 8916540 368084 363772 S 43.5 1.1 0:01.31 edb-postgres 4036410 enterpr+ 20 0 8928512 481808 469852 S 32.2 1.5 0:03.52 edb-postgres 442070 enterpr+ 20 0 8908184 181248 180096 S 13.0 0.6 1391:16 edb-postgres 4041239 enterpr+ 20 0 8921696 995.0m 986.1m S 9.0 3.1 0:00.75 edb-postgres 4041225 enterpr+ 20 0 8921856 --0000000000001015ba062d5415da Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
List,=C2=A0

Could someone po= int out how can I trace what causes the edb-postgres=C2=A0 process with=C2= =A0 %CPU usage reaching 73 to 80.1 percentage=C2=A0 in this box.=C2=A0 =C2= =A0What's wrong with the server VM..

The clien= ts connecting=C2=A0the databases experience=C2=A0 slow responses ..

The top out put=C2=A0of the DB server is=C2=A0 pasted bel= ow..


Any hints=C2=A0 much appreciat= ed to trouble shoot=C2=A0this unusual=C2=A0load on the server instance.=C2= =A0

Thank you,
Krishane.

<= /div>



I

top - 22:34:13 up 61 days, =C2=A07:43, =C2=A03 users, =C2=A0load average:= 8.76, 9.92, 19.12
Tasks: 697 total, =C2=A0 9 running, 687 sleeping, =C2= =A0 1 stopped, =C2=A0 0 zombie
%Cpu(s): 34.3 us, 18.7 sy, =C2=A00.0 ni, = 46.2 id, =C2=A00.0 wa, =C2=A00.5 hi, =C2=A00.3 si, =C2=A00.0 st
MiB Mem = : =C2=A031837.6 total, =C2=A0 1296.9 free, =C2=A011447.0 used, =C2=A027969.= 1 buff/cache
MiB Swap: =C2=A0 8060.0 total, =C2=A0 7400.0 free, =C2=A0 = =C2=A0660.0 used. =C2=A020390.5 avail Mem

=C2=A0 =C2=A0 PID USER =C2= =A0 =C2=A0 =C2=A0PR =C2=A0NI =C2=A0 =C2=A0VIRT =C2=A0 =C2=A0RES =C2=A0 =C2= =A0SHR S =C2=A0%CPU =C2=A0%MEM =C2=A0 =C2=A0 TIME+ COMMAND
4007576 enter= pr+ =C2=A020 =C2=A0 0 8944520 951764 941212 R =C2=A080.1 =C2=A0 2.9 =C2=A0 = 0:57.24 edb-postgres
4035945 enterpr+ =C2=A020 =C2=A0 0 8943056 472108 4= 63068 R =C2=A079.7 =C2=A0 1.4 =C2=A0 0:11.48 edb-postgres
4020721 enterp= r+ =C2=A020 =C2=A0 0 8925752 702836 689644 S =C2=A073.1 =C2=A0 2.2 =C2=A0 0= :27.99 edb-postgres
4036409 enterpr+ =C2=A020 =C2=A0 0 8916540 368084 36= 3772 S =C2=A043.5 =C2=A0 1.1 =C2=A0 0:01.31 edb-postgres
4036410 enterpr= + =C2=A020 =C2=A0 0 8928512 481808 469852 S =C2=A032.2 =C2=A0 1.5 =C2=A0 0:= 03.52 edb-postgres
=C2=A0442070 enterpr+ =C2=A020 =C2=A0 0 8908184 18124= 8 180096 S =C2=A013.0 =C2=A0 0.6 =C2=A0 1391:16 edb-postgres
4041239 ent= erpr+ =C2=A020 =C2=A0 0 8921696 995.0m 986.1m S =C2=A0 9.0 =C2=A0 3.1 =C2= =A0 0:00.75 edb-postgres
4041225 enterpr+ =C2=A020 =C2=A0 0 8921856=C2= =A0
--0000000000001015ba062d5415da--