Hi Fellas,
Not sure how I can dig in even further but we notice that one of our DB servers is showing high Sys% CPU usage even though when I execute the following command :
I can see that postgres is the only one using the CPU. So if anyone can advise me what would be the best way to trace down what type of System processes/tasks/activities could be running and possibly driving the high CPU usage would be great. thanks...
Hi,
Can you let us know some more about your system and it's OS please.
Regards
Gull04
Maybe consider a book or online resource tutorial optimizing postgres, for example:
Note: I'm not recommending the book above, it is just an example of an "optimize your postgres db" book .....
I've not used Postgres in ages and am still using MySQL, generally speaking and only have experience tuning MySQL for the past ten years or so,
Hi,
The version details are below:
Linux: Linux version 3.10.0-514.6.2.el7.x86_64 (mockbuild@x86-017.build.eng.bos.redhat.com) │
│ Build: (gcc version 4.8.5 20150623 (Red Hat 4.8.5-11) (GCC) ) │
│ Release : 3.10.0-514.6.2.el7.x86_64 │
│ Version : #1 SMP Fri Feb 17 19:21:31 EST 2017 │
│ cpuinfo: model name : Intel(R) Xeon(R) CPU E5-2650 v4 @ 2.20GHz │
│ cpuinfo: vendor_id : GenuineIntel │
│ cpuinfo: microcode : 0xb00001f │
│ cpuinfo: cpuid level : 20 │
│ # of CPUs: 48 │
│ Machine : x86_64 │
│ Nodename : gdm │
│ /etc/*ease[1]: NAME="Red Hat Enterprise Linux Server" │
│