Explain analyze time

From: Tourtounis Sotiris <tourtoun(at)csd(dot)uoc(dot)gr>
To: pgsql-general(at)postgresql(dot)org
Subject: Explain analyze time
Date: 2002-09-23 16:17:51
Message-ID: Pine.GSO.4.44.0209231915110.21676-100000@fryni.csd.uch.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to askk you a misunderstand that i have conscrning to PostgreSQL's
docs. You can measure an SQL query how much time it takes with the same
result with or without the explain analyze before selct ? If times differ
can somone explain me why?

SWTHRHS TOYRTOYNHS
(tourtoun(at)csd(dot)uch(dot)gr)

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Lebedev 2002-09-23 16:34:43 Re: DBLink: interesting issue
Previous Message Michael Paesold 2002-09-23 16:03:54 Getting current transaction id