Re: heavy load-high cpu itilization

From: Filippos <filippos(dot)kal(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: heavy load-high cpu itilization
Date: 2011-07-31 12:17:36
Message-ID: 1312114656645-4651856.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

thx a lot for your answer.
i will provide some stats, so if you could help me figure out the source of
the problem that would be great

-top -c
Tasks: 1220 total, 49 running, 1171 sleeping, 0 stopped, 0 zombie
Cpu(s): 84.1%us, 2.8%sy, 0.0%ni, 12.3%id, 0.1%wa, 0.1%hi, 0.6%si,
0.0%st
Mem: 98846996k total, 98632044k used, 214952k free, 134320k buffers
Swap: 50331640k total, 116312k used, 50215328k free, 89445208k cached

-SELECT count(procpid) FROM pg_stat_activity -> 422
-SELECT count(procpid) FROM pg_stat_activity WHERE (NOW() - query_start) >
INTERVAL '1 MINUTES' AND current_query = '<IDLE>' -> 108
-SELECT count(procpid) FROM pg_stat_activity WHERE (NOW() - query_start) >
INTERVAL '5 MINUTES' AND current_query = '<IDLE>' -> 45

-vmstat -n 1 10
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu------
r b swpd free buff cache si so bi bo in cs us sy id
wa st
41 1 116300 347008 134176 89608912 0 0 143 210 0 0 11 1 88
0 0
20 0 116300 423556 134116 89581840 0 0 8336 3038 11118 21139 81 5
13 0 0
24 0 116300 412904 134108 89546840 0 0 8488 9025 10621 22921 81 4
15 0 0
23 0 116300 409388 134084 89513728 0 0 8320 548 11386 20226 82 4
14 0 0
34 0 116300 403688 134088 89509520 0 0 6336 0 9552 20994 83 3
14 0 0
22 1 116300 337972 134104 89518624 0 0 8792 28 8980 20455 83 4
13 0 0
37 0 116300 303956 134116 89528720 0 0 8440 536 9644 20492 84 3
13 0 0
17 1 116300 293212 134112 89532816 0 0 5864 8240 9527 19771 85 3
12 0 0
14 0 116300 282168 134116 89540720 0 0 7772 752 10141 21780 84 3
13 0 0
44 0 116300 278684 134100 89536080 0 0 7352 555 9856 21539 85 2
13 0 0

-vmstat -s
98846992 total memory
98685392 used memory
40342200 active memory
52644588 inactive memory
161604 free memory
129960 buffer memory
89421936 swap cache
50331640 total swap
116300 used swap
50215340 free swap
2258553017 non-nice user cpu ticks
1125281 nice user cpu ticks
146638389 system cpu ticks
17789847697 idle cpu ticks
83090716 IO-wait cpu ticks
5045742 IRQ cpu ticks
38895985 softirq cpu ticks
0 stolen cpu ticks
29142450583 pages paged in
42731005078 pages paged out
39784 pages swapped in
3395187 pages swapped out
1338370564 interrupts
1176640487 CPU context switches
1305704895 boot time
24471946 forks

(after 30 sec)
-vmstat -s
98846992 total memory
98367312 used memory
39959952 active memory
52957104 inactive memory
479684 free memory
129720 buffer memory
89410640 swap cache
50331640 total swap
116296 used swap
50215344 free swap
2258645091 non-nice user cpu ticks
1125282 nice user cpu ticks
146640181 system cpu ticks
17789863186 idle cpu ticks
83090856 IO-wait cpu ticks
5045855 IRQ cpu ticks
38896749 softirq cpu ticks
0 stolen cpu ticks
29142861271 pages paged in
42731249289 pages paged out
39784 pages swapped in
3395187 pages swapped out
1338808821 interrupts
1177463384 CPU context switches
1305704895 boot time
24472003 forks

from the above -> context switches /s = (1177463384 - 1176640487)/30 = 27429

thx in advance for any advice

--
View this message in context: http://postgresql.1045698.n5.nabble.com/heavy-load-high-cpu-itilization-tp4647751p4651856.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Ayrapetyan 2011-07-31 13:51:47 Performance die when COPYing to table with bigint PK
Previous Message Filippos 2011-07-30 20:02:11 Re: heavy load-high cpu itilization