Re: BUG #14505: explain verbose for postgresql_fdw

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jeff(dot)janes(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14505: explain verbose for postgresql_fdw
Date: 2017-01-19 01:27:56
Message-ID: 20910.1484789276@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

jeff(dot)janes(at)gmail(dot)com writes:
> The "Output:" line of explain verbose lists columns of foreign table that
> are not actually output, or at least ought not be output.

That's an optimization to avoid an unnecessary projection step. It has
nothing to do with what's retrieved from the remote, and for that matter
it's not specific to foreign tables.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Pavel Stehule 2017-01-19 04:47:43 Re: BUG #14446: make_date with negative year
Previous Message Clailson 2017-01-19 00:36:21 Optimization inner join