ORDER BY too slow in Foreign Table using postgres_fdw
Sort operation is performed on local postgres server, not on remote. If your code always sort the results, you
  can just create a view on remote postgres with order by clause and
  then create a foreign table pointing to the view.


On remote server, adding a view

CREATE VIEW vw_user_info_raw
SELECT id, info 
FROM user_info_raw
ORDER BY id 


On local server, create foreign table references to that view

CREATE FOREIGN TABLE user_info (
  id bigint ,
  info jsonb 
) 
SERVER server_test_fdw OPTIONS(SCHEMA_NAME 'public', TABLE_NAME 'vw_user_info_raw' );


Refer to Postgres Admin Forum