Thread

Re: [HACKERS] Execution time

Mattias Kregert <matti@algonet.se> — 1998-03-06T10:47:23Z

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 */