From: Popeanga Marian <pmarian@cnlo.ro>
To: Roberto Mello <rmello@cc.usu.edu>
Cc: pgsql-sql@postgresql.org
Subject: Re: explain
Date: Fri, 21 Mar 2003 08:21:59 +0200
Message-ID: <3E7AAF87.4070007@cnlo.ro> (raw)
References: <3E7AA719.2090507@cnlo.ro>
<20030321063435.GA6863@cc.usu.edu>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pmarian@cnlo.ro, rmello@cc.usu.edu
Subject: Re: explain
In-Reply-To: <3E7AAF87.4070007@cnlo.ro>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox