From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Dimi Paun <dimi@lattica.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: What is postmaster doing?
Date: Wed, 20 Oct 2010 16:26:14 -0400
Message-ID: <3615.1287606374@sss.pgh.pa.us> (raw)
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql@j-davis.com, dimi@lattica.com
Subject: Re: What is postmaster doing?
In-Reply-To: <3615.1287606374@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox