Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Andy ColsonDate: 2009-08-19 15:52:40
Subject: Re: PG 8.3 and server load
Previous:From: Matthew WakelingDate: 2009-08-19 15:37:13
Subject: Re: PG 8.3 and server load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group