martial(dot)bizel(at)free(dot)fr writes:
> In fact, I don't know how to have explain plan of remote node.
You send it an EXPLAIN.
You can *not* use a view defined as you suggest if you want decent
performance --- the dblink functions will fetch the entire table
contents and the filtering will be done locally. You'll need to
pass the WHERE conditions over to the remote servers, which more
or less means that you have to give them to the dblink functions
as text.
regards, tom lane