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 1sncRl-004tBL-4I for pgsql-general@arkaria.postgresql.org; Mon, 09 Sep 2024 11:20:42 +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 1sncRk-00Ad93-GV for pgsql-general@arkaria.postgresql.org; Mon, 09 Sep 2024 11:20:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sncRk-00Ad8u-2K for pgsql-general@lists.postgresql.org; Mon, 09 Sep 2024 11:20:40 +0000 Received: from mail-yw1-x1131.google.com ([2607:f8b0:4864:20::1131]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sncRg-000IBA-3e for pgsql-general@lists.postgresql.org; Mon, 09 Sep 2024 11:20:39 +0000 Received: by mail-yw1-x1131.google.com with SMTP id 00721157ae682-6da395fb97aso39346417b3.0 for ; Mon, 09 Sep 2024 04:20:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1725880835; x=1726485635; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=X7UPZV9/abU9MnADqzcG49u4uZDB5uAuJCYoxI/WHSQ=; b=ip/mYR8FL2oawojHfzto090XIS+l5yBFML+LClHx7DrYKKts7qLIKInOybPJYfm/Su jvaYs4lgmE0FxB4jJvswkKTbHt8M+0EywsoI0rC3ghMwKjuDeAteOWWhb4Wk+len+lIJ RYRG+kC+czMcFjECTsJpQj0MTSuTsOu0iaC2A5y1/ZkYO/Ju3clWv9hWULUZPyBzAzBx PfIQ+XPpi2+cLfKTbbTeQuCTKWjKsqaq7j8Yx4FIHp6fHCfs9OKgk/xtHJ0dZRihHJeg l3qxLIeYHXyFeRV0LFiwulZ3yPsZDDN8yB0aQYiGhaO6OEeDcIZmkcxpX8tTl8EfuAZ7 oudQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725880835; x=1726485635; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=X7UPZV9/abU9MnADqzcG49u4uZDB5uAuJCYoxI/WHSQ=; b=SQC6IWOAK2b02f9wvQCpUz2MPi65NfiCFi2Tl60FExYRXBl8WAIDD+Z8z79/hMpz6H ljlFMwm0muLO9AsXutxV1EHHJINf++9BsH81MuW6GugCvXDTjLx/3MvVlX+P3EfPKH9i wRvxFDSRZMfrfHTivfH7hjYOV5jMvj9d47q/UvLIUvbwlGlUwEbqibBr38OLfU+yKr6G T8yAh/oW0u5A4tbf/r87ZSb9xK6FRdzxHmbaarqro8YJ2O6BC/TK2YMmPYvTW8Gh7PbH cPEicZBpqWLGZMMarmTJI98WOFqPFYE66KWSvCJDt0RFScc9lGmZExfunQd8RNhrl061 0Kxw== X-Gm-Message-State: AOJu0Yx18TXqmy+i5AEkdPBBoq7rFj++68/FtqGIGu60ykA5hGASTceK rvaDaHm65JuD79tiCPVvzlanCkp2S4wLWmKZUr0hg0A4ZSkRUJp0XnDrGHsv3GoXYGZNvTGWLR5 z2jAV6xaVgvFFIDQLwbkjpa1ddZDXH7TM X-Google-Smtp-Source: AGHT+IFUc/CuAETx6kfy6sKXfFkdmZbRhJK7+6reVFJdTzKeiVTd1hGxkhot62DxrDL7u6Jn/IHmLfzdfHPVM/+C58k= X-Received: by 2002:a05:690c:6c81:b0:6d5:6719:4d80 with SMTP id 00721157ae682-6db451549bcmr118251707b3.31.1725880834968; Mon, 09 Sep 2024 04:20:34 -0700 (PDT) MIME-Version: 1.0 From: KK CHN Date: Mon, 9 Sep 2024 16:50:37 +0530 Message-ID: Subject: ssh to DB server and su normal users very slow : To: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000017d4fb0621adf2ae" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000017d4fb0621adf2ae Content-Type: text/plain; charset="UTF-8" List, I have configured pgbackrest for the DB server and Repo Server(created the stanza info check all fine. in these machines. /var/spool/pgbackrest shows the .Ok for each WAL and the Repo server receiving the archiving of WAL in the archive directory . I didn't schedule a pgbackrest back as of now due to an issue I am facing as follows. PROBLEM Statement: I am facing a delay in ssh root@dbserver_IP from my Desktop PC. More than a minute to login to the root console from any remote terminal, but this issue was not there all these days. I have done two changes in the DB server :- 1. pg_hba.conf entry ie; changed the entry #local all all trust To #local all all md5 It already having replication entry as local replication all peer 2. Added a .pgpass entry in the DB user's ~/dir/ with the following [root@db1 ~]# cat /var/lib/edb/.pgpass *:*:*:enterprisedb:password Is this causing login delays ? Local connection asking password(pg_hba.conf entry ) and .pgpass contain the user and password for connecting ? 3. Even if I able to login to the DB server from the Remote Repo server after a minute or two, in side the DB server doing a # su enterprisedb taking around 90 to 120 seconds to change the user as enterprisedb user ?? Any hints much appreciated .. Thanks in advance, Krishane *For more details I am pasting the top output ( vCPU 16 nos , RAM 16 GB)* top - 10:11:43 up 5 days, 17:21, 5 users, load average: 0.97, 1.38, 1.26 Tasks: 710 total, 1 running, 708 sleeping, 1 stopped, 0 zombie %Cpu(s): 1.3 us, 0.6 sy, 0.0 ni, 97.1 id, 0.6 wa, 0.1 hi, 0.3 si, 0.0 st MiB Mem : 15733.6 total, 664.0 free, 6371.1 used, 13237.6 buff/cache MiB Swap: 8060.0 total, 7985.1 free, 74.9 used. 9362.4 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 3547252 enterpr+ 20 0 4656880 262304 252032 S 8.3 1.6 0:01.97 edb-postgres 2588 enterpr+ 20 0 4622104 12704 10888 S 2.0 0.1 106:10.00 edb-postgres 3554955 enterpr+ 20 0 4661692 632052 621364 S 2.0 3.9 0:00.99 edb-postgres 3555894 enterpr+ 20 0 4633432 628388 621056 S 1.3 3.9 0:00.26 edb-postgres 3525520 enterpr+ 20 0 4658888 555596 543872 S 1.0 3.4 0:10.82 edb-postgres 3546456 enterpr+ 20 0 4627288 40852 38016 S 1.0 0.3 0:00.30 edb-postgres 3554919 enterpr+ 20 0 4655376 564024 557020 S 1.0 3.5 0:00.30 edb-postgres 3555796 enterpr+ 20 0 4635024 565716 556840 S 1.0 3.5 0:00.22 edb-postgres 3556084 enterpr+ 20 0 4653424 59156 51968 S 1.0 0.4 0:00.06 edb-postgres 3525597 enterpr+ 20 0 4627444 44052 41088 S 0.7 0.3 0:00.47 edb-postgres 377 root 0 -20 0 0 0 I 0.3 0.0 2:43.11 kworker/5:1H-kblockd 2923344 enterpr+ 20 0 4625236 225176 223104 S 0.3 1.4 1:23.93 edb-postgres 3525722 enterpr+ 20 0 4627328 99220 96128 S 0.3 0.6 0:01.99 edb-postgres 3555151 root 20 0 226580 4864 3456 R 0.3 0.0 0:00.15 top 3555807 enterpr+ 20 0 4627444 350228 347136 S 0.3 2.2 0:00.03 edb-postgres 3556023 enterpr+ 20 0 4653636 60052 52608 S 0.3 0.4 0:00.15 edb-postgres 3556026 enterpr+ 20 0 4653424 59796 52608 S 0.3 0.4 0:00.22 edb-postgres 3556074 enterpr+ 20 0 4653448 59540 52224 S 0.3 0.4 0:00.11 edb-postgres 3556075 enterpr+ 20 0 4653372 59412 52224 S 0.3 0.4 0:00.18 edb-postgres and # ps -ax shows [root@db1 ~]# ps -ax |grep "idle" 3511515 ? I 0:00 [kworker/5:0-inet_frag_wq] 3512991 ? Ss 0:00 postgres: enterprisedb postgres 10.21.134.205(56754) idle 3513003 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.205(56770) idle 3513005 ? Ss 0:00 postgres: enterprisedb tp_db 10.21.13.205(56772) idle 3513267 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(39262) idle 3513476 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.205(56839) idle 3513704 ? Ss 0:00 postgres: enterprisedb mt_db 10.21.13.202(56608) idle 3513729 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(44926) idle 3514113 ? Ss 0:00 postgres: enterprisedb mt_db 10.21.13.202(53743) idle 3514374 ? Ss 0:00 postgres: enterprisedb mt_db 10.21.13.202(58623) idle 3514397 pts/1 T 0:00 top 3515012 ? Ss 0:00 postgres: enterprisedb mt_db 10.21.13.202(58686) idle 3515088 ? Ss 0:00 postgres: enterprisedb mgt_db 10.21.13.202(58586) idle 3515942 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(64844) idle 3515987 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(27190) idle 3516230 ? Ss 0:00 postgres: enterprisedb postgres 10.21.13.202(60354) idle 3516655 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.205(57348) idle 3519209 ? Ss 0:00 postgres: enterprisedb g_db 10.21.13.202(59611) idle 3519948 ? Ss 0:00 postgres: enterprisedb postgres 10.21.13.204(58224) idle 3520004 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.204(58239) idle 3521990 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(39000) idle 3525800 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.204(58606) idle 3525914 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.204(59004) idle 3528403 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(44250) idle 3532345 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(64230) idle 3533852 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(34514) idle 3533969 ? Ss 0:00 postgres: enterprisedb g_db 10.21.13.202(58464) idle 3354541 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(62640) idle 3356744 ? I 0:00 [kworker/3:2] 3365496 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(47376) idle 3367163 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(48814) idle 3368555 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(56520) idle 3370980 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(19930) idle 3371824 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(36006) idle 3372285 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(37632) idle 3373166 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(36862) idle 3379317 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(17632) idle 3385442 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(21096) idle 3385790 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(47792) idle 3389859 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(56094) idle 3397876 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(32436) idle 3404172 ? Ss 0:00 postgres: enterprisedb ad_db 10.23.0.206(37122) idle 3404779 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(62946) idle 3405628 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(37568) idle 3406414 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(50994) idle 3408051 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(14956) idle 3410935 ? I 0:00 [kworker/7:2-events] 3432820 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(31348) idle 3434126 ? Ss 0:01 postgres: enterprisedb ad_db 10.23.0.206(48372) idle 3436428 ? Ss 0:00 postgres: enterprisedb mt_db 10.23.0.207(36930) idle 3443063 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(57624) idle --00000000000017d4fb0621adf2ae Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
List,

I have configured pgbackrest for = the DB server and Repo Server(created the stanza info check all fine.=C2=A0= in these machines.=C2=A0


/var/spoo= l/pgbackrest=C2=A0 shows=C2=A0 =C2=A0the .Ok=C2=A0 =C2=A0 for each WAL=C2= =A0 and=C2=A0 =C2=A0the=C2=A0Repo server receiving the archiving of WAL in = the archive directory .=C2=A0


I did= n't=C2=A0 schedule a pgbackrest=C2=A0 back=C2=A0 as of now=C2=A0 due to= =C2=A0 an issue I am facing as follows.=C2=A0

PROBLEM=C2=A0Statement:

I am facing a delay in ssh=C2=A0 root@dbser= ver_IP from my Desktop PC.=C2=A0 More than a minute to login to the root co= nsole from any remote terminal, but this issue was not there all these days= .

=C2=A0I have done two changes in the DB server := -

1.
pg_hba.conf entry

ie;=C2=A0 changed the entry=C2=A0 =C2=A0 =C2=A0 =C2=A0#local =C2=A0= all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 all=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 trust=C2=A0

To=C2=A0
#local = =C2=A0 all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 all=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 md5=C2=A0

<= br>
It already having replication entry=C2=A0as=C2=A0
l= ocal =C2=A0 replication =C2=A0 =C2=A0 all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 peer

2.
Added a= .pgpass entry in the=C2=A0 =C2=A0 DB user's=C2=A0 =C2=A0 ~/dir/ with t= he following

[root@db1 ~]# cat /var/lib/edb/.pgpas= s
*:*:*:enterprisedb:password


Is this causing login delays ?=C2=A0 =C2=A0Local connection asking passwo= rd(pg_hba.conf entry ) and=C2=A0 =C2=A0.pgpass contain the user and passwor= d for connecting ?


3. Even if I abl= e to login to the DB server from the Remote Repo server after a minute or t= wo, in side the DB server=C2=A0 =C2=A0 =C2=A0doing a #=C2=A0 su enterprised= b=C2=A0 =C2=A0 taking around 90 to 120 seconds to change the user as=C2=A0 = =C2=A0 enterprisedb user ??

Any hints much appreciated ..
Thanks in=C2=A0advance,=C2=A0
Krishane



Fo= r more=C2=A0 details=C2=A0 =C2=A0I am pasting the top output=C2=A0 =C2=A0 = =C2=A0( vCPU 16 nos , RAM 16 GB)

top - 10:11:43 up 5 days, 17:21, =C2=A05 us= ers, =C2=A0load average: 0.97, 1.38, 1.26
Tasks: 710 total, =C2=A0 1 run= ning, 708 sleeping, =C2=A0 1 stopped, =C2=A0 0 zombie
%Cpu(s): =C2=A01.3= us, =C2=A00.6 sy, =C2=A00.0 ni, 97.1 id, =C2=A00.6 wa, =C2=A00.1 hi, =C2= =A00.3 si, =C2=A00.0 st
MiB Mem : =C2=A015733.6 total, =C2=A0 =C2=A0664.= 0 free, =C2=A0 6371.1 used, =C2=A013237.6 buff/cache
MiB Swap: =C2=A0 80= 60.0 total, =C2=A0 7985.1 free, =C2=A0 =C2=A0 74.9 used. =C2=A0 9362.4 avai= l 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
3547252 enterpr+ =C2=A020 =C2=A0 0 4656880 262304 = 252032 S =C2=A0 8.3 =C2=A0 1.6 =C2=A0 0:01.97 edb-postgres
=C2=A0 =C2=A0= 2588 enterpr+ =C2=A020 =C2=A0 0 4622104 =C2=A012704 =C2=A010888 S =C2=A0 2.= 0 =C2=A0 0.1 106:10.00 edb-postgres
3554955 enterpr+ =C2=A020 =C2=A0 0 4= 661692 632052 621364 S =C2=A0 2.0 =C2=A0 3.9 =C2=A0 0:00.99 edb-postgres3555894 enterpr+ =C2=A020 =C2=A0 0 4633432 628388 621056 S =C2=A0 1.3 =C2= =A0 3.9 =C2=A0 0:00.26 edb-postgres
3525520 enterpr+ =C2=A020 =C2=A0 0 4= 658888 555596 543872 S =C2=A0 1.0 =C2=A0 3.4 =C2=A0 0:10.82 edb-postgres3546456 enterpr+ =C2=A020 =C2=A0 0 4627288 =C2=A040852 =C2=A038016 S =C2= =A0 1.0 =C2=A0 0.3 =C2=A0 0:00.30 edb-postgres
3554919 enterpr+ =C2=A020= =C2=A0 0 4655376 564024 557020 S =C2=A0 1.0 =C2=A0 3.5 =C2=A0 0:00.30 edb-= postgres
3555796 enterpr+ =C2=A020 =C2=A0 0 4635024 565716 556840 S =C2= =A0 1.0 =C2=A0 3.5 =C2=A0 0:00.22 edb-postgres
3556084 enterpr+ =C2=A020= =C2=A0 0 4653424 =C2=A059156 =C2=A051968 S =C2=A0 1.0 =C2=A0 0.4 =C2=A0 0:= 00.06 edb-postgres
3525597 enterpr+ =C2=A020 =C2=A0 0 4627444 =C2=A04405= 2 =C2=A041088 S =C2=A0 0.7 =C2=A0 0.3 =C2=A0 0:00.47 edb-postgres
=C2=A0= =C2=A0 377 root =C2=A0 =C2=A0 =C2=A0 0 -20 =C2=A0 =C2=A0 =C2=A0 0 =C2=A0 = =C2=A0 =C2=A00 =C2=A0 =C2=A0 =C2=A00 I =C2=A0 0.3 =C2=A0 0.0 =C2=A0 2:43.11= kworker/5:1H-kblockd
2923344 enterpr+ =C2=A020 =C2=A0 0 4625236 225176 = 223104 S =C2=A0 0.3 =C2=A0 1.4 =C2=A0 1:23.93 edb-postgres
3525722 enter= pr+ =C2=A020 =C2=A0 0 4627328 =C2=A099220 =C2=A096128 S =C2=A0 0.3 =C2=A0 0= .6 =C2=A0 0:01.99 edb-postgres
3555151 root =C2=A0 =C2=A0 =C2=A020 =C2= =A0 0 =C2=A0226580 =C2=A0 4864 =C2=A0 3456 R =C2=A0 0.3 =C2=A0 0.0 =C2=A0 0= :00.15 top
3555807 enterpr+ =C2=A020 =C2=A0 0 4627444 350228 347136 S = =C2=A0 0.3 =C2=A0 2.2 =C2=A0 0:00.03 edb-postgres
3556023 enterpr+ =C2= =A020 =C2=A0 0 4653636 =C2=A060052 =C2=A052608 S =C2=A0 0.3 =C2=A0 0.4 =C2= =A0 0:00.15 edb-postgres
3556026 enterpr+ =C2=A020 =C2=A0 0 4653424 =C2= =A059796 =C2=A052608 S =C2=A0 0.3 =C2=A0 0.4 =C2=A0 0:00.22 edb-postgres3556074 enterpr+ =C2=A020 =C2=A0 0 4653448 =C2=A059540 =C2=A052224 S =C2= =A0 0.3 =C2=A0 0.4 =C2=A0 0:00.11 edb-postgres
3556075 enterpr+ =C2=A020= =C2=A0 0 4653372 =C2=A059412 =C2=A052224 S =C2=A0 0.3 =C2=A0 0.4 =C2=A0 0:= 00.18 edb-postgres


and=C2=A0 # = ps -ax=C2=A0 =C2=A0shows=C2=A0
[root@db1 ~]# ps -ax |grep "i= dle"

3511515 ? =C2=A0 =C2=A0 =C2=A0 =C2= =A0I =C2=A0 =C2=A0 =C2=A00:00 [kworker/5:0-inet_frag_wq]
3512991 ? =C2= =A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb postgr= es 10.21.134.205(56754) idle
3513003 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2= =A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.21.13.205(56770) idle
35= 13005 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterpri= sedb tp_db 10.21.13.205(56772) idle
3513267 ? =C2=A0 =C2=A0 =C2=A0 =C2= =A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203(39262) id= le
3513476 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: = enterprisedb er_db 10.21.13.205(56839) idle
3513704 ? =C2=A0 =C2=A0 =C2= =A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb mt_db 10.21.13.202(5= 6608) idle
3513729 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 po= stgres: enterprisedb er_db 10.23.0.203(44926) idle
3514113 ? =C2=A0 =C2= =A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb mt_db 10.21.1= 3.202(53743) idle
3514374 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 = 0:00 postgres: enterprisedb mt_db 10.21.13.202(58623) idle
3514397 pts/1= =C2=A0 =C2=A0T =C2=A0 =C2=A0 =C2=A00:00 top
3515012 ? =C2=A0 =C2=A0 =C2= =A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb mt_db 10.21.13.202(5= 8686) idle
3515088 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 po= stgres: enterprisedb mgt_db 10.21.13.202(58586) idle
3515942 ? =C2=A0 = =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.2= 3.0.203(64844) idle
3515987 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2= =A0 0:00 postgres: enterprisedb er_db 10.23.0.203(27190) idle
3516230 ? = =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb pos= tgres 10.21.13.202(60354) idle
3516655 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss = =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.21.13.205(57348) idle3519209 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enter= prisedb g_db 10.21.13.202(59611) idle
3519948 ? =C2=A0 =C2=A0 =C2=A0 =C2= =A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb postgres 10.21.13.204(58224= ) idle
3520004 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgr= es: enterprisedb er_db 10.21.13.204(58239) idle
3521990 ? =C2=A0 =C2=A0 = =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203= (39000) idle
3525800 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 = postgres: enterprisedb er_db 10.21.13.204(58606) idle
3525914 ? =C2=A0 = =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.2= 1.13.204(59004) idle
3528403 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2= =A0 0:00 postgres: enterprisedb er_db 10.23.0.203(44250) idle
3532345 ? = =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_= db 10.23.0.203(64230) idle
3533852 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2= =A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203(34514) idle
353= 3969 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterpris= edb g_db 10.21.13.202(58464) idle


3354541 ? =C2=A0 =C2=A0 =C2=A0= =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203(62640= ) idle
3356744 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0I =C2=A0 =C2=A0 =C2=A00:00 [= kworker/3:2]
3365496 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 = postgres: enterprisedb er_db 10.23.0.203(47376) idle
3367163 ? =C2=A0 = =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.2= 3.0.203(48814) idle
3368555 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2= =A0 0:00 postgres: enterprisedb er_db 10.23.0.203(56520) idle
3370980 ? = =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_= db 10.23.0.203(19930) idle
3371824 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2= =A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203(36006) idle
337= 2285 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterpris= edb er_db 10.23.0.203(37632) idle
3373166 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0S= s =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203(36862) idle3379317 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: ente= rprisedb er_db 10.23.0.203(17632) idle
3385442 ? =C2=A0 =C2=A0 =C2=A0 = =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203(21096)= idle
3385790 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgre= s: enterprisedb er_db 10.23.0.203(47792) idle
3389859 ? =C2=A0 =C2=A0 = =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203= (56094) idle
3397876 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 = postgres: enterprisedb er_db 10.23.0.203(32436) idle
3404172 ? =C2=A0 = =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb ad_db 10.2= 3.0.206(37122) idle
3404779 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2= =A0 0:00 postgres: enterprisedb er_db 10.23.0.203(62946) idle
3405628 ? = =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_= db 10.23.0.203(37568) idle
3406414 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2= =A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203(50994) idle
340= 8051 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterpris= edb er_db 10.23.0.203(14956) idle
3410935 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0I= =C2=A0 =C2=A0 =C2=A00:00 [kworker/7:2-events]
3432820 ? =C2=A0 =C2=A0 = =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb er_db 10.23.0.203= (31348) idle
3434126 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:01 = postgres: enterprisedb ad_db 10.23.0.206(48372) idle
3436428 ? =C2=A0 = =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2=A0 0:00 postgres: enterprisedb mt_db 10.2= 3.0.207(36930) idle
3443063 ? =C2=A0 =C2=A0 =C2=A0 =C2=A0Ss =C2=A0 =C2= =A0 0:00 postgres: enterprisedb er_db 10.23.0.203(57624) idle




--00000000000017d4fb0621adf2ae--