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