[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Explain Analyse never returns .. maybe a bug
From:       David Gagnon <dgagnon () siunik ! com>
Date:       2005-06-30 13:57:48
Message-ID: 42C3FA5C.3040400 () siunik ! com
[Download RAW message or body]

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
>
>
>


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]