To: Jeff Davis <pgsql@j-davis.com>
cc: Dimi Paun <dimi@lattica.com>, pgsql-performance@postgresql.org
Subject: Re: What is postmaster doing? 
In-reply-to: <1287604781.28384.50.camel@jdavis-ux.asterdata.local> 
References: <1287600255.18151.58.camel@dimi.lattica.com>
	<1287604781.28384.50.camel@jdavis-ux.asterdata.local>
Comments: In-reply-to Jeff Davis <pgsql@j-davis.com>
	message dated "Wed, 20 Oct 2010 12:59:41 -0700"
Date: Wed, 20 Oct 2010 16:26:14 -0400
Message-ID: <3615.1287606374@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

Jeff Davis <pgsql@j-davis.com> writes:
> On Wed, 2010-10-20 at 14:44 -0400, Dimi Paun wrote:
>> 23425 postgres  20   0 22008  10m  10m R 99.9  0.5  21:45.87 postmaster
>> 
>> I'd like to figure out what it is doing. How can I figure out what
>> statement causes the problem? 

> It seems strange that the postmaster is eating 99% cpu. Is there a
> chance that it's flooded with connection attempts?

It's probably a backend process, not the postmaster --- I suspect the
OP is using a version of ps that only tells you the original process
name by default.  "ps auxww" or "ps -ef" (depending on platform)
is likely to be more informative.  Looking into pg_stat_activity,
even more so.

			regards, tom lane