Re: [BUGS] BUG #14505: explain verbose for postgresql_fdw - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14505: explain verbose for postgresql_fdw
Date
Msg-id 20910.1484789276@sss.pgh.pa.us
Whole thread Raw
In response to [BUGS] BUG #14505: explain verbose for postgresql_fdw  (jeff.janes@gmail.com)
Responses Re: [BUGS] BUG #14505: explain verbose for postgresql_fdw  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-bugs
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.

            regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

pgsql-bugs by date:

Previous
From: Clailson
Date:
Subject: [BUGS] Optimization inner join
Next
From: Pavel Stehule
Date:
Subject: Re: [BUGS] BUG #14446: make_date with negative year