From: Scott Marlowe <scott.marlowe@gmail.com>
To: Stefano Nichele <stefano.nichele@gmail.com>
Cc: Merlin Moncure <mmoncure@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: understanding postgres issues/bottlenecks
Date: Tue, 6 Jan 2009 13:50:09 -0700
Message-ID: <dcc563d10901061250i766ecdeeu2f1b2e3e8fe32770@mail.gmail.com> (raw)
In-Reply-To: <4963AACF.2070201@gmail.com>
References: <49638BE9.2030701@gmail.com>
<b42b73150901060916w11982ba3pb10ccd7de30178ad@mail.gmail.com>
<4963AACF.2070201@gmail.com>
On Tue, Jan 6, 2009 at 12:02 PM, Stefano Nichele
<stefano.nichele@gmail.com> wrote:
> Thanks for your help. I'll give you the info you asked as soon as I'll have
> it (i have also to install iostat but I don't have enough privilege to do
> that).
>
> BTW, why did you said I/O bound ? Which are the parameters that highlight
> that ? Sorry for my ignorance....
In this output, the second to the last column is wa, which stands for
wait, the third to last is id, which is CPU idle.
r b swpd free buff cache si so bi bo in cs us sy id wa st
1 24 84 124204 25136 3257100 0 0 3037 1154 3359 7253 25 7 6 62 0
2 30 84 124704 25136 3256344 0 0 3004 1269 3553 7906 33 9 7 51 0
0 25 84 125784 24956 3253344 0 0 3357 773 3163 6454 17 4 10 68 0
So here the first line reports
25% user
7% system
6% idle
62% wait
So it's mostly waiting.
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: scott.marlowe@gmail.com, stefano.nichele@gmail.com, mmoncure@gmail.com
Subject: Re: understanding postgres issues/bottlenecks
In-Reply-To: <dcc563d10901061250i766ecdeeu2f1b2e3e8fe32770@mail.gmail.com>
* 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