Re: [HACKERS] Execution time - Mailing list pgsql-hackers

From Shiby Thomas
Subject Re: [HACKERS] Execution time
Date
Msg-id 199803061702.MAA18841@cise.ufl.edu
Whole thread Raw
In response to Re: [HACKERS] Execution time  (Mattias Kregert <matti@algonet.se>)
List pgsql-hackers
=> How about running "time postgres ..." and connecting to the backend
=> without using the postmaster?
=>
The time command will give the elapsed, user CPU and System CPU times.
How do I interpret it as CPU/IO time ?

Even the -s option of postgres gives those times. Will it be the same as
using "time postgres" ? Is the System time a reasonable approximation of the
I/O time and user time that of CPU time ?

Thanks
--shiby



pgsql-hackers by date:

Previous
From: Andrew Martin
Date:
Subject: pg_dumpall
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] pg_dumpall