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/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
