Date: Thu, 4 Apr 2013 18:17:37 -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: <CAHAXwYDCpy9WHq0pMrNKKc646Eksq2yhxmjGN20z-p2SuzMFBA@mail.gmail.com> In-Reply-To: <1365002752.81518.YahooMailNeo@web162905.mail.bf1.yahoo.com> References: <CAHAXwYDg7ijxaG8K8vHMQci552txe94U4KKKJ4cZbUHT5UGXcQ@mail.gmail.com> <1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com> <CAHAXwYAZaXBCJB_5=DvK2%2BtgPfQZj5YMPoUU_o570baivutMnw@mail.gmail.com> <1365002752.81518.YahooMailNeo@web162905.mail.bf1.yahoo.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On 4/3/13, Kevin Grittner <kgrittn@ymail.com> wrote: > David Noel <david.i.noel@gmail.com> wrote: >> 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". > > When a connection shows "idle", the related process should be > showing zero CPU usage. Are you seeing something different? If > so, is the transaction or query start time changing from one sample > to the next? The related process was maxed out at or near 100%. I've scanned chapter 18.4 of the documentation and along with some suggested values from a reply earlier have brought things to the point where it *seems* to be stable. I'm continuing to test though, so if the issue pops up again I'll check to see whether the query start time is changing or not. Thanks for the help, -David
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAHAXwYDCpy9WHq0pMrNKKc646Eksq2yhxmjGN20z-p2SuzMFBA>