Re: explain

<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 />