Why does explain differ from explan analyze?
От
Joost Kraaijeveld
Тема
Why does explain differ from explan analyze?
Дата
Msg-id
1165423096.16324.3.camel@panoramix
Список
Дерево обсуждения
Why does explain differ from explan analyze? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Re: Why does explain differ from explan analyze? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why does explain differ from explan analyze? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
Re: Why does explain differ from explan analyze? Tom Lane <tgl@sss.pgh.pa.us>
Re: Why does explain differ from explan analyze? Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
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 по дате отправления
