Re: understanding postgres issues/bottlenecks

On Tue, Jan 6, 2009 at 12:02 PM, Stefano Nichele
<stefano(dot)nichele(at)gmail(dot)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.