pgBadger and postgres_fdw

From: "Colin 't Hart" <colinthart(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: pgBadger and postgres_fdw
Date: 2026-01-21 08:18:52
Message-ID: CAMon-aR8f3zi1Wytg-TCrbLa=sAooi4kTzbjukcvdt8G4mycbw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

One of my clients makes extensive use of postgres_fdw. After a migration
performance isn't great. pgBadger reports show the slowest queries all
being `fetch 100 from c2`.

Anyone have any tricks for being able to associate those fetches with the
queries that were used when declaring the server-side cursor?

Thanks,

Colin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nicolas Seinlet 2026-01-21 08:38:56 Re: pg_trgm upgrade to 1.6 led to load average increase
Previous Message Peter Eisentraut 2026-01-21 07:52:23 Re: Collation with upper and numeric comparing in unexpected way