Re: Amazon EC2 CPU Utilization - Mailing list pgsql-general
| From | Mike Bresnahan |
|---|---|
| Subject | Re: Amazon EC2 CPU Utilization |
| Date | |
| Msg-id | loom.20100128T002542-245@post.gmane.org Whole thread Raw |
| In response to | Amazon EC2 CPU Utilization (Mike Bresnahan <mike.bresnahan@bestbuy.com>) |
| List | pgsql-general |
> 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. I had run pgbench on a separate instance last time, but this time I ran it on the same machine. With the -c option, top(1) reports that many of the postgres processes are idle. top - 18:25:23 up 8 min, 2 users, load average: 1.52, 1.32, 0.55 Tasks: 218 total, 15 running, 203 sleeping, 0 stopped, 0 zombie Cpu(s): 32.3%us, 17.5%sy, 0.0%ni, 49.6%id, 0.0%wa, 0.0%hi, 0.0%si, 0.6%st Mem: 7358492k total, 1620500k used, 5737992k free, 11144k buffers Swap: 0k total, 0k used, 0k free, 1248388k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1323 postgres 20 0 50364 2192 1544 R 56.7 0.0 0:03.19 pgbench -S -c 16 -T 30 1337 postgres 20 0 197m 114m 112m R 25.4 1.6 0:01.35 postgres: postgres postgres [local] SELECT 1331 postgres 20 0 197m 113m 111m R 24.4 1.6 0:01.16 postgres: postgres postgres [local] idle 1335 postgres 20 0 197m 114m 112m R 24.1 1.6 0:01.30 postgres: postgres postgres [local] SELECT 1340 postgres 20 0 197m 113m 112m R 22.7 1.6 0:01.28 postgres: postgres postgres [local] idle 1327 postgres 20 0 197m 114m 113m R 22.1 1.6 0:01.26 postgres: postgres postgres [local] idle 1328 postgres 20 0 197m 114m 113m R 21.8 1.6 0:01.32 postgres: postgres postgres [local] SELECT 1332 postgres 20 0 197m 114m 112m R 21.8 1.6 0:01.11 postgres: postgres postgres [local] SELECT 1326 postgres 20 0 197m 112m 110m R 21.4 1.6 0:01.10 postgres: postgres postgres [local] idle 1325 postgres 20 0 197m 112m 110m R 20.8 1.6 0:01.28 postgres: postgres postgres [local] SELECT 1330 postgres 20 0 197m 113m 111m R 20.4 1.6 0:01.21 postgres: postgres postgres [local] idle 1339 postgres 20 0 197m 113m 111m R 20.4 1.6 0:01.10 postgres: postgres postgres [local] idle 1333 postgres 20 0 197m 114m 112m S 20.1 1.6 0:01.08 postgres: postgres postgres [local] SELECT 1336 postgres 20 0 197m 113m 111m S 19.8 1.6 0:01.10 postgres: postgres postgres [local] SELECT 1329 postgres 20 0 197m 113m 111m S 19.1 1.6 0:01.21 postgres: postgres postgres [local] idle 1338 postgres 20 0 197m 114m 112m R 19.1 1.6 0:01.28 postgres: postgres postgres [local] SELECT 1334 postgres 20 0 197m 114m 112m R 18.8 1.6 0:01.00 postgres: postgres postgres [local] idle 1214 root 20 0 14900 1348 944 R 0.3 0.0 0:00.41 top -c
pgsql-general by date: