Please check the below scenario, where the Foreign table on GTT not showing records.
postgres=# create extension postgres_fdw; CREATE EXTENSION postgres=# do $d$ begin execute $$create server fdw foreign data wrapper postgres_fdw options (host 'localhost',dbname 'postgres',port '$$||current_setting('port')||$$')$$; end; $d$; DO postgres=# create user mapping for public server fdw; CREATE USER MAPPING