I'm guessing you have a 4 cpu box:
1 99 percent busy process on a 4 way box == about 25% busy overall.
On May 5, 2004, at 6:03 AM, Tom Lane wrote:
> "Cyrille Bonnet" <cyrille@3months.com> writes:
>> Should I be worried that Postgres is eating up 99% of my CPU??? Or is
>> this
>> *expected* behaviour?
>
> It's not expected, unless you are running some very long-running query.
>
> The conflict between what top says and what mpstat says is strange; I
> wonder if you might have a buggy version of one of them? You should
> probably check some other tools (try "vmstat 1" for instance) to see if
> you can get a consensus on whether the CPU is maxed out or not ...
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
