Re: EXPLAIN (plan off, rewrite off) for benchmarking - Mailing list pgsql-hackers

From Tom Lane
Subject Re: EXPLAIN (plan off, rewrite off) for benchmarking
Date
Msg-id 27421.1321658178@sss.pgh.pa.us
Whole thread Raw
In response to EXPLAIN (plan off, rewrite off) for benchmarking  (Andres Freund <andres@anarazel.de>)
Responses Re: EXPLAIN (plan off, rewrite off) for benchmarking
List pgsql-hackers
Andres Freund <andres@anarazel.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


pgsql-hackers by date:

Previous
From: Thom Brown
Date:
Subject: Re: Should a materialized view be based on a view?
Next
From: "Kevin Grittner"
Date:
Subject: Re: testing ProcArrayLock patches