Re: Postmaster taking 100% of the CPU

From: Vick Khera <vivek(at)khera(dot)org>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postmaster taking 100% of the CPU
Date: 2009-10-26 19:47:07
Message-ID: 2968dfd60910261247p353dbfb2k7c89e9bcb6e62f14@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Oct 26, 2009 at 1:30 PM, David Kerr <dmk(at)mr-paradox(dot)net> wrote:
> Postmaster's been spinning at 99/100% for a few hours.
>

What does "select * from pg_stat_activity" show you? Look for your
long(est) running query.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2009-10-26 19:48:21 Re: joining an array with a table or...?
Previous Message Peter Geoghegan 2009-10-26 19:44:38 Re: [GENERAL] [ANNOUNCE] PGDay.EU 2009 - approaching fast!