Re: [HACKERS] EXPLAIN VERBOSE vs resjunk output columns

2009-08-21 Thread Greg Stark
On Sat, Aug 22, 2009 at 1:37 AM, Tom Lane wrote: > You can see that from the fact that the estimated row width is > 8 bytes (two integers) ... but tenthous is nowhere to be seen in the > Output: line. +1 for self-consistent output. If we're including their size in "width" then they should be in th

Re: [HACKERS] EXPLAIN VERBOSE vs resjunk output columns

2009-08-21 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > Currently, explain.c goes out of its way to not print "resjunk" output > columns (those not meant to be seen by the user, such as hidden sort key > columns) in EXPLAIN VERBOSE targetlists. I made 8.4 act that way for > reasons I don't recall at the moment,

[HACKERS] EXPLAIN VERBOSE vs resjunk output columns

2009-08-21 Thread Tom Lane
Currently, explain.c goes out of its way to not print "resjunk" output columns (those not meant to be seen by the user, such as hidden sort key columns) in EXPLAIN VERBOSE targetlists. I made 8.4 act that way for reasons I don't recall at the moment, but I've found several times now that it's misl