Re: Explain Analyse never returns .. maybe a bug

David Gagnon <dgagnon@siunik.com> writes:

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

Post your schema, and the sizes of the tables in question.

Also, a regular EXPLAIN (without ANALYZE) should print the query
plan that PG has chosen--post that too.

-Doug