Re: explain
| От | Popeanga Marian |
|---|---|
| Тема | Re: explain |
| Дата | |
| Msg-id | 3E7AAF87.4070007@cnlo.ro обсуждение исходный текст |
| Ответ на | explain (Popeanga Marian <pmarian@cnlo.ro>) |
| Ответы |
Re: explain
|
| Список | 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 по дате отправления: