From owner-freebsd-database@FreeBSD.ORG Wed Apr 3 15:25:54 2013 Return-Path: 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 5D409B41 for ; Wed, 3 Apr 2013 15:25:54 +0000 (UTC) (envelope-from kgrittn@ymail.com) Received: from nm17-vm0.bullet.mail.bf1.yahoo.com (nm17-vm0.bullet.mail.bf1.yahoo.com [98.139.213.157]) by mx1.freebsd.org (Postfix) with SMTP id E7561954 for ; Wed, 3 Apr 2013 15:25:53 +0000 (UTC) Received: from [98.139.212.144] by nm17.bullet.mail.bf1.yahoo.com with NNFMP; 03 Apr 2013 15:25:53 -0000 Received: from [98.139.212.247] by tm1.bullet.mail.bf1.yahoo.com with NNFMP; 03 Apr 2013 15:25:53 -0000 Received: from [127.0.0.1] by omp1056.mail.bf1.yahoo.com with NNFMP; 03 Apr 2013 15:25:53 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 107608.5824.bm@omp1056.mail.bf1.yahoo.com Received: (qmail 46056 invoked by uid 60001); 3 Apr 2013 15:25:53 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s1024; t=1365002753; bh=k2gVhcVf1fZoplmFfgnhKDdCbZGq/gsPcUgcE7UINQc=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=JFFgkoilwz0PWhtGCdVCwsjNotam6oOlaGzwy/b8/xhBM5ElEvTMj83yeKRi6FTTnqolYzxy+NVIhZWSrjEr4rxBZvcy0ptX+phj3C1pmMmNB7kZuR9cPkYVFGQATr5sibOzrUmHxzNxwKv6gg/6d+Z+fdoubeylGj/UXcSGESE= 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:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=bjpkAORbMYU8TqyJQTwwlWpcEZFEq0jWFjUp9tMNvasB2T08iX8Yqg4J1nLUoRqiUGWVY51xVhWwfg6wk4wCzpqtyAR9jS5NNoPQJwPsFNIk3SaXDJCW9mY0B5CvjaPq98tQmO3PE0rGDnTVeV6bU1EwQc0s23Brg4Gd/sE1YIM=; X-YMail-OSG: pZL_YfsVM1kO0D6Oq57nzkxampeWC062rB3xlXU6Jnhfs65 _JEOn4j2AH9ToGt3ZmzVAIBp2CLXSrojaa45TEGP4ht96TgTji_aCximdshS 5CmY24TbWKbQowtnmxy4OlctatudqHTnkfNMRYVVCJtl6lVgqx6kkKTWTAuR ZPsniyxtCzo_az453F3xJPKdAL69X4gjfOkCQezO.d8McLf38evr7gMPv2lM XF8IN7ngUZnd_mivyrqBvAYI6CXUx8PlwjCKYYqJzihcZry1bq0zrWRptdwi Iknuo3sV5cwnP4RZFeW6PiJusKwtqtUvcZlYdOfYhvOBU5wLxq58oBzmONno Et77G4Iu0GzdDzvcn0sTfFT5cyU7sjsO08dQ5wXxKpv4Ostwy9hmU1tN88cu n11NpO7ZThP2p05I8H3O_ApvE__xF3nnPtuPUf7aQKNyGXe7Hj8QgJ3z6E3y C6G4VedqEP5PcXK3WUgWLpRM0sm0UtZMdTZzcEgk6BT82nNKicmdQN1AUf48 9e.q3_JM2XegO7v86oyEvix_bfioB.o88kVAzyhs- Received: from [76.255.18.237] by web162905.mail.bf1.yahoo.com via HTTP; Wed, 03 Apr 2013 08:25:52 PDT X-Rocket-MIMEInfo: 002.001, RGF2aWQgTm9lbCA8ZGF2aWQuaS5ub2VsQGdtYWlsLmNvbT4gd3JvdGU6Cj4gT24gNC8yLzEzLCBLZXZpbiBHcml0dG5lciA8a2dyaXR0bkB5bWFpbC5jb20.IHdyb3RlOgo.PiBEYXZpZCBOb2VsIDxkYXZpZC5pLm5vZWxAZ21haWwuY29tPiB3cm90ZToKPj4KPj4.ICdzZWxlY3QgKiBmcm9tIHBnX3N0YXRfYWN0aXZpdHknIHNob3dzIHRoYXQgdGhlIHF1ZXJpZXMgYXJlIG5vdAo.Pj4gd2FpdGluZywgYW5kIGFyZSBpbiB0aGUgaWRsZSBzdGF0ZS4KPj4KPj4gVGhlIHByb2Nlc3MgaXMgaWRsZSBvciB0aGUgcHIBMAEBAQE- X-Mailer: YahooMailWebService/0.8.140.532 References: <1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com> Message-ID: <1365002752.81518.YahooMailNeo@web162905.mail.bf1.yahoo.com> Date: Wed, 3 Apr 2013 08:25:52 -0700 (PDT) From: Kevin Grittner Subject: Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100% To: "David.I.Noel@gmail.com" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Cc: "freebsd-database@freebsd.org" , PGSQL Mailing List 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: Wed, 03 Apr 2013 15:25:54 -0000 David Noel wrote:=0A> On 4/2/13, Kevin Grittner wrote:=0A>> David Noel wrote:=0A= >>=0A>>> 'select * from pg_stat_activity' shows that the queries are not=0A= >>> waiting, and are in the idle state.=0A>>=0A>> The process is idle or th= e process is running the query?=A0 If the=0A>> latter, what do you mean whe= n you say "the queries ... are in the=0A>> idle state"?=0A>=0A> select * fr= om pg_stat_activity returns a table containing a column=0A> labeled "state"= . When the postgres process is at 100% utilization and=0A> the application = has hung, this query returns the value "idle" in that=0A> field. When thing= s are running properly, as they are for the moment=0A> now, the value is "a= ctive".=0A=0AWhen a connection shows "idle", the related process should be= =0Ashowing zero CPU usage.=A0 Are you seeing something different?=A0 If=0As= o, is the transaction or query start time changing from one sample=0Ato the= next?=0A=0A--=0AKevin Grittner=0AEnterpriseDB: http://www.enterprisedb.com= =0AThe Enterprise PostgreSQL Company