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

Re: Explain Analyse never returns .. maybe a bug

From: "Sean Davis" <sdavis2(at)mail(dot)nih(dot)gov>
To: "David Gagnon" <dgagnon(at)siunik(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Explain Analyse never returns .. maybe a bug
Date: 2005-06-29 13:38:36
Message-ID: 002b01c57caf$d9fcedc0$5179f345@WATSON (view raw or flat)
Thread:
Lists: pgsql-general
----- 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



In response to

Responses

pgsql-general by date

Next:From: Douglas McNaughtDate: 2005-06-29 13:43:23
Subject: Re: PostgreSQL's vacuumdb fails to allocate memory for non-root users
Previous:From: Michael FuhrDate: 2005-06-29 13:36:29
Subject: Re: 8.1 Out parameter question

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