From: | Popeanga Marian <pmarian(at)cnlo(dot)ro> |
---|---|
To: | Popeanga Marian <pmarian(at)cnlo(dot)ro> |
Cc: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>, Roberto Mello <rmello(at)cc(dot)usu(dot)edu>, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: explain |
Date: | 2003-03-21 11:00:29 |
Message-ID: | 3E7AF0CD.10103@cnlo.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar Mallah | 2003-03-21 12:10:27 | Re: explain |
Previous Message | Karel Zak | 2003-03-21 10:30:11 | Re: Formatting intervals.. |