Measuring CPU time use? (Another stupid question) - Mailing list pgsql-general

From Jessica Blank
Subject Measuring CPU time use? (Another stupid question)
Date
Msg-id Pine.LNX.4.44.0212181306360.392-100000@ensim.rackshack.net
Whole thread Raw
Responses Re: Measuring CPU time use? (Another stupid question)  (Joe Conway <mail@joeconway.com>)
Re: Measuring CPU time use? (Another stupid question)  ("scott.marlowe" <scott.marlowe@ihs.com>)
List 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


pgsql-general by date:

Previous
From: Jessica Blank
Date:
Subject: Re: ERROR: fmgr_info: function 24809: cache lookup failed
Next
From: Alvaro Herrera
Date:
Subject: Re: ORDER BY random() LIMIT 1 slowness