Re: Removing width from EXPLAIN

From: greg(at)turnstep(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Removing width from EXPLAIN
Date: 2003-05-20 18:19:53
Message-ID: f4d16ea6ce779b953ca25f080d903fa6@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I guess I was thinking about this:

http://groups.google.com/groups?selm=10897.953919427%40sss.pgh.pa.us

"Average width is pretty bogus because the thing really doesn't have
any idea of the average length of variable-length columns. I'm thinking
about improving that in the future, but it may not be worth the trouble,
because the width isn't used for very much."

I also think that it is used that much: if you look at all the EXPLAINS
that have come across the various lists over the years, very few (if any)
utilize the "width" in any important way. It's important for computing
the cost, but I would like to suggest that the extra "noise" should be
off by default as most people never make use of it, and an EXPLAIN ANALYZE
is already quite verbose.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 200305201143

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE+ynErvJuQZxSWSsgRAsiKAKDXEaCPnhq8koIhnFNNPfm5HzhA9gCgszok
bBRBoL4Uoe8gqXzizeLlU2o=
=I1sV
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-05-20 18:28:42 Logging (was Re: Suggestion GRANT ALTER, TRIGGER ON ALTER)
Previous Message Josh Berkus 2003-05-20 18:19:36 Re: Suggestion GRANT ALTER, TRIGGER ON ALTER