Date: Tue, 2 Apr 2013 18:08:36 -0500 From: David Noel <david.i.noel@gmail.com> To: Kevin Grittner <kgrittn@ymail.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: <CAHAXwYAZaXBCJB_5=DvK2%2BtgPfQZj5YMPoUU_o570baivutMnw@mail.gmail.com> In-Reply-To: <1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com> References: <CAHAXwYDg7ijxaG8K8vHMQci552txe94U4KKKJ4cZbUHT5UGXcQ@mail.gmail.com> <1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 4/2/13, Kevin Grittner <kgrittn@ymail.com> wrote: > 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"? select * from pg_stat_activity returns a table containing a column labeled "state". When the postgres process is at 100% utilization and the application has hung, this query returns the value "idle" in that field. When things are running properly, as they are for the moment now, the value is "active".
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAHAXwYAZaXBCJB_5=DvK2%2BtgPfQZj5YMPoUU_o570baivutMnw>