Re: Why are IDLE connections using cpu according to TOP.

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: bubba postgres <bubba(dot)postgres(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why are IDLE connections using cpu according to TOP.
Date: 2011-06-03 21:39:15
Message-ID: BANLkTikeX9wauR=h-WLVfNLd98+4O6NeRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 3, 2011 at 3:15 PM, bubba postgres <bubba(dot)postgres(at)gmail(dot)com> wrote:
>
> I have an overloaded DB and I see several IDLE connections that are using
> significant CPU.. (Not Idle in transaction)
> Why would an idle process be eating so much cpu? Or is it not actually idle?

Because there's often a difference in time between when the process is
sampled for how hard it's working and the output that says what it's
doing. I.e. it was working hard, then when we looked at the part that
says what it's doing, it's not idle.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Shulgin 2011-06-03 21:45:28 Postmaster holding unlinked files for pg_largeobject table
Previous Message bubba postgres 2011-06-03 21:15:52 Why are IDLE connections using cpu according to TOP.