Re: Amazon EC2 CPU Utilization

Greg Smith <greg@2ndquadrant.com>

From: Greg Smith <greg@2ndquadrant.com>
To: Mike Bresnahan <mike.bresnahan@bestbuy.com>
Cc: pgsql-general@postgresql.org
Date: 2010-01-27T22:53:49Z
Lists: pgsql-bugs, pgsql-general
Mike Bresnahan wrote:
> top - 15:55:05 up  1:33,  2 users,  load average: 2.44, 0.98, 0.44
> Tasks: 123 total,  11 running, 112 sleeping,   0 stopped,   0 zombie
> Cpu(s): 18.9%us,  8.8%sy,  0.0%ni, 70.6%id,  0.0%wa,  0.0%hi,  1.7%si,  0.0%st
> Mem:   7348132k total,  1886912k used,  5461220k free,    34432k buffers
> Swap:        0k total,        0k used,        0k free,  1456472k cached
>
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND           
>                                                                                
>                                          
>  2834 postgres  15   0  191m  72m  70m S   16  1.0   0:00.66 postmaster                                                                                       
>                                           
>  2838 postgres  15   0  191m  66m  64m R   15  0.9   0:00.62 postmaster        
>                                                                        

Could you try this again with "top -c", which will label these 
postmaster processes usefully, and include the pgbench client itself in 
what you post?  It's hard to sort out what's going on in these 
situations without that style of breakdown.

-- 
Greg Smith    2ndQuadrant   Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com  www.2ndQuadrant.com