Measuring CPU time use? (Another stupid question)

From: Jessica Blank <jb(at)twu(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Measuring CPU time use? (Another stupid question)
Date: 2002-12-18 20:08:18
Message-ID: Pine.LNX.4.44.0212181306360.392-100000@ensim.rackshack.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.. again, I feel stupid. But I Googled for this info, and could not find
it (and I call myself the Goddess of Google, and with good reason...)

I wish to find a way to measure the CPU time used by any given query (or
set of queries).

I could not find any information on how to do this...

Is there some secret internal table (like the V$ virtual tables in Oracle)
that contains this info?

I'd love to find a V$CPUTIME table or something, so I could best optimize
my SQL...

I don't want to have to do it the inefficient way... e.g. by running the
same group of queries 1000 times or so several times, and averaging the
times...

--
J e s s i c a L e a h B l a n k

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-12-18 20:10:17 Re: Measuring CPU time use? (Another stupid question)
Previous Message Jessica Blank 2002-12-18 20:06:35 Re: ERROR: fmgr_info: function 24809: cache lookup failed