From: Abhishek <ajcool@gmail.com>
To: Kashmira Patel (kupatel) <kupatel@cisco.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Using EXPLAIN-ANALYZE
Date: Thu, 16 Feb 2006 15:39:23 -0500
Message-ID: <506ca6630602161239n15d0334boa46cc9d496b9d291@mail.gmail.com> (raw)
In-Reply-To: <18AE59788A3FC640A367E5652E664D80019287F0@xmb-sjc-237.amer.cisco.com>
References: <18AE59788A3FC640A367E5652E664D80019287F0@xmb-sjc-237.amer.cisco.com>
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
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: ajcool@gmail.com, kupatel@cisco.com
Subject: Re: Using EXPLAIN-ANALYZE
In-Reply-To: <506ca6630602161239n15d0334boa46cc9d496b9d291@mail.gmail.com>
* 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