Re: PG 8.3 and server load

From: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PG 8.3 and server load
Date: 2009-08-19 15:40:40
Message-ID: e373d31e0908190840j589ccacbub4969c68def887e6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Aug 19, 2009 at 11:37 PM, Andy Colson<andy(at)squeakycode(dot)net> wrote:

>
> Phoenix: run top again, and hit the '1' key. It'll show you stats for
each
> cpu. Is one pegged and the others idle?
>

top - 10:38:53 up 29 days, 5 min, 1 user, load average: 64.99, 65.17,
65.06
Tasks: 568 total, 1 running, 537 sleeping, 6 stopped, 24 zombie
Cpu0 : 17.7% us, 7.7% sy, 0.0% ni, 74.0% id, 0.7% wa, 0.0% hi, 0.0% si
Cpu1 : 6.3% us, 5.6% sy, 0.0% ni, 84.4% id, 3.6% wa, 0.0% hi, 0.0% si
Cpu2 : 5.6% us, 5.9% sy, 0.0% ni, 86.8% id, 1.7% wa, 0.0% hi, 0.0% si
Cpu3 : 5.6% us, 4.0% sy, 0.0% ni, 74.2% id, 16.2% wa, 0.0% hi, 0.0% si
Mem: 8310256k total, 8277416k used, 32840k free, 61944k buffers
Swap: 2096440k total, 16128k used, 2080312k free, 7664224k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND

9922 nobody 15 0 49024 16m 7408 S 3.0 0.2 0:00.52 httpd

9630 nobody 15 0 49020 16m 7420 S 2.3 0.2 0:00.60 httpd

9848 nobody 16 0 48992 16m 7372 S 2.3 0.2 0:00.51 httpd

10995 nobody 15 0 49024 16m 7304 S 2.3 0.2 0:00.35 httpd

11031 nobody 15 0 48860 16m 7104 S 2.3 0.2 0:00.34 httpd

6701 nobody 15 0 49028 17m 7576 S 2.0 0.2 0:01.50 httpd

10996 nobody 15 0 48992 16m 7328 S 2.0 0.2 0:00.31 httpd

12232 nobody 15 0 48860 16m 7004 S 1.7 0.2 0:00.05 httpd

9876 nobody 15 0 48992 16m 7400 S 1.3 0.2 0:00.73 httpd

12231 nobody 15 0 48860 16m 6932 S 1.3 0.2 0:00.04 httpd

12233 nobody 16 0 48860 16m 6960 S 1.3 0.2 0:00.04 httpd

20315 postgres 19 0 325m 9732 9380 S 1.0 0.1 0:10.39 postmaster

31573 nobody 15 0 49024 17m 7664 S 1.0 0.2 0:03.14 httpd

7954 nobody 15 0 49032 16m 7400 S 1.0 0.2 0:01.14 httpd

9918 nobody 15 0 48956 16m 7344 S 1.0 0.2 0:00.44 httpd

12298 nobody 16 0 48860 16m 6780 S 1.0 0.2 0:00.03 httpd

6479 nobody 16 0 49040 16m 7412 S 0.7 0.2 0:01.20 httpd

7950 nobody 15 0 49020 16m 7388 S 0.7 0.2 0:00.83 httpd

7951 nobody 15 0 49032 16m 7384 S 0.7 0.2 0:01.03 httpd

9875 nobody 15 0 48948 16m 7096 S 0.7 0.2 0:00.51 httpd

9916 nobody 16 0 48860 16m 7124 S 0.7 0.2 0:00.59 httpd

10969 nobody 15 0 49036 16m 7380 S 0.7 0.2 0:00.29 httpd

11752 root 16 0 3620 1288 772 R 0.7 0.0 0:00.14 top

12309 nobody 16 0 48860 16m 6844 S 0.7 0.2 0:00.02 httpd

20676 mysql 15 0 182m 20m 2916 S 0.3 0.3 0:00.95 mysqld

20811 root 21 0 47920 14m 5872 S 0.3 0.2 0:00.71 httpd

7952 nobody 15 0 49024 16m 7524 S 0.3 0.2 0:00.96 httpd

11036 nobody 15 0 48992 16m 7320 S 0.3 0.2 0:00.36 httpd

12230 nobody 15 0 48860 16m 6956 S 0.3 0.2 0:00.01 httpd

12297 nobody 16 0 48860 16m 6932 S 0.3 0.2 0:00.01 httpd

12299 nobody 16 0 48992 16m 7120 S 0.3 0.2 0:00.01 httpd

12301 nobody 20 0 48860 16m 6816 S 0.3 0.2 0:00.01 httpd

12307 nobody 15 0 48860 16m 6880 S 0.3 0.2 0:00.01 httpd

> do a 'cat /proc/cpuinfo' and make sure your os is seeing all your cpus.
>

I guess it's using all 4?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Colson 2009-08-19 15:52:40 Re: PG 8.3 and server load
Previous Message Matthew Wakeling 2009-08-19 15:37:13 Re: PG 8.3 and server load