> 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
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Jaime Casanova||Date: 2004-10-26 20:19:06|
|Subject: Re: Sequential Scan with LIMIT|
|Previous:||From: Matt Clark||Date: 2004-10-26 18:28:34|
|Subject: Re: can't handle large number of INSERT/UPDATEs|