Search Postgresql Archives

Re: Explain Analyse never returns .. maybe a bug

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




----- Original Message ----- From: "David Gagnon" <dgagnon@xxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, June 29, 2005 9:25 AM
Subject:  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 5: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux