Postgres Pro
Downloads
Home   >   mailing lists

Why does explain differ from explan analyze? - Mailing list pgsql-general

From Joost Kraaijeveld
Subject Why does explain differ from explan analyze?
Date
Msg-id 1165423096.16324.3.camel@panoramix
Whole thread Raw
Responses Re: Why does explain differ from explan analyze?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
I have a query that if I do "explain" shows an other plan than if I do
"explain analyze" with that same query (immediately after the explain).

Is that possible, and if so, why? Does it have to do something with
vacuum?

TIA

--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web: www.askesis.nl

pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: Error in installing compat-postgresql-libs rpm
Next
From: Scott Marlowe
Date:
Subject: Re: HELP: Urgent, Vacuum problem