public inbox for [email protected]  

help / color / mirror / Atom feed

pgBadger and postgres_fdw
2+ messages / 2 participants
[nested] [flat]

* pgBadger and postgres_fdw
@ 2026-01-21 08:18 Colin 't Hart <[email protected]>
  2026-01-21 15:43 ` Re: pgBadger and postgres_fdw Adrian Klaver <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Colin 't Hart @ 2026-01-21 08:18 UTC (permalink / raw)
  To: PostgreSQL General <[email protected]>

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: pgBadger and postgres_fdw
  2026-01-21 08:18 pgBadger and postgres_fdw Colin 't Hart <[email protected]>
@ 2026-01-21 15:43 ` Adrian Klaver <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Adrian Klaver @ 2026-01-21 15:43 UTC (permalink / raw)
  To: Colin 't Hart <[email protected]>; PostgreSQL General <[email protected]>

On 1/21/26 00:18, Colin 't Hart wrote:
> 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?

This is going to need a lot more information. To start:

1) Migration of what and from what version to what version?

2) Where are the Postgres databases relative to each other on the network?

3) What versions of Postgres if not covered in 1.

4) If Postgres was what was being updated was an analyze done on the 
instances?

5) Show a complete query using EXPLAIN ANALYZE.

6) Define slow.

> 
> Thanks,
> 
> Colin


-- 
Adrian Klaver
[email protected]






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2026-01-21 15:43 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-01-21 08:18 pgBadger and postgres_fdw Colin 't Hart <[email protected]>
2026-01-21 15:43 ` Adrian Klaver <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox