Re: explain

From: Popeanga Marian <pmarian(at)cnlo(dot)ro>
To: Roberto Mello <rmello(at)cc(dot)usu(dot)edu>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: explain
Date: 2003-03-21 06:21:59
Message-ID: 3E7AAF87.4070007@cnlo.ro
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

  • Re: explain at 2003-03-21 06:34:35 from Roberto Mello

Responses

  • Re: explain at 2003-03-21 08:23:17 from Rajesh Kumar Mallah

Browse pgsql-sql by date

  From Date Subject
Next Message Roberto Mello 2003-03-21 06:34:35 Re: explain
Previous Message Popeanga Marian 2003-03-21 06:09:01 Re: explain