<IDLE> connections and cpu consumption

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: <IDLE> connections and cpu consumption
Date: 2011-11-09 18:35:49
Message-ID: 482E80323A35A54498B8B70FF2B8798004D5DE1499@azsmsx504.amr.corp.intel.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

PG v4.8.3 on Linux

I'm using "selcet procpid,current_query from pg_stat_activity" to monitor activity during times when "top" is showing many PG procs with very high cpu usage numbers (all cores at or above 90%). Some of these are procs that map to PG connections with current_query = <IDLE>.

What scenarios could explain a process identified as IDLE consuming lots of CPU?

More clues... In parallel with these was a user that was making a series of insert/delete/update commands that fire off triggers that generate more DML recursively. Some of the idles are "<IDLE> in transaction".

Thanks for any help !

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-11-09 18:41:19 Re: DB Dump
Previous Message Raymond O'Donnell 2011-11-09 18:07:44 Re: DB Dump