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 35BF2474E44
	for <pgsql-sql@postgresql.org>; Fri, 21 Mar 2003 06:03:10 -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 h2LB1NnJ004195;
	Fri, 21 Mar 2003 13:01:23 +0200
Message-ID: <3E7AF0CD.10103@cnlo.ro>
Date: Fri, 21 Mar 2003 13:00:29 +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: Popeanga Marian <pmarian@cnlo.ro>
Cc: Rajesh Kumar Mallah <mallah@trade-india.com>,
	Roberto Mello <rmello@cc.usu.edu>, pgsql-sql@postgresql.org
Subject: Re: explain
References: <3E7AA719.2090507@cnlo.ro> <20030321063435.GA6863@cc.usu.edu>
	<3E7AAF87.4070007@cnlo.ro>
	<200303211353.17208.mallah@trade-india.com>
	<3E7ACD00.6050702@cnlo.ro>
Content-Type: multipart/alternative;
	boundary="------------060907080602080403090908"
X-RAVMilter-Version: 8.4.1(snapshot 20020919) (ns.cnlo.ro)
X-Archive-Number: 200303/492
X-Sequence-Number: 12531

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



Popeanga Marian wrote:

> Thanks for your repply.
>
>         This is what i expected too.  Can you point me from where i 
> can get this result ?
>
> explain select * from pg_tables where tablename=:tab;
>
>
> select * from ... ?
>
>
>
> In Oracle i will do:
> explain plan set statement_id=uniq_id_for_select for  
>                 select * from dba_tables where table_name=:tab
>
> SELECT * FROM plan_table WHERE Statement_ID = this_uniq_id_for_select;
>
>
>
I need this at programming level, not from within pgsql tool.
I tryed directly with explain select ... but it doesn't retrive any tuples!

>
> Rajesh Kumar Mallah wrote:
>
>>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
>>>
>>>
>>>
>>>    
>>>
>>
>>  
>>
>
>-- 
>Popeanga Marian
>DBA Oracle
>CNLO Romania
>  
>
>

-- 
Popeanga Marian
DBA Oracle
CNLO Romania



--------------060907080602080403090908
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>
Popeanga Marian wrote:<br>
<blockquote type="cite" cite="mid3E7ACD00.6050702@cnlo.ro">
  <title></title>
       Thanks for your repply.<br>
 <br>
 &nbsp; &nbsp; &nbsp; &nbsp; This is what i expected too. &nbsp;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 &nbsp; <br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 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>
 </blockquote>
I need this at programming level, not from within pgsql tool.<br>
I tryed directly with explain select ... but it doesn't retrive any tuples!<br>
<br>
<blockquote type="cite" cite="mid3E7ACD00.6050702@cnlo.ro"><br>
 Rajesh Kumar Mallah wrote:<br>
 
  <blockquote type="cite"
 cite="mid200303211353.17208.mallah@trade-india.com">   
    <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>
</body>
</html>

--------------060907080602080403090908--