Re: [HACKERS] Execution time

Mattias Kregert <matti@algonet.se>

From: Mattias Kregert <matti@algonet.se>
To: Shiby Thomas <sthomas@cise.ufl.edu>
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-03-06T10:47:23Z
Lists: pgsql-hackers
Shiby Thomas wrote:
> 
> Hi,
> 
> In postgres, is there a way to get the CPU time and I/O time taken (separately)
> to execute a query? Does the profile info. help in some way to
> calculate the CPU/IO break up at least approximately.
> 
> What is the best way to do it? Any kind of help is greatly appreciated.
> 
> Thanks
> --shiby

How about running "time postgres ..." and connecting to the backend
without using the postmaster?

/* m */