Re: explain

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:
> 
> 
> Roberto Mello wrote:
> 
> >On Fri, Mar 21, 2003 at 07:46:01AM +0200, Popeanga Marian wrote:
> >  
> >
> >>Hello all,
> >>
> >>
> >>           Can someone point me how can i make explain plan for a query?
> >>    
> >>
> >
> >explain select blah from foo where bar = baz;
> >
> >\h explain
> >
> >Look at the PostgreSQL documentation (SQL Reference).
> >
> >-Roberto
> >
> >  
> >
>    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
> 
> 
> 

-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.