EXPLAIN Sort Method whitespace

Started by Peter Eisentrautabout 15 years ago2 messages
#1Peter Eisentraut
peter_e@gmx.net

Is there a reason why there are two spaces after the first colon in

"Sort Method: %s %s: %ldkB\n"

Is the second part (Disk/Memory) considered part of the sort method?

The original commit for that is d2a4a406.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Peter Eisentraut (#1)
Re: EXPLAIN Sort Method whitespace

Peter Eisentraut <peter_e@gmx.net> writes:

Is there a reason why there are two spaces after the first colon in
"Sort Method: %s %s: %ldkB\n"

Is the second part (Disk/Memory) considered part of the sort method?

I think of it as a separate field that we cram onto the same line (in
the textual output format) for space reasons. In the machine-readable
formats it's definitely separate.

I agree it seems a bit inconsistent that there are two spaces after
one colon and only one after the other. I must have thought it was
a good idea at the time, but now I don't remember why. Since we
don't seem to put two spaces after any other colon in text format,
maybe
"Sort Method: %s %s: %ldkB\n"
would be better. Is that what you were thinking?

regards, tom lane