Re: Measuring server performance with psql and pgAdmin

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