X-Original-To: pgsql-sql@postgresql.org
Received: from trade-india.com (ns5.trade-india.com [66.234.10.13])
	by postgresql.org (Postfix) with SMTP id 518C847580B
	for <pgsql-sql@postgresql.org>; Fri, 21 Mar 2003 03:23:24 -0500 (EST)
Received: (qmail 10128 invoked by uid 505); 21 Mar 2003 08:23:10 -0000
Received: from mallah@trade-india.com by ns5.trade-india.com by uid 502 with
	qmail-scanner-1.15 (uvscan: v4.1.60/v4171.  Clear:.
	Processed in 1.721152 secs); 21 Mar 2003 08:23:10 -0000
Received: from mail-relay.trade-india.com (HELO
	system67.trade-india-local.com) (203.196.129.235)
	by ns5.trade-india.com with SMTP; 21 Mar 2003 08:23:08 -0000
From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: Popeanga Marian <pmarian@cnlo.ro>,
	Roberto Mello <rmello@cc.usu.edu>
Subject: Re: explain
Date: Fri, 21 Mar 2003 13:53:17 +0530
User-Agent: KMail/1.5
Cc: pgsql-sql@postgresql.org
References: <3E7AA719.2090507@cnlo.ro> <20030321063435.GA6863@cc.usu.edu>
	<3E7AAF87.4070007@cnlo.ro>
In-Reply-To: <3E7AAF87.4070007@cnlo.ro>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200303211353.17208.mallah@trade-india.com>
X-Archive-Number: 200303/487
X-Sequence-Number: 12526




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.