Re: [PERFORM] Large time difference between explain analyze and normal run

2005-02-10 Thread Tom Lane
Chris Kratz [EMAIL PROTECTED] writes: Does anyone have any idea why there be over a 4s difference between running the statement directly and using explain analyze? Aggregate (cost=9848.12..9848.12 rows=1 width=0) (actual time=4841.231..4841.235 rows=1 loops=1) - Seq Scan on answer

Re: [PERFORM] Large time difference between explain analyze and normal run

2005-02-10 Thread Chris Kratz
On Thursday 10 February 2005 01:58 pm, Tom Lane wrote: Chris Kratz [EMAIL PROTECTED] writes: Does anyone have any idea why there be over a 4s difference between running the statement directly and using explain analyze? Aggregate (cost=9848.12..9848.12 rows=1 width=0) (actual