Dan -- >________________________________ > From: Michael Holt <MHolt@xxxxxxxxxxxx> >To: Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>; Dan Ng <surfnet@xxxxxxxxx> >Cc: "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx> >Sent: Wednesday, January 23, 2013 9:55 PM >Subject: Re: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
