From owner-freebsd-database@FreeBSD.ORG Tue Apr 2 22:52:29 2013 Return-Path: Delivered-To: freebsd-database@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by hub.freebsd.org (Postfix) with ESMTP id 19196EFA for ; Tue, 2 Apr 2013 22:52:29 +0000 (UTC) (envelope-from kgrittn@ymail.com) Received: from nm3-vm0.bullet.mail.bf1.yahoo.com (nm3-vm0.bullet.mail.bf1.yahoo.com [98.139.212.154]) by mx1.freebsd.org (Postfix) with SMTP id 93035179 for ; Tue, 2 Apr 2013 22:52:28 +0000 (UTC) Received: from [98.139.212.151] by nm3.bullet.mail.bf1.yahoo.com with NNFMP; 02 Apr 2013 22:52:27 -0000 Received: from [98.139.215.249] by tm8.bullet.mail.bf1.yahoo.com with NNFMP; 02 Apr 2013 22:52:27 -0000 Received: from [127.0.0.1] by omp1062.mail.bf1.yahoo.com with NNFMP; 02 Apr 2013 22:52:27 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 681231.22617.bm@omp1062.mail.bf1.yahoo.com Received: (qmail 58518 invoked by uid 60001); 2 Apr 2013 22:52:27 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1364943147; bh=BhDCiVK0q471b6vDd2T4gkCAQEV7FeQPACeatY+8d1E=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=kVGWptOxW0O2F92aVenqy6p21n7dxpobZfkpUI0XIAW3Od4xfeDDf3mV9X/axGPepiXv9UiNFIin8XLzXz1v4pFBnpPO42/Hopu/V9wIF2ciJLfgW4PEjIhS5IHsOTY8QwK3P2anOE/67iBuUz7OSMNqdFAncq5mEfr8jmK3jWo= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=hVKdWPUGbjcl/Yq52HIXmAhFkzv02ByikcPajVwuxmr76ooL6lSmJXFrN0Ldb2QHREmursY5+QwjoXQJHEGiquJ5/nbktTgppar2bv+iNSd7Xe/J01zurthLGZjw/qCOTXaqpOd8FAgFb4iNYK7vQzfpf1TBYflpdpfalDQb0N8=; X-YMail-OSG: WuhIPpsVM1lrexzIqlSOjwGc0KTkZ1iZIX1fbP19yl8lqdA 8tRvTR7UnKwy3yA7YPnCRUQEGe58DLam9lh0qULj4LsbHNvGmL_Wt6km.Jw. N13gDdd4BMPH62rgFqMXq7sEMjWhtpYCAx4nutKc5s3mRy2DLeWMAimbsz6I 4GGZNbe9h2f8vS6X7_l8hUDXFDM3rMnmI1_nlSmvqF5bxy0VN85J9TJ7wtu6 eO23IorwTcZZQJUOVQxYs67ipnwSaLtY0qMeHPQJtWq3p7VcGGLvOGc9GQEL nFkDqKneHPTodNiIEShMW9mtERRc4Lnl5U0WTLW1pIbo83_gC0gTBYKBsxLQ NVyf8Usp92BnZfTx5YtdyXSR70fH3WGQBi9D5PvMun0CGA9dfpL79RdgEtMw HTawz_Hbbqae105NwZWFzcMwbzG3x4D1._t.VB_x7VNXaFCqB3nC_r8w9NG_ YEpOOTSsAH_uRK82Doy9RAl7vYhSrAP0CwvAHoapjWebHBYUgE1DfLnj4D_Q DwMM6XtTWpHO9Yf3Q7jMo8WVY_heMMwTUqnjNk38- Received: from [76.255.18.237] by web162902.mail.bf1.yahoo.com via HTTP; Tue, 02 Apr 2013 15:52:27 PDT X-Rocket-MIMEInfo: 002.001, RGF2aWQgTm9lbCA8ZGF2aWQuaS5ub2VsQGdtYWlsLmNvbT4gd3JvdGU6Cgo.ICdzZWxlY3QgKiBmcm9tIHBnX3N0YXRfYWN0aXZpdHknIHNob3dzIHRoYXQgdGhlIHF1ZXJpZXMgYXJlIG5vdAo.IHdhaXRpbmcsIGFuZCBhcmUgaW4gdGhlIGlkbGUgc3RhdGUuCgpUaGUgcHJvY2VzcyBpcyBpZGxlIG9yIHRoZSBwcm9jZXNzIGlzIHJ1bm5pbmcgdGhlIHF1ZXJ5P8KgIElmIHRoZQpsYXR0ZXIsIHdoYXQgZG8geW91IG1lYW4gd2hlbiB5b3Ugc2F5ICJ0aGUgcXVlcmllcyAuLi4gYXJlIGluIHRoZQppZGxlIHN0YXQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.140.532 References: Message-ID: <1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com> Date: Tue, 2 Apr 2013 15:52:27 -0700 (PDT) From: Kevin Grittner Subject: Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100% To: "David.I.Noel@gmail.com" , PGSQL Mailing List , "freebsd-database@freebsd.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.14 Precedence: list Reply-To: Kevin Grittner List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 02 Apr 2013 22:52:29 -0000 David Noel wrote:=0A=0A> 'select * from pg_stat_ac= tivity' shows that the queries are not=0A> waiting, and are in the idle sta= te.=0A=0AThe process is idle or the process is running the query?=A0 If the= =0Alatter, what do you mean when you say "the queries ... are in the=0Aidle= state"?=0A=0A--=0AKevin Grittner=0AEnterpriseDB: http://www.enterprisedb.c= om=0AThe Enterprise PostgreSQL Company