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