On Wed, 2026-01-21 at 17:12 +0100, Colin 't Hart wrote: > My question is how to identify which connections / queries from postgres_fdw > are > generating the `fetch 100 from c2` queries, which, in turn, may quite possibly > lead to a feature request for having these named uniquely.
I would inverstigate that on the remote database. If the user that postgres_fdw uses to connect is remote_user, you could ALTER ROLE remote_user SET log_min_duretion_statement = 0; Then any statements executed through postgres_fdw would be logged. If you have %x in log_line_prefix, you can find the DECLARE statement that declared the cursor that takes so long to fetch. Not very comfortale, but it should work. Yours, Laurenz Albe
