Re: explain

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;

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