I am trying to create a materialized view with postgresql_fdw, and it hangs for hours. In pg_stat_activity I am seeing wait_event_type and wait_event Extension.
In the source server, the state is "idle in transaction" and the query is "FETCH 100 FROM c1". Any suggestions on how to speed this up?