Re[4]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>Oh... and you can also tell top to show the "last used processor". I
>guess I should have said this first ;-)

Even if do not fix it, I'll know a new feature of top :)
Certainly sure 14 CPU


 Total DISK READ: top - 21:54:38 up 453 days, 23:34,  1 user,  load average: 0.56, 0.55, 0.48
Tasks: 429 total,   1 running, 428 sleeping,   0 stopped,   0 zombie
Cpu0  :  0.2%us,  0.1%sy,  0.0%ni, 99.7%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu1  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu2  :  0.1%us,  0.1%sy,  0.0%ni, 99.8%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu3  :  0.7%us,  0.1%sy,  0.0%ni, 99.3%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu4  :  1.5%us,  0.4%sy,  0.0%ni, 98.0%id,  0.0%wa,  0.0%hi,  0.1%si,  0.0%st
Cpu5  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu6  :  2.1%us,  0.2%sy,  0.0%ni, 97.4%id,  0.2%wa,  0.0%hi,  0.1%si,  0.0%st
Cpu7  :  2.4%us,  0.4%sy,  0.0%ni, 97.0%id,  0.0%wa,  0.0%hi,  0.2%si,  0.0%st
Cpu8  :  1.4%us,  0.4%sy,  0.0%ni, 98.1%id,  0.0%wa,  0.0%hi,  0.1%si,  0.0%st
Cpu9  :  0.0%us,  0.0%sy,  0.0%ni,100.0%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu10 :  0.1%us,  0.0%sy,  0.0%ni, 99.9%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu11 :  1.2%us,  0.5%sy,  0.0%ni, 97.9%id,  0.0%wa,  0.0%hi,  0.5%si,  0.0%st
Cpu12 :  0.1%us,  0.0%sy,  0.0%ni, 99.9%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu13 :  0.1%us,  0.0%sy,  0.0%ni, 99.9%id,  0.0%wa,  0.0%hi,  0.0%si,  0.0%st
Cpu14 : 20.5%us,  0.9%sy,  0.0%ni, 78.1%id,  0.4%wa,  0.0%hi,  0.1%si,  0.0%st
Cpu15 :  1.2%us,  0.1%sy,  0.0%ni, 98.5%id,  0.0%wa,  0.0%hi,  0.2%si,  0.0%st
Mem:  16426540k total, 16173980k used,   252560k free,   219348k buffers
Swap:  4194232k total,   147296k used,  4046936k free, 14482096k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+   P COMMAND
   47 root      RT  -5     0    0    0 S  0.0  0.0   0:34.84 15 [migration/15]
   48 root      34  19     0    0    0 S  0.0  0.0   0:01.42 15 [ksoftirqd/15]
   49 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 15 [watchdog/15]
   65 root      10  -5     0    0    0 S  0.0  0.0   0:00.03 15 [events/15]
  238 root      10  -5     0    0    0 S  0.0  0.0   0:03.76 15 [kblockd/15]
  406 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 15 [cqueue/15]
  601 root      15   0     0    0    0 S  0.0  0.0  88:52.30 15 [pdflush]
  620 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 15 [aio/15]
  964 root      17  -5     0    0    0 S  0.0  0.0   0:00.00 15 [ata/15]
 2684 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 15 [kmpathd/15]
 2914 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 15 [rpciod/15]
 3270 root      19  -5     0    0    0 S  0.0  0.0   0:00.00 15 [ib_cm/15]
 5906 rpc       15   0  8072  688  552 S  0.0  0.0   0:00.00 15 portmap
14979 postgres  15   0 4316m 104m 103m S  0.0  0.6   6:54.39 15 /usr/pgsql-9.1/bin/postmaster -p 5432 -D /var/lib/pgsql/9.1/data
   44 root      RT  -5     0    0    0 S  0.0  0.0   0:40.50 14 [migration/14]
   45 root      34  19     0    0    0 S  0.0  0.0   0:03.51 14 [ksoftirqd/14]
   46 root      RT  -5     0    0    0 S  0.0  0.0   0:00.00 14 [watchdog/14]
   64 root      10  -5     0    0    0 S  0.0  0.0   0:00.04 14 [events/14]
  237 root      10  -5     0    0    0 S  0.0  0.0   9:51.44 14 [kblockd/14]
  405 root      13  -5     0    0    0 S  0.0  0.0   0:00.00 14 [cqueue/14]
  619 root      15  -5     0    0    0 S  0.0  0.0   0:00.00 14 [aio/14]
  963 root      16  -5     0    0    0 S  0.0  0.0   0:00.00 14 [ata/14]
 1092 root      10  -5     0    0    0 S  0.0  0.0  52:21.12 14 [kjournald]
 2683 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 14 [kmpathd/14]
 2724 root      10  -5     0    0    0 S  0.0  0.0   2:15.40 14 [kjournald]
 2726 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 14 [kjournald]
 2913 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 14 [rpciod/14]
 3269 root      18  -5     0    0    0 S  0.0  0.0   0:00.00 14 [ib_cm/14]
 8970 postgres  16   0 4327m 205m 197m S  0.2  1.3   0:01.33 14 postgres: user user_db [local] idle
 8973 postgres  15   0 4327m 199m 191m S  0.1  1.2   0:00.37 14 postgres: user user_db [local] idle
 8977 postgres  16   0 4328m  48m  40m S  0.7  0.3   0:00.76 14 postgres: user user_db [local] idle
 8980 postgres  16   0 4328m  51m  43m S  0.1  0.3   0:00.50 14 postgres: user user_db [local] idle
 8981 postgres  15   0 4327m 203m 195m S  0.0  1.3   0:00.72 14 postgres: user user_db [local] idle
 8985 postgres  15   0 4327m  43m  36m S  0.1  0.3   0:00.29 14 postgres: user user_db [local] idle
 8988 postgres  16   0 4328m 205m 196m S  0.0  1.3   0:00.91 14 postgres: user user_db [local] idle
 8991 postgres  15   0 4327m 205m 197m S  0.1  1.3   0:00.79 14 postgres: user user_db [local] idle
 8993 postgres  15   0 4328m 207m 199m S  1.9  1.3   0:00.99 14 postgres: user user_db [local] idle
 8996 postgres  15   0 4328m 205m 196m S  1.1  1.3   0:00.93 14 postgres: user user_db [local] idle
 9000 postgres  16   0 4328m 207m 199m S  0.7  1.3   0:00.82 14 postgres: user user_db [local] idle
 9004 postgres  16   0 4329m 204m 194m S  0.1  1.3   0:00.69 14 postgres: user user_db [local] idle
 9005 postgres  15   0 4327m 200m 193m S  0.7  1.2   0:00.63 14 postgres: user user_db [local] idle
 9007 postgres  15   0 4327m 199m 192m S  0.1  1.2   0:00.49 14 postgres: user user_db [local] idle
 9010 postgres  15   0 4327m 202m 195m S  0.2  1.3   0:00.65 14 postgres: user user_db [local] idle
 9016 postgres  15   0 4326m  34m  28m S  0.1  0.2   0:00.15 14 postgres: user user_db [local] idle
 9018 postgres  16   0 4327m 203m 195m S  1.0  1.3   0:00.72 14 postgres: user user_db [local] idle
 9020 postgres  15   0 4327m  45m  37m S  0.1  0.3   0:00.49 14 postgres: user user_db [local] idle
 9022 postgres  15   0 4327m  42m  35m S  0.1  0.3   0:00.20 14 postgres: user user_db [local] idle
 9025 postgres  16   0 4328m 201m 193m S  0.3  1.3   0:00.75 14 postgres: user user_db [local] idle
 9026 postgres  16   0 4327m  47m  40m S  0.1  0.3   0:00.49 14 postgres: user user_db [local] idle
 9038 postgres  16   0 4327m 201m 193m S  0.1  1.3   0:00.70 14 postgres: user user_db [local] idle
 9042 postgres  15   0 4327m 201m 193m S  1.8  1.3   0:00.71 14 postgres: user user_db [local] idle
 9046 postgres  15   0 4327m 201m 193m S  0.1  1.3   0:00.65 14 postgres: user user_db [local] idle
 9048 postgres  15   0 4327m 200m 193m S  1.4  1.2   0:00.52 14 postgres: user user_db [local] idle
 9049 postgres  15   0 4328m 200m 192m S  0.1  1.2   0:00.50 14 postgres: user user_db [local] idle
 9053 postgres  15   0 4327m  44m  37m S  0.1  0.3   0:00.34 14 postgres: user user_db [local] idle
 9054 postgres  16   0 4327m  46m  40m S  0.1  0.3   0:00.43 14 postgres: user user_db [local] idle
 9055 postgres  16   0 4328m 200m 192m S  0.0  1.3   0:00.39 14 postgres: user user_db [local] idle
 9056 postgres  16   0 4328m 201m 192m S  0.7  1.3   0:00.75 14 postgres: user user_db [local] idle
 9057 postgres  16   0 4327m 200m 192m S  0.2  1.3   0:00.72 14 postgres: user user_db [local] idle
 9061 postgres  15   0 4328m 200m 192m S  0.0  1.2   0:00.49 14 postgres: user user_db [local] idle
 9065 postgres  15   0 4328m 204m 196m S  0.3  1.3   0:00.80 14 postgres: user user_db [local] idle
 9067 postgres  15   0 4327m  43m  35m S  0.0  0.3   0:00.30 14 postgres: user user_db [local] idle
 9071 postgres  15   0 4327m  48m  40m S  0.1  0.3   0:00.53 14 postgres: user user_db [local] idle
 9076 postgres  15   0 4326m  43m  36m S  0.0  0.3   0:00.61 14 postgres: user user_db [local] idle
 9078 postgres  15   0 4328m 206m 198m S  0.0  1.3   0:00.64 14 postgres: user user_db [local] idle
 9079 postgres  15   0 4327m  45m  38m S  0.0  0.3   0:00.37 14 postgres: user user_db [local] idle
 9080 postgres  16   0 4327m 200m 193m S  0.0  1.3   0:00.62 14 postgres: user user_db [local] idle
 9082 postgres  16   0 4328m 202m 193m S  1.5  1.3   0:00.84 14 postgres: user user_db [local] idle
 9084 postgres  15   0 4327m  46m  38m S  0.0  0.3   0:00.54 14 postgres: user user_db [local] idle
 9086 postgres  15   0 4328m 203m 194m S  0.0  1.3   0:00.38 14 postgres: user user_db [local] idle
 9087 postgres  16   0 4327m 199m 192m S  1.0  1.2   0:00.63 14 postgres: user user_db [local] idle
 9089 postgres  16   0 4328m 205m 196m S  0.2  1.3   0:00.87 14 postgres: user user_db [local] idle
 9091 postgres  15   0 4327m  45m  38m S  0.1  0.3   0:00.41 14 postgres: user user_db [local] idle
 9092 postgres  16   0 4326m  41m  34m S  0.0  0.3   0:00.27 14 postgres: user user_db [local] idle
 9098 postgres  16   0 4329m 203m 194m S  3.5  1.3   0:00.65 14 postgres: user user_db [local] idle
 9099 postgres  16   0 4327m  45m  38m S  0.0  0.3   0:00.41 14 postgres: user user_db [local] idle
13629 root      18   0 65288  280  140 S  0.0  0.0   0:00.00 14 rpc.rquotad

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux