Jim C. Nasby wrote:
> Hrm... I was about to suggest that for timing just the query (and not
> output/data transfer time) using explain analyze, but then I remembered
> that explain analyze can incur some non-trivial overhead with the timing
> calls. Is there a way to run the query but have psql ignore the output?
> If so, you could use \timing.
Would timing "SELECT COUNT(*) FROM (query)" work?
Kevin Brown kevin(at)sysexperts(dot)com
In response to
pgsql-performance by date
|Next:||From: Greg Stark||Date: 2005-04-23 08:02:05|
|Subject: Re: Bad n_distinct estimation; hacks suggested?|
|Previous:||From: Tom Lane||Date: 2005-04-23 05:00:40|
|Subject: Re: Sort and index |