| From: | sirisha chamarthi <sirichamarthi22(at)gmail(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Alexander Korotkov <akorotkov(at)postgresql(dot)org> |
| Subject: | Re: WAIT FOR command should do some query jumbling |
| Date: | 2026-08-28 23:06:58 |
| Message-ID: | CAKrAKeX8EjbF17aBoFJOjFh2k2V-G5ZzqK15Och+7PtoqS=8Xg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Peter,
On Fri, Aug 28, 2026 at 2:48 PM Peter Eisentraut <peter(at)eisentraut(dot)org>
wrote:
> Right now, WAIT FOR commands are recorded literally in
> pg_stat_statements. I think the actual LSN value should be replaced by
> some placeholder, like
>
> WAIT FOR LSN $1
>
> Otherwise, a client library or framework that runs this command
> repeatedly would needlessly spam pg_stat_statements.
>
> The query jumbling facilities should be used to handle this.
>
+1 to your suggestion. Please find the attached patch to address this issue.
Regards,
Sirisha
| Attachment | Content-Type | Size |
|---|---|---|
| v1-0001-Jumble-WAIT-FOR-LSN-target.patch | application/octet-stream | 2.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2026-08-28 23:11:41 | Re: REASSIGN OWNED vs. relisshared dep on !relisshared |
| Previous Message | Masahiko Sawada | 2026-08-28 22:48:47 | Re: [PATCH] Release replication slot on error in SQL-callable slot functions |