Re: [GENERAL] PostgreSQL: CPU utilization creeping to 100%
Kevin Grittner <[email protected]> Wed, 3 Apr 2013 08:25:52 -0700 (PDT)
| Newsgroups | gmane.os.freebsd.devel.database,gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
David Noel <[email protected]> wrote: > On 4/2/13, Kevin Grittner <[email protected]> wrote: >> David Noel <[email protected]> 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? -- Kevin Grittner EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company _______________________________________________ [email protected] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-database To unsubscribe, send any mail to "[email protected]"