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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster