<p>isn't that line pretty much the main point of "verbose"? I would assume anything new like this would get its own
optionwhich might default to on.<p>greg<p><blockquote type="cite">On 24 Jan 2010 03:08, "Robert Haas" <<a
href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>>wrote:<br /><br />Per recent discussion on
pgsql-performance,and per discussion on<br /> -hackers that it might not be too late for small patches after all,<br />
hereis a patch (as yet without documentation) which adds some<br /> additional instrumentation to EXPLAIN for hashes:
numberof buckets,<br /> number of batches, original number of batches, and peak memory<br /> utilization. Thoughts?<br
/><br/> I was also thinking about the possibility of adding a new option<br /> called "output" and making that control
whetherthe "Output" line gets<br /> printed. It's kind of annoying to use EXPLAIN (ANALYZE, VERBOSE)<br /> right now
(andmoreso with this patch) specifically because of that<br /> line, which is quite... verbose. If we're going to
changeit ever we<br /> should do it for 9.0, since we've made a lot of other changes that<br /> people will be
adjustingfor anyhow.<br /><br /> Also, do we want to change the schema URL? The existing URL was<br /> suggested by
Peterbut IIRC there was some thought that it might not<br /> be the best choice.<br /><br /><a
href="http://www.postgresql.org/2009/explain"target="_blank">http://www.postgresql.org/2009/explain</a><br /><font
color="#888888"><br/> ...Robert<br /></font><br /><br /> --<br /> Sent via pgsql-hackers mailing list (<a
href="mailto:pgsql-hackers@postgresql.org">pgsql-hackers@postgresql.org</a>)<br/> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgsql-hackers"
target="_blank">http://www.postgresql.org/mailpref/pgsql-hackers</a><br/><br /></blockquote>