Thanky thanky. That might work.
Still, I'd rather just have a way I could get a plain old figure.
E.g.:
DELETE FROM V$CPUUSE;
(DO THE QUERIES IN QUESTION HERE)
SELECT NANOSECONDS_USED FROM V$CPUUSE;
On Wed, 18 Dec 2002, Joe Conway wrote:
> Jessica Blank wrote:
> > 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?
>
> Well, I don't know of anything specific to CPU usage, but for monitoring your
> server see Monitoring Database Activity in the manual:
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/monitoring.html
>
> Also, one of the best and most commonly used tools for optimizing individual
> queries is EXPLAIN ANALYZE; see:
> http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/sql-explain.html
>
> HTH,
>
> Joe
>
--
J e s s i c a L e a h B l a n k