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>
index | next in thread | previous in thread | raw e-mail
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"? -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Companyhelp
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?1364943147.84745.YahooMailNeo>