Re: EXPLAIN (plan off, rewrite off) for benchmarking

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: EXPLAIN (plan off, rewrite off) for benchmarking
Date: 2011-11-18 23:16:18
Message-ID: 27421.1321658178@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund <andres(at)anarazel(dot)de> writes:
> Hi,
> For benchmarking the parser I added the above options (dim suggested this on
> irc) which proved to be rather useful for me.

What exactly is EXPLAIN printing, if you've not done planning? Also, I
believe the planner depends on the assumption that the rewriter has done
its work, so these seem to amount to EXPLAIN (break_it).

If you just want to benchmark parsing, perhaps CREATE RULE would be a
useful environment.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Grittner 2011-11-18 23:18:07 Re: testing ProcArrayLock patches
Previous Message Thom Brown 2011-11-18 22:37:51 Re: Should a materialized view be based on a view?