Postgres Pro
Downloads
Home   >   mailing lists

Re: very high CPU usage in "top", but not in "mpstat" - Mailing list pgsql-performance

From Tom Lane
Subject Re: very high CPU usage in "top", but not in "mpstat"
Date
Msg-id 24916.1083762195@sss.pgh.pa.us
Whole thread Raw
In response to very high CPU usage in "top", but not in "mpstat"  ("Cyrille Bonnet" <cyrille@3months.com>)
Responses Re: very high CPU usage in "top", but not in "mpstat"  (Paul Tuckfield <paul@tuckfield.com>)
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: "Cyrille Bonnet"
Date:
Subject: very high CPU usage in "top", but not in "mpstat"
Next
From: James Robinson
Date:
Subject: History of oids in postgres?