<br /><br /> Roberto Mello wrote:<br /><blockquote cite="mid20030321063435.GA6863@cc.usu.edu" type="cite"><pre
wrap="">OnFri, Mar 21, 2003 at 07:46:01AM +0200, Popeanga Marian wrote: </pre><blockquote type="cite"><pre
wrap="">Helloall,
Can someone point me how can i make explain plan for a query? </pre></blockquote><pre wrap="">
explain select blah from foo where bar = baz;
\h explain
Look at the PostgreSQL documentation (SQL Reference).
-Roberto
</pre></blockquote> I have look at this command. I want to know how can i make this from other tool than pgsql.<br
/>In oracle when i issue an explain plan the explain insert values into a table ( plan_table ).<br /> Then i could
selectthe values from plan_table. Is there similar in postgres ?<br /><br /><pre class="moz-signature"
cols="$mailwrapcol">--
Popeanga Marian
DBA Oracle
CNLO Romania
</pre><br />