pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: Mozzi <mozzi.glug@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Overusing 1 CPU
Date: Wed, 02 Jun 2010 13:12:40 +0200
Message-ID: <1275477160.1818.48.camel@stefaans-laptop> (raw )
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
view thread (6+ messages) latest in thread
Message-ID: <1275477160.1818.48.camel@stefaans-laptop>
Permalink: ../1275477160.1818.48.camel@stefaans-laptop/
Also on: postgresql.org/message-id/1275477160.1818.48.camel@stefaans-laptop
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mozzi.glug@gmail.com
Subject: Re: Overusing 1 CPU
In-Reply-To: <1275477160.1818.48.camel@stefaans-laptop>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox