Postgres Pro
Downloads
Home   >   mailing lists

Thread: Demoting the "width" part of EXPLAIN

Demoting the "width" part of EXPLAIN

From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Seeing as how width is so unused relative to the other items in the
explain output, how about removing it from the normal explain output
and requiring people to do an explain verbose if they really need to
see it? It would have the virtue of shortening the explain output
quite a bit.

- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200605071158
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFEXhoJvJuQZxSWSsgRAhwMAJ0fx50409xt/mbrPzlOQo9hHIFb/QCfeo6c
cS5OUplpDEdcwQ1G547MD3I=
=k2jb
-----END PGP SIGNATURE-----

Re: Demoting the "width" part of EXPLAIN

From
"Jim C. Nasby"
Date:
On Sun, May 07, 2006 at 04:03:45PM -0000, Greg Sabino Mullane wrote:
> Seeing as how width is so unused relative to the other items in the
> explain output, how about removing it from the normal explain output
> and requiring people to do an explain verbose if they really need to
> see it? It would have the virtue of shortening the explain output
> quite a bit.

The problem with that is that it's essentially impossible to obtain
information from explain verbose, and width is sometimes useful. Maybe
change existing EXPLAIN VERBOSE to EXPLAIN DEBUG?
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

Re: Demoting the "width" part of EXPLAIN

From
Tom Lane
Date:
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> Seeing as how width is so unused relative to the other items in the
> explain output,

Huh?  It's a critical part of the cost calculations for some things
(eg, sort and hash operations).
        regards, tom lane