martial.bizel@xxxxxxx 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
