Re: CPU Usage

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: CPU Usage
Date: 2004-02-09 19:10:32
Message-ID: m34qu0ax1z.fsf@wolfe.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Quoth mark(dot)cubitt(at)applegate(dot)co(dot)uk ("Mark Cubitt"):
> is there a way of finding out which table is using a certain amount of CPU
> power?

That doesn't entirely make sense.

Tables normally use up disk space.

What consumes CPU power is the computation of queries, and, for big,
expensive queries, it is pretty common for there to be several tables
involved.

Could you describe the problem you are trying to solve, and try to
_avoid_ framing it in terms of how it might be answered?
--
(reverse (concatenate 'string "gro.gultn" "@" "enworbbc"))
http://www.ntlug.org/~cbbrowne/lsf.html
"Applicants must have *at least* five years experience with Windows
XCVIII..."

In response to

  • CPU Usage at 2004-02-09 16:24:21 from Mark Cubitt

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2004-02-09 19:23:00 Re: Increasing Max Connections Mac OS 10.3
Previous Message Christopher Browne 2004-02-09 19:06:18 Re: Oracle SQLNet on same server as Postgres