On Wed, Jan 21, 2009 at 02:55:00PM +0200, Herouth Maoz wrote:
> Filip Rembiakowski wrote:
> > 2. can you post results of EXPLAIN ANALYZE (please note it actually
> > executes the query)?
>
> Well, if it executes the query it's a problem.
You can wrap an EXPLAIN ANALYSE up in BEGIN;...ROLLBACK;. That way
PG won't record any of the changes permanently. More explanation is
available in the docs:
http://www.postgresql.org/docs/current/static/sql-explain.html
--
Sam http://samason.me.uk/