Re: Explain Analyse never returns .. maybe a bug

On Wed, Jun 29, 2005 at 09:25:24AM -0400, David Gagnon wrote:
>
>  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))

What does EXPLAIN without ANALYZE show?  What are the table definitions
and what are the results of the following queries?

SELECT COUNT(*) FROM IC;
SELECT COUNT(*) FROM IR;
SELECT COUNT(*) FROM IR WHERE IRSTATUT IN (1, 2);
SELECT COUNT(DISTINCT IRICNUM) FROM IR WHERE IRSTATUT IN (1, 2);

Have you run VACUUM ANALYZE on the tables?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/