Re: explain - Mailing list pgsql-sql

<br /><br /> Popeanga Marian wrote:<br /><blockquote cite="mid3E7ACD00.6050702@cnlo.ro" type="cite"></blockquote>
Thanksfor your repply.<br /><br />         This is what i expected too.  Can you point me from where i can get this
result?<br /><br /> explain select * from pg_tables where tablename=:tab;<br /><br /><br /> select * from ... ?<br
/><br/><br /><br /> In Oracle i will do:<br /> explain plan set statement_id=uniq_id_for_select for   <br />          
     select * from dba_tables where table_name=:tab<br /><br /> SELECT * FROM plan_table WHERE Statement_ID =
this_uniq_id_for_select;<br/><br /><br /><br />  I need this at programming level, not from within pgsql tool.<br /> I
tryeddirectly with explain select ... but it doesn't retrive any tuples!<br /><br /><blockquote
cite="mid3E7ACD00.6050702@cnlo.ro"type="cite"><br /> Rajesh Kumar Mallah wrote:<br /><blockquote
cite="mid200303211353.17208.mallah@trade-india.com"type="cite"><pre wrap="">
 
Dear Marian,

in postgresql 7.3 explain commands retruns as
set of rows.

The result of EXPLAIN can just be fecthed as result
of any other SELECT query and manipulated further.

i hope it helps.

sorry if i did not get ur problem rite.


regds
mallah.




On Friday 21 Mar 2003 11:51 am, Popeanga Marian wrote: </pre><blockquote type="cite"><pre wrap="">Roberto Mello wrote:
   </pre><blockquote type="cite"><pre wrap="">On Fri, Mar 21, 2003 at 07:46:01AM +0200, Popeanga Marian wrote:
     </pre><blockquote type="cite"><pre wrap="">Hello all,

         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><pre wrap="">   I have look at this command. I want to know how can i make this from 
other tool than pgsql.
In oracle when i issue an explain plan the explain insert values into a 
table ( plan_table ).
Then i could select the values from plan_table.         Is there similar 
in postgres ?

-- 
Popeanga Marian
DBA Oracle
CNLO Romania


   </pre></blockquote><pre wrap=""> </pre></blockquote><br /><pre class="moz-signature" cols="$mailwrapcol">-- 
Popeanga Marian
DBA Oracle
CNLO Romania </pre><br /></blockquote><br /><pre class="moz-signature" cols="$mailwrapcol">-- 
Popeanga Marian
DBA Oracle
CNLO Romania
</pre><br />