Date: Wed, 3 Apr 2013 08:25:52 -0700 (PDT) From: Kevin Grittner <kgrittn@ymail.com> To: "David.I.Noel@gmail.com" <David.I.Noel@gmail.com> Cc: "freebsd-database@freebsd.org" <freebsd-database@freebsd.org>, PGSQL Mailing List <pgsql-general@postgresql.org> Subject: Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100% Message-ID: <1365002752.81518.YahooMailNeo@web162905.mail.bf1.yahoo.com> In-Reply-To: <CAHAXwYAZaXBCJB_5=DvK2%2BtgPfQZj5YMPoUU_o570baivutMnw@mail.gmail.com> References: <CAHAXwYDg7ijxaG8K8vHMQci552txe94U4KKKJ4cZbUHT5UGXcQ@mail.gmail.com> <1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com> <CAHAXwYAZaXBCJB_5=DvK2%2BtgPfQZj5YMPoUU_o570baivutMnw@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
David Noel <david.i.noel@gmail.com> wrote:=0A> On 4/2/13, Kevin Grittner <k= grittn@ymail.com> wrote:=0A>> David Noel <david.i.noel@gmail.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1365002752.81518.YahooMailNeo>