Re: 7.3 schedule

Barry Lind <barry@xythos.com> writes:
> ...
> Since we 
> don't currently provide any information to the user on the relative cost 
> of the parse, plan and execute phases, the end user is going to be 
> guessing IMHO.

You can in fact get that information fairly easily; set 
show_parser_stats, show_planner_stats, and show_executor_stats to 1
and then look in the postmaster log for the results.  (Although to be
fair, this does not provide any accounting for the CPU time expended
simply to *receive* the query string, which might be non negligible
for huge queries.)

It would be interesting to see some stats for the large-BLOB scenarios
being debated here.  You could get more support for the position that
something should be done if you had numbers to back it up.
        regards, tom lane