X-Original-To: pgsql-sql@postgresql.org
Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56])
	by postgresql.org (Postfix) with ESMTP id CB4CD475F1C
	for <pgsql-sql@postgresql.org>; Fri, 21 Mar 2003 01:18:44 -0500 (EST)
Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian))
	id 18wG6t-0001n4-00; Thu, 20 Mar 2003 23:34:35 -0700
Date: Thu, 20 Mar 2003 23:34:35 -0700
From: Roberto Mello <rmello@cc.usu.edu>
To: Popeanga Marian <pmarian@cnlo.ro>
Cc: pgsql-sql@postgresql.org
Subject: Re: explain
Message-ID: <20030321063435.GA6863@cc.usu.edu>
References: <3E7AA719.2090507@cnlo.ro>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <3E7AA719.2090507@cnlo.ro>
User-Agent: Mutt/1.4i
X-message-flag: Please consider using an e-mail program other than Outlook.
	It's insecure.
X-Archive-Number: 200303/485
X-Sequence-Number: 12524

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

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
"There's 2 kind of people: those who knows assembler and the rest"