Server showing high Sys% CPU usage


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Server showing high Sys% CPU usage
# 1  
Server showing high Sys% CPU usage

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 :
Quote:
ps -eo pid,ppid,cmd,%mem,%cpu --sort=-%cpu
PID PPID CMD %MEM %CPU
496842 394979 postgres: port 40003, s4402 0.0 68.8
496825 394975 postgres: port 40000, s4402 0.0 68.7
496847 394980 postgres: port 40004, s4402 0.0 67.8
496836 394972 postgres: port 40002, s4402 0.0 67.2
496830 394969 postgres: port 40001, s4402 0.0 66.7
496852 394974 postgres: port 40005, s4402 0.0 64.9
496726 394974 postgres: port 40005, s4402 0.0 16.2
496720 394980 postgres: port 40004, s4402 0.0 15.6
496703 394969 postgres: port 40001, s4402 0.0 15.4
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...
# 2  
Hi,

Can you let us know some more about your system and it's OS please.

Regards

Gull04
This User Gave Thanks to gull04 For This Post:
# 3  
Maybe consider a book or online resource tutorial optimizing postgres, for example:

PostgreSQL 9.6 High Performance: Optimize your database with configuration tuning, routine maintenance, monitoring tools, query optimization and more

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,

Last edited by hicksd8; 08-15-2019 at 11:04 AM..
This User Gave Thanks to Neo For This Post:
# 4  
Hi,

The version details are below:
Code:
 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"                                                                                                                                                                                 │
│

Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #133
Difficulty: Easy
The first prototypes of Linux were publicly released in 1991.
True or False?

10 More Discussions You Might Find Interesting

1. Solaris

How can i restrict user high cpu usage?

HI In my M5000 , one of domain is having SAp installed. from today onwards we are facing some stange issue. when we start SAP application, that particular user is taking 95 % of system CP and renaming 5 % is taken by system . because of this reason application is slow. i have 4 CPU(32... (4 Replies)
Discussion started by: bentech4u
4 Replies

2. Shell Programming and Scripting

High cpu usage

I have created one script and i have added it into cron to run after 10 mins. However I have noted that whenever that script runs, It causes CPU utilization of server to increase about 10-20 % I have rechecked script and there is no way i can make changes, Script contain only 2-3 commands. So... (4 Replies)
Discussion started by: Nakul_sh
4 Replies

3. AIX

High CPU Usage , users affected

Dear All, One production Server is affected by high usage. Application is slow now. Please guide me how to solve it? NMON Report shows full cpu usage. Here im posting some server details. bash-3.2# lparstat -i Node Name : ********* Partition Name ... (6 Replies)
Discussion started by: Thala
6 Replies

4. AIX

Wait time shows high CPU usage

Hi, I can't seem to make sense of this. My wait time is showing really high but vmstat's and topas are showing normal usage. ps aux USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND root 9961810 5680.7 0.0 448 384 - A Dec 16 6703072:12 wait ... (2 Replies)
Discussion started by: techy1
2 Replies

5. Linux

System Went panic after CPU usage high

Hi All, Yesterday my Linux server went panic and even a small command took a lot of time to run. When i monitored pl find the below output Cpu(s): 0.1%us, 98.4%sy, 0.0%ni, 1.5%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st the time spent on kernel mode is 98 % and also idle time is around 1.5 %...... (4 Replies)
Discussion started by: jegaraman
4 Replies

6. AIX

HELP!!! high CPU usage with ITM kuxagent

ibm tivoli monitor's kuxagent is taking up a lot of cpu usage. anybody has any idea? i attatched a screenshot. (3 Replies)
Discussion started by: curtis911
3 Replies

7. AIX

Script to identify high CPU usage processes

Hi Guys, I need to write a script capable of identifying when a high cpu utilitzation process. It sounds simple but we are on a AIX 5.3 environment with Virtual CPU's (VP's) and logical CPU's. Please any ideas or tips would be highly appreciated. Thanks. Harby. (6 Replies)
Discussion started by: arizah
6 Replies

8. Ubuntu

High System CPU Usage

I am running a Dell PE R815 with 4 x AMD 12 core CPUs with 128GB of RAM and a RAID 5 array of 6 SAS disks. This is an HPC application and is definitely CPU bound, however once I run 16 of these processes (thus pinning 16 cores) the work performed slows down dramatically, to maybe 5 or 10% of what... (2 Replies)
Discussion started by: mowmentous
2 Replies

9. AIX

How to monitor the IBM AIX server for I/O usage,memory usage,CPU usage,network..?

How to monitor the IBM AIX server for I/O usage, memory usage, CPU usage, network usage, storage usage? (3 Replies)
Discussion started by: laknar
3 Replies

10. Linux

Help pinpointing high HTTPD CPU usage in TOP

Hi, new here and need some help. Sometimes my site is extremely slow, if when there aren't too many people on, whereas when there are over 300 online members the site may be very fast. We use CentOS, PHP 5.26. The server has 4GB and Plesk usually shows about 2 or 3 GB free. I believe I can see... (4 Replies)
Discussion started by: pspace
4 Replies