Re: explain plans for foreign servers

From: Dinesh Salve <cooltodinesh(at)gmail(dot)com>
To: Yilin Zhang <jiezhilove(at)126(dot)com>
Cc: Sami Imseih <samimseih(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, Jeff Davis <pgsql(at)j-davis(dot)com>
Subject: Re: explain plans for foreign servers
Date: 2026-07-28 06:26:26
Message-ID: CAP+B4TCo3E_6J+Kg6XRg=zCAeWa-Qxhs8QpbxdE+D059yqg_SQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

A minor update in patch after observing cfbot failures.

Root cause was - _PG_init saved the previous explain* hooks but never
called them, so when postgres_fdw.so was lazily loaded during planning it
clobbered pg_plan_advice's per-plan hook and its "Generated Plan Advice"
output vanished — breaking contrib/pg_plan_advice/t/001_foreign_scan.pl on
every platform.

Regards,
Dinesh Salve

>

Attachment Content-Type Size
v6-0001-postgres_fdw-show-remote-EXPLAIN-plans-via-REMOTE.patch application/octet-stream 71.7 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message song yanli 2026-07-28 06:43:08 Re: pg_plan_advice: add NO_ scan and join method tags
Previous Message Ayush Tiwari 2026-07-28 06:24:45 Re: Add a pg_wal_preallocate() SQL function to eagerly create future WAL segments