DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=XbIuhhndxFYTwrXSZHMn3WdMA2dGds8nkuj/+272uCX6wf+8cugv3o41TP5f3sLBk5eT9wEP5UXzpJe4hNE8QjNB7lL1nFCBSEcUvSSAOwOUapahYqjz6vEymYVrfzYhEIIAQnbiTuEplexxQqzvIXR1LFSxC3G1MKIERW5h7JI=;
References: <1358965207.49445.YahooMailNeo@web120905.mail.ne1.yahoo.com>,
	<CA+h6Ahg6eDD=eVb5CrfeGCAevkRUSqcqWoC+7H_z8FO_RO=dCg@mail.gmail.com>
	<E7907DC29186A94988A077445AFD1DC02514D9AA@EXCHANGEVIC.ad.terapeak.com>
Message-ID: <1359018497.35010.YahooMailNeo@web125906.mail.ne1.yahoo.com>
Date: Thu, 24 Jan 2013 01:08:17 -0800 (PST)
From: Greg Williamson <gwilliamson39@yahoo.com>
Reply-To: Greg Williamson <gwilliamson39@yahoo.com>
Subject: Re: Getting
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <E7907DC29186A94988A077445AFD1DC02514D9AA@EXCHANGEVIC.ad.terapeak.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Dan --

>________________________________
> From: Michael Holt <MHolt@terapeak.com>
>To: Raghavendra <raghavendra.rao@enterprisedb.com>; Dan Ng <surfnet@yahoo.com> 
>Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org> 
>Sent: Wednesday, January 23, 2013 9:55 PM
>Subject: Re: [ADMIN] Getting
> 
>
> 
>Of course you can also see what the query plan will be without having to run the query through a standard explain query: 
>
>
>http://www.postgresql.org/docs/9.0/static/sql-explain.html
>
>
I am not familiar with the Oracle tools, but you should note that the "EXPLAIN ANALYZE" does actually do the transaction, so if you doing an update / insert / delete you may want to wrap it in an explicit transaction and then roll it back.

HTH,

Greg Williamson


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin