Re: understanding postgres issues/bottlenecks - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: understanding postgres issues/bottlenecks
Date
Msg-id dcc563d10901061250i766ecdeeu2f1b2e3e8fe32770@mail.gmail.com
Whole thread Raw
In response to Re: understanding postgres issues/bottlenecks  (Stefano Nichele <stefano.nichele@gmail.com>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Stefano Nichele
Date:
Subject: Re: understanding postgres issues/bottlenecks
Next
From: "David Rees"
Date:
Subject: Re: understanding postgres issues/bottlenecks