X-Original-To: pgsql-sql@postgresql.org
Received: from ns.cnlo.ro (cnlo.ro [193.231.112.154])
	by postgresql.org (Postfix) with ESMTP id 67D7E475D91
	for <pgsql-sql@postgresql.org>; Fri, 21 Mar 2003 01:24:25 -0500 (EST)
Received: from cnlo.ro (marian.cnlo.ro [192.168.10.64])
	by ns.cnlo.ro (8.12.8/8.12.5) with ESMTP id h2L6MsnJ028322;
	Fri, 21 Mar 2003 08:22:55 +0200
Message-ID: <3E7AAF87.4070007@cnlo.ro>
Date: Fri, 21 Mar 2003 08:21:59 +0200
From: Popeanga Marian <pmarian@cnlo.ro>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.0.1) Gecko/20020823 Netscape/7.0
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Roberto Mello <rmello@cc.usu.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: explain
References: <3E7AA719.2090507@cnlo.ro> <20030321063435.GA6863@cc.usu.edu>
Content-Type: multipart/alternative;
	boundary="------------060901060903030707070409"
X-RAVMilter-Version: 8.4.1(snapshot 20020919) (ns.cnlo.ro)
X-Archive-Number: 200303/486
X-Sequence-Number: 12525

--------------060901060903030707070409
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit



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



--------------060901060903030707070409
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <title></title>
</head>
<body>
<br>
<br>
Roberto Mello wrote:<br>
<blockquote type="cite" cite="mid20030321063435.GA6863@cc.usu.edu">
  <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>
&nbsp; &nbsp;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 select the values from plan_table. &nbsp; &nbsp; &nbsp; &nbsp; Is there similar
in postgres ?<br>
<br>
<pre class="moz-signature" cols="$mailwrapcol">-- 
Popeanga Marian
DBA Oracle
CNLO Romania
</pre>
<br>
</body>
</html>

--------------060901060903030707070409--