Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 346696335C2 for ; Wed, 2 Jun 2010 08:19:15 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 39134-01-7 for ; Wed, 2 Jun 2010 11:19:06 +0000 (UTC) X-Greylist: delayed 00:05:24.500803 by SQLgrey-1.7.6 Received: from adslmx1.onecell.co.za (adslmx1.onecell.co.za [196.214.51.138]) by mail.postgresql.org (Postfix) with ESMTP id 2E3DD633B55 for ; Wed, 2 Jun 2010 08:18:20 -0300 (ADT) Received: from [192.168.21.54] [192.168.21.54] by aximail (Axigen) with ESMTP id 372DF7; Wed, 2 Jun 2010 13:12:31 +0200 Subject: Overusing 1 CPU From: Mozzi To: pgsql-performance@postgresql.org Content-Type: text/plain; charset="UTF-8" Date: Wed, 02 Jun 2010 13:12:40 +0200 Message-ID: <1275477160.1818.48.camel@stefaans-laptop> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-AxigenSpam-Level: 4 X-AxigenVirus-Level: 1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201006/19 X-Sequence-Number: 38875 Hallo all I have a strange problem here. I have a pgsql database running on Intel hardware here, it has 8 cores hyperthreaded so you see 16 cpu's. This box is basically adle @ the moment as it is still in testing yet top shows high usage on just 1 of the cores. mpstat gives the below. As you can see only cpu 1 is verey bussy, the rest are idle. Thanx Mozzi 13:02:19 CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle 13:02:21 all 4.70 0.00 0.41 1.57 0.00 0.00 0.00 0.00 93.32 13:02:21 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 1 72.68 0.00 5.37 21.46 0.00 0.49 0.00 0.00 0.00 13:02:21 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 3 0.00 0.00 0.51 0.00 0.00 0.00 0.00 0.00 99.49 13:02:21 4 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 7 0.00 0.00 0.36 0.00 0.00 0.00 0.00 0.00 99.64 13:02:21 8 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 9 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 11 0.00 0.00 0.00 1.00 0.00 0.00 0.00 0.00 99.00 13:02:21 12 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 13:02:21 13 0.00 0.00 0.00 2.00 0.00 0.00 0.00 0.00 98.00 13:02:21 14 0.00 0.00 0.51 0.00 0.00 0.00 0.00 0.00 99.49 13:02:21 15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: CPU %usr %nice %sys %iowait %irq %soft %steal %guest %idle Average: all 4.66 0.00 0.43 1.46 0.00 0.04 0.00 0.00 93.41 Average: 0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 1 72.27 0.00 5.47 21.58 0.00 0.59 0.00 0.00 0.10 Average: 2 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 3 0.10 0.00 0.50 0.00 0.00 0.00 0.00 0.00 99.40 Average: 4 0.10 0.00 0.10 0.00 0.00 0.00 0.00 0.00 99.80 Average: 5 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 6 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 7 0.00 0.00 0.10 0.60 0.00 0.00 0.00 0.00 99.30 Average: 8 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 9 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 10 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 11 0.00 0.00 0.00 0.20 0.00 0.00 0.00 0.00 99.80 Average: 12 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00 Average: 13 0.00 0.00 0.10 0.40 0.00 0.00 0.00 0.00 99.50 Average: 14 0.00 0.00 0.50 0.00 0.00 0.00 0.00 0.00 99.50 Average: 15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 100.00