Re: PostgreSQL: CPU utilization creeping to 100%

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: "David(dot)I(dot)Noel(at)gmail(dot)com" <David(dot)I(dot)Noel(at)gmail(dot)com>, PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>, "freebsd-database(at)freebsd(dot)org" <freebsd-database(at)freebsd(dot)org>
Subject: Re: PostgreSQL: CPU utilization creeping to 100%
Date: 2013-04-02 22:52:27
Message-ID: 1364943147.84745.YahooMailNeo@web162902.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

David Noel <david(dot)i(dot)noel(at)gmail(dot)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 Company

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-04-02 23:01:45 Re: PostgreSQL: CPU utilization creeping to 100%
Previous Message David Noel 2013-04-02 22:46:48 Re: PostgreSQL: CPU utilization creeping to 100%