pgsql: Apply some query jumbling to WAIT FOR LSN

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Apply some query jumbling to WAIT FOR LSN
Date: 2026-09-02 05:14:51
Message-ID: E1x1dJB-000000038IL-3qOj@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Apply some query jumbling to WAIT FOR LSN

The query is now stored as normalized in pg_stat_statements, with its
LSN position ignored in the jumbling, resulting in:
WAIT FOR LSN $1;

The option values in the WITH clause are left untouched.

Reported-by: Peter Eisentraut <peter(at)eisentraut(dot)org>
Author: Sirisha Chamarthi <sirichamarthi22(at)gmail(dot)com>
Reviewed-by: Sami Imseih <samimseih(dot)pg(at)gmail(dot)com>
Reviewed-by: Rithvika Devisetti <devisettirithvika(at)gmail(dot)com>
Discussion: https://postgr.es/m/1f04f78c-2cfa-47a0-997f-f02572cd10eb@eisentraut.org
Backpatch-through: 19

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/7635a3206797a9c793bcf2e43d107c9fe08dc17d

Modified Files
--------------
contrib/pg_stat_statements/expected/utility.out | 41 +++++++++++++++++++++++++
contrib/pg_stat_statements/sql/utility.sql | 10 ++++++
src/backend/parser/gram.y | 1 +
src/include/nodes/parsenodes.h | 8 +++--
4 files changed, 58 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Fujii Masao 2026-09-02 05:36:23 pgsql: Fix checkpointer restartpoint assertion failure
Previous Message Michael Paquier 2026-09-02 05:14:50 pgsql: Apply some query jumbling to WAIT FOR LSN