High CPU usage buy low I/O wait

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Our server is running postgresql 8.4.15. During day time the cpu usage always
around 80%, but it's not IO bound. The swap space is looking OK also. Also
we setup pgbadger and enable all logs to monitor the slow query but they all
finished quick. Usually it has 60 incoming connections, and we have
pgbouncer to control the pool. Any suggestions I can look into it? Thank
you.
________________________________________________________________________
top - 19:21:28 up 33 days,  9:50,  1 user,  load average: 23.07, 22.39,
18.68
Tasks: 221 total,  19 running, 202 sleeping,   0 stopped,   0 zombie
Cpu0  : 96.3%us,  1.3%sy,  0.0%ni,  1.0%id,  0.3%wa,  0.0%hi,  1.0%si, 
0.0%st
Cpu1  : 98.0%us,  0.7%sy,  0.0%ni,  0.7%id,  0.3%wa,  0.0%hi,  0.3%si, 
0.0%st
Cpu2  : 98.7%us,  0.7%sy,  0.0%ni,  0.3%id,  0.0%wa,  0.0%hi,  0.3%si, 
0.0%st
Cpu3  : 97.7%us,  0.7%sy,  0.0%ni,  0.7%id,  0.7%wa,  0.0%hi,  0.3%si, 
0.0%st
Cpu4  : 96.4%us,  1.3%sy,  0.0%ni,  0.7%id,  1.0%wa,  0.0%hi,  0.7%si, 
0.0%st
Cpu5  : 98.3%us,  0.7%sy,  0.0%ni,  0.7%id,  0.3%wa,  0.0%hi,  0.0%si, 
0.0%st
Cpu6  : 98.7%us,  0.7%sy,  0.0%ni,  0.7%id,  0.0%wa,  0.0%hi,  0.0%si, 
0.0%st
Cpu7  : 97.7%us,  0.7%sy,  0.0%ni,  1.0%id,  0.3%wa,  0.0%hi,  0.3%si, 
0.0%st
Mem:  32959796k total, 32802508k used,   157288k free,   145484k buffers
Swap: 67108856k total,     1596k used, 67107260k free, 29718168k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                                                                                                                         
32119 postgres  16   0 8005m 2.7g 2.7g R 48.8  8.7   9:11.03 postmaster                                                                                                                                                                      
 3688 postgres  15   0 8005m 2.4g 2.4g R 41.5  7.7   7:52.75 postmaster                                                                                                                                                                      
23530 postgres  15   0 8003m 2.9g 2.8g S 39.2  9.1  11:02.56 postmaster                                                                                                                                                                      
23528 postgres  16   0 8002m 2.8g 2.8g S 37.5  8.9  11:13.92 postmaster                                                                                                                                                                      
23534 postgres  15   0 8007m 2.9g 2.9g S 36.5  9.3  11:21.66 postmaster                    

_______________________________________________________________________
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
 r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us sy id
wa st
18  5   1596 157668 145572 29696372    0    0   150   160    0    1 36  1 60 
4  0
27  2   1596 163952 145476 29689472    0    0  1408  1472 2142 2190 97  1  0 
1  0
21  1   1596 162824 145488 29691976    0    0  1548  3300 2269 2592 96  1  2 
1  0
24  3   1596 161248 145488 29693124    0    0  1144  1612 3426 2149 98  1  1 
0  0
11  2   1596 158900 145488 29696108    0    0  2368  1776 2189 2324 98  1  0 
1  0
15  3   1596 162144 145324 29693576    0    0  4412  1592 2669 2852 97  1  1 
1  0

____________________________________________________________________
checkpoint_completion_target = 0.9
max_connections = 160
shared_buffers = 7680MB
work_mem = 104MB
maintenance_work_mem = 1GB 
effective_cache_size = 22GB




--
View this message in context: http://postgresql.1045698.n5.nabble.com/High-CPU-usage-buy-low-I-O-wait-tp5751860.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux