Re: Explain Analyse never returns .. maybe a bug - Mailing list pgsql-general

From David Gagnon
Subject Re: Explain Analyse never returns .. maybe a bug
Date
Msg-id 42C3FA5C.3040400@siunik.com
Whole thread Raw
In response to Re: Explain Analyse never returns .. maybe a bug  ("Sean Davis" <sdavis2@mail.nih.gov>)
List pgsql-general
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@siunik.com>
> Cc: <pgsql-general@postgresql.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
>
>
>


pgsql-general by date:

Previous
From: Jason Tesser
Date:
Subject: Re: Possible move away from PG
Next
From: Tom Lane
Date:
Subject: Re: COnsidering a move away from Postgres