| 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: | Whole Thread | Raw Message | 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
| 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 |