Joost,
> 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
Josh Berkus
Aglio Database Solutions
San Francisco
