> 1. The manual says about "explain analyze" : "The ANALYZE option causes the
> statement to be actually executed, not only planned. The total elapsed time
> expended within each plan node (in milliseconds) and total number of rows
> it actually returned are added to the display." Does this time include
> datatransfer or just the time the database needs to collect the data,
> without any data transfer? 

Correct.  It's strictly backend time.

> 2. If the time is without data transfer to the 
> client, is there a reliable way to measure the time needed to run the query
> and get the data (without the overhead of a program that does something
> with the data)?

in PSQL, you can use \timing


Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to