On 29/01/17 05:31, Pavel Stehule wrote:
2017-01-28 17:09 GMT+01:00 Tom Lane <t...@sss.pgh.pa.us
<mailto:t...@sss.pgh.pa.us>>:
Pavel Stehule <pavel.steh...@gmail.com
<mailto:pavel.steh...@gmail.com>> writes:
> Now EXPLAIN ANALYZE produce too wide rows for usage in presentations
> What do you think about possibility to implement >>optional<<
alternative
> formatting.
> Now:
> node name (estimation) (actual)
> Alternative:
> node name (estimation)
> (actual)
Seems like that would make a difference in only a tiny minority of
situations. In a deeply nested plan you'll have trouble no matter
what, and it's not uncommon that the node name line isn't the widest
thing anyway.
It is related to presentation where you have to use large type - and
where usually don't present complex nested plans, or you present only
fragments.
A output of EXPLAIN is usually ok - EXPLAIN ANALYZE does a overflow
This feature is in nice to have category - probably interesting for
lectures or presenters only - can helps and doesn't need lot of work.
So I am ask for community opinion.
The result should not be exactly how I proposed - any form what is
more friendly for tiny monitor (projectors) is welcome
Regards
Pavel
regards, tom lane
How about have a GUC to control the formatting of how it is displayed?
Could also include maximum line width (default 'infinite'), and word
wrapping rules, ...
Cheers,
Gavin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers