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