From owner-freebsd-database@FreeBSD.ORG  Tue Apr  2 23:08:36 2013
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.freebsd.org (mx1.FreeBSD.org [8.8.178.115])
 by hub.freebsd.org (Postfix) with ESMTP id D4317316
 for <freebsd-database@freebsd.org>; Tue,  2 Apr 2013 23:08:36 +0000 (UTC)
 (envelope-from david.i.noel@gmail.com)
Received: from mail-pa0-f43.google.com (mail-pa0-f43.google.com
 [209.85.220.43]) by mx1.freebsd.org (Postfix) with ESMTP id B3E20263
 for <freebsd-database@freebsd.org>; Tue,  2 Apr 2013 23:08:36 +0000 (UTC)
Received: by mail-pa0-f43.google.com with SMTP id hz11so552178pad.2
 for <freebsd-database@freebsd.org>; Tue, 02 Apr 2013 16:08:36 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:x-received:reply-to:in-reply-to:references:date
 :message-id:subject:from:to:cc:content-type;
 bh=wkWmoJgjbG0KUnQyfGj3/b23NC66QCIqALCcfaem6mo=;
 b=Fn5qOzlyyDc5XfhQLXuOHj1Ld3hklYyq57yCO2dQDXxzjbRTa1+U0i0Mp0Z/hNKtsl
 NFFF2MBMmr9dWvzYJa3QyKjZnHozGUL0rxxRWMUi+ChvOropa7yTsbTSICttjzJxbT0a
 2uCuTf20JOttJKYgdW5MuMAmFR9+8CVFYizYozSb4D5AJQssbijJ/8aPpLbIAwRx9YkK
 TLJEe3MdaDIE1qpLrZroDXTv5bIjqf6leVixs4zfg+/6Rnkrip8NahT89IIStINeKYch
 9ewG3FADw5OwQjtZzVTopD5iSQMD+giyscEVZE/BVEmYah3Y/XfWlHUIMlASwXJxP0Fe
 cmlg==
MIME-Version: 1.0
X-Received: by 10.68.228.164 with SMTP id sj4mr26437560pbc.180.1364944116479; 
 Tue, 02 Apr 2013 16:08:36 -0700 (PDT)
Received: by 10.68.90.100 with HTTP; Tue, 2 Apr 2013 16:08:36 -0700 (PDT)
In-Reply-To: <1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com>
References: <CAHAXwYDg7ijxaG8K8vHMQci552txe94U4KKKJ4cZbUHT5UGXcQ@mail.gmail.com>
 <1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com>
Date: Tue, 2 Apr 2013 18:08:36 -0500
Message-ID: <CAHAXwYAZaXBCJB_5=DvK2+tgPfQZj5YMPoUU_o570baivutMnw@mail.gmail.com>
Subject: Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100%
From: David Noel <david.i.noel@gmail.com>
To: Kevin Grittner <kgrittn@ymail.com>
Content-Type: text/plain; charset=ISO-8859-1
Cc: "freebsd-database@freebsd.org" <freebsd-database@freebsd.org>,
 PGSQL Mailing List <pgsql-general@postgresql.org>
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
Reply-To: David.I.Noel@gmail.com
List-Id: Database use and development under FreeBSD
 <freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-database>, 
 <mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
 <mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 02 Apr 2013 23:08:36 -0000

On 4/2/13, Kevin Grittner <kgrittn@ymail.com> wrote:
> David Noel <david.i.noel@gmail.com> wrote:
>
>> 'select * from pg_stat_activity' shows that the queries are not
>> waiting, and are in the idle state.
>
> The process is idle or the process is running the query?  If the
> latter, what do you mean when you say "the queries ... are in the
> idle state"?

select * from pg_stat_activity returns a table containing a column
labeled "state". When the postgres process is at 100% utilization and
the application has hung, this query returns the value "idle" in that
field. When things are running properly, as they are for the moment
now, the value is "active".