On Wed, Jan 18, 2017 at 5:27 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
jeff.janes@gmail.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.
Is all of that data actually being transferred from the foreign to the local? If so, I don't think the optimization is a good choice in this case. Do you know where can I find the relevant source code which decides on this?