Re: Explain Analyse never returns .. maybe a bug

Oups ! Sorry I misunderstanding the command .. always thought it was
almos instantaneous.... my mistake.. really sorry about that

Thanks :-)

/David

Sean Davis wrote:

>
> ----- Original Message ----- From: "David Gagnon" <dgagnon(at)siunik(dot)com>
> Cc: <pgsql-general(at)postgresql(dot)org>
> Sent: Wednesday, June 29, 2005 9:25 AM
> Subject: [GENERAL] Explain Analyse never returns .. maybe a bug
>
>
>> Hi all,
>>
>> I stop the following statement after 3 minutes....
>>
>> explain analyse select *
>> From IC
>> where IC.ICNUM NOT IN (select IRICNUM from IR WHERE IRSTATUT
>> in (1, 2))
>>
>>
>> I'm using 8.0.3 on windows.
>> Is that a know bug ?
>
>
> David,
>
> Remember that EXPLAIN ANALYZE actually RUNS the query. It may
> actually be taking 3+ minutes to run the query. How large are the
> tables? What does EXPLAIN (without ANALYZE) say? Have you run the
> query without EXPLAIN ANALYZE to know how long it normally takes--what
> is the basis for suggesting that 3 minutes is "too long"?
>
> Sean
>
>
>