From: | Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> |
---|---|
To: | Popeanga Marian <pmarian(at)cnlo(dot)ro>, Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: explain |
Date: | 2003-03-21 08:23:17 |
Message-ID: | 200303211353.17208.mallah@trade-india.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
>
>
>
--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)
Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.
From | Date | Subject | |
---|---|---|---|
Next Message | Popeanga Marian | 2003-03-21 08:27:44 | Re: explain |
Previous Message | Roberto Mello | 2003-03-21 06:34:35 | Re: explain |