Skip site navigation (1) Skip section navigation (2)

Re: Joel's Performance Issues WAS : Opteron vs Xeon

From: Kevin Brown <kevin(at)sysexperts(dot)com>
To: 'Postgresql Performance' <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Date: 2005-04-23 06:30:45
Message-ID: 20050423063044.GI19518@filer (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Greg StarkDate: 2005-04-23 08:02:05
Subject: Re: Bad n_distinct estimation; hacks suggested?
Previous:From: Tom LaneDate: 2005-04-23 05:00:40
Subject: Re: Sort and index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group