Re: EXPLAIN (plan off, rewrite off) for benchmarking
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@postgresql.org
Date: 2011-11-18T23:16:18Z
Lists: 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