X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 0F3429DCC63
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 16 Feb 2006 16:39:35 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 87828-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 16 Feb 2006 16:39:35 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193])
	by postgresql.org (Postfix) with ESMTP id D33989DCC17
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2006 16:39:32 -0400 (AST)
Received: by wproxy.gmail.com with SMTP id i32so243572wra
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2006 12:39:33 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=in3gd3XGkpZkSksLhtmvyyfRwCW3XhDqEcBEEQ3+P1o7xo5wopSxFE9dYBmVEs5V+QR5N3f6B5Z9qOKkIe+Xb64unHqE/H28EqCrrpD01++AYlOkpjym+VpDHktOTVkXE9wA0Yd7/RTwHaBmAsmOvhzugf0qHfCoJp0Y7SCC0us=
Received: by 10.54.152.4 with SMTP id z4mr99175wrd;
	Thu, 16 Feb 2006 12:39:23 -0800 (PST)
Received: by 10.54.101.2 with HTTP; Thu, 16 Feb 2006 12:39:23 -0800 (PST)
Message-ID: <506ca6630602161239n15d0334boa46cc9d496b9d291@mail.gmail.com>
Date: Thu, 16 Feb 2006 15:39:23 -0500
From: Abhishek <ajcool@gmail.com>
To: "Kashmira Patel (kupatel)" <kupatel@cisco.com>
Subject: Re: Using EXPLAIN-ANALYZE
Cc: pgsql-sql@postgresql.org
In-Reply-To: 
 <18AE59788A3FC640A367E5652E664D80019287F0@xmb-sjc-237.amer.cisco.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_10599_29278583.1140122363167"
References: 
 <18AE59788A3FC640A367E5652E664D80019287F0@xmb-sjc-237.amer.cisco.com>
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001]
X-Spam-Score: 0.001
X-Spam-Level: 
X-Archive-Number: 200602/211
X-Sequence-Number: 24221

------=_Part_10599_29278583.1140122363167
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

http://www.postgresql.org/docs/7.2/static/performance-tips.html

EXPLAIN is explaied quite nicely with examples here. Hope that helps

Bests
AJ

On 2/16/06, Kashmira Patel (kupatel) <kupatel@cisco.com> wrote:
>
> Hi all,
>    I am pretty new to using Postrgres, and have been looking at the
> messages in this forum for a while. I have noticed that the use of
> EXPLAIN-ANALYZE is recommended quite a lot. I read the Postgres docs, but=
 am
> not quite sure I understand how this works. Is there some tutorial or any
> other documentation how this can be used?
>
> Thanks a lot,
> Kashmira Patel
>



--
Bests,
AJ

------=_Part_10599_29278583.1140122363167
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div><a href=3D"http://www.postgresql.org/docs/7.2/static/performance-tips.=
html">http://www.postgresql.org/docs/7.2/static/performance-tips.html</a></=
div>
<div>&nbsp;</div>
<div>EXPLAIN is explaied quite nicely with examples here. Hope that helps</=
div>
<div>&nbsp;</div>
<div>Bests</div>
<div>AJ<br>&nbsp;</div>
<div><span class=3D"gmail_quote">On 2/16/06, <b class=3D"gmail_sendername">=
Kashmira Patel (kupatel)</b> &lt;<a href=3D"mailto:kupatel@cisco.com">kupat=
el@cisco.com</a>&gt; wrote:</span>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div><span><font face=3D"Arial" size=3D"2">Hi all,</font></span></div>
<div><span><font face=3D"Arial" size=3D"2">&nbsp;&nbsp; I am pretty new to =
using Postrgres, and have been looking at the messages in this forum for a =
while. I have noticed that the use of EXPLAIN-ANALYZE is recommended quite =
a lot. I read the Postgres docs, but am not quite sure I understand how thi=
s works. Is there some tutorial or any other documentation how this can be =
used?
</font></span></div>
<div><span><font face=3D"Arial" size=3D"2"></font></span>&nbsp;</div>
<div><span><font face=3D"Arial" size=3D"2">Thanks a lot,</font></span></div=
><span class=3D"sg">
<div><span><font face=3D"Arial" size=3D"2">Kashmira Patel</font></span></di=
v></span></blockquote></div><br><br clear=3D"all"><br>-- <br>Bests,<br>AJ=
=20

------=_Part_10599_29278583.1140122363167--