Re: Plan targetlists in EXPLAIN output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Plan targetlists in EXPLAIN output
Date: 2008-04-17 18:22:59
Message-ID: 23762.1208456579@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> Or is it estimating the width based on the belief that only the thousand
> column is actually going to be emitted?

Right. The width is used to estimate how much space would be needed
for, eg, sorting or hashing the plan node's output. In any case where
something like that is actually happening, we *should* be emitting only
the required columns, so I didn't see any particular need to make
use_physical_tlist change the reported width. OTOH this bug shows that
maybe that was hiding useful information ...

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-04-17 18:42:49 Re: Plan targetlists in EXPLAIN output
Previous Message Gregory Stark 2008-04-17 18:09:04 Re: Plan targetlists in EXPLAIN output