Re: explain - Mailing list pgsql-sql

From Popeanga Marian
Subject Re: explain
Date
Msg-id 3E7AAF87.4070007@cnlo.ro
Whole thread Raw
In response to explain  (Popeanga Marian <pmarian@cnlo.ro>)
Responses Re: explain
List pgsql-sql
<br /><br /> Roberto Mello wrote:<br /><blockquote cite="mid20030321063435.GA6863@cc.usu.edu" type="cite"><pre
wrap="">OnFri, Mar 21, 2003 at 07:46:01AM +0200, Popeanga Marian wrote: </pre><blockquote type="cite"><pre
wrap="">Helloall,
 

          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>    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
selectthe values from plan_table.         Is there similar in postgres ?<br /><br /><pre class="moz-signature"
cols="$mailwrapcol">--
 
Popeanga Marian
DBA Oracle
CNLO Romania
</pre><br />

pgsql-sql by date:

Previous
From: Roberto Mello
Date:
Subject: Re: explain
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: explain