top command output on DB server infront with pgbouncer
1234567891011121314151617181920212223242526272829303132333435363738394041
top - 23:00:04 up 134 days, 18:56, 4 users, load average: 13.65, 11.00, 9.55
Tasks: 694 total, 12 running, 682 sleeping, 0 stopped, 0 zombie
%Cpu0 : 37.9 us, 21.9 sy, 0.0 ni, 33.6 id, 5.6 wa, 0.7 hi, 0.3 si, 0.0 st
%Cpu1 : 40.7 us, 20.2 sy, 0.0 ni, 31.6 id, 5.1 wa, 0.7 hi, 1.7 si, 0.0 st
%Cpu2 : 34.3 us, 19.1 sy, 0.0 ni, 39.9 id, 5.6 wa, 0.7 hi, 0.3 si, 0.0 st
%Cpu3 : 37.2 us, 12.8 sy, 0.0 ni, 37.2 id, 7.0 wa, 1.0 hi, 4.7 si, 0.0 st
%Cpu4 : 37.5 us, 24.7 sy, 0.0 ni, 32.4 id, 4.3 wa, 0.7 hi, 0.3 si, 0.0 st
%Cpu5 : 41.6 us, 11.8 sy, 0.0 ni, 38.2 id, 4.4 wa, 1.0 hi, 3.0 si, 0.0 st
%Cpu6 : 45.2 us, 15.4 sy, 0.0 ni, 19.1 id, 16.4 wa, 1.0 hi, 3.0 si, 0.0 st
%Cpu7 : 35.7 us, 15.6 sy, 0.0 ni, 28.9 id, 12.6 wa, 1.0 hi, 6.1 si, 0.0 st
%Cpu8 : 30.5 us, 18.1 sy, 0.0 ni, 31.5 id, 19.1 wa, 0.7 hi, 0.0 si, 0.0 st
%Cpu9 : 32.2 us, 11.9 sy, 0.0 ni, 32.9 id, 17.6 wa, 1.0 hi, 4.4 si, 0.0 st
%Cpu10 : 41.6 us, 18.9 sy, 0.0 ni, 26.7 id, 5.4 wa, 1.0 hi, 6.4 si, 0.0 st
%Cpu11 : 48.5 us, 17.2 sy, 0.0 ni, 25.9 id, 7.7 wa, 0.7 hi, 0.0 si, 0.0 st
%Cpu12 : 43.1 us, 25.1 sy, 0.0 ni, 22.1 id, 5.7 wa, 0.7 hi, 3.3 si, 0.0 st
%Cpu13 : 39.6 us, 22.1 sy, 0.0 ni, 32.2 id, 5.4 wa, 0.7 hi, 0.0 si, 0.0 st
%Cpu14 : 34.3 us, 15.5 sy, 0.0 ni, 38.7 id, 8.8 wa, 0.7 hi, 2.0 si, 0.0 st
%Cpu15 : 42.2 us, 12.5 sy, 0.0 ni, 37.8 id, 6.8 wa, 0.7 hi, 0.0 si, 0.0 st
MiB Mem : 31837.6 total, 408.2 free, 14826.4 used, 25449.2 buff/cache
MiB Swap: 8060.0 total, 7041.2 free, 1018.8 used. 17011.2 avail Mem
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
2965397 enterpr+ 20 0 9035732 7.8g 7.8g R 32.9 25.1 0:24.73 edb-postgres
2943925 enterpr+ 20 0 9038404 8.2g 8.2g S 27.9 26.5 1:37.05 edb-postgres
2921680 enterpr+ 20 0 9026208 8.3g 8.2g R 23.9 26.5 5:41.80 edb-postgres
2952487 enterpr+ 20 0 9018532 8.2g 8.2g S 21.9 26.5 1:48.48 edb-postgres
2938924 enterpr+ 20 0 9032024 8.2g 8.2g S 20.3 26.5 2:34.22 edb-postgres
2941086 enterpr+ 20 0 9022532 8.2g 8.2g S 19.3 26.5 2:06.91 edb-postgres
2954392 enterpr+ 20 0 9020932 8.2g 8.2g S 18.6 26.4 1:09.66 edb-postgres
2950347 enterpr+ 20 0 9038336 8.2g 8.2g S 18.3 26.5 1:24.53 edb-postgres
2960312 enterpr+ 20 0 9038392 8.2g 8.1g R 18.3 26.3 0:48.69 edb-postgres
2938925 enterpr+ 20 0 9021292 8.2g 8.2g S 16.6 26.5 2:39.30 edb-postgres
2923742 enterpr+ 20 0 9025856 8.2g 8.2g S 16.3 26.5 4:52.92 edb-postgres
2934778 enterpr+ 20 0 9022084 8.2g 8.2g S 16.3 26.5 2:50.80 edb-postgres
2937920 enterpr+ 20 0 9021804 8.2g 8.2g R 14.3 26.5 2:36.43 edb-postgres
2942083 enterpr+ 20 0 9021724 8.2g 8.2g S 14.0 26.5 1:57.54 edb-postgres
2965430 enterpr+ 20 0 8947108 261936 254336 S 13.3 0.8 0:23.06 edb-postgres
2932696 enterpr+ 20 0 9041120 8.2g 8.2g S 13.0 26.5 3:05.67 edb-postgres
2965170 enterpr+ 20 0 8946972 282540 274816 S 12.3 0.9 0:20.50 edb-postgres
2969649 enterpr+ 20 0 8946084 169216 162688 S 9.6 0.5 0:01.87 edb-postgres
2970050 enterpr+ 20 0 8942988 278064 274432 D 8.6 0.9 0:00.26 edb-postgres
Assembly
INFO