pgsql: Update query_id computation - Mailing list pgsql-committers

From Bruce Momjian
Subject pgsql: Update query_id computation
Date
Msg-id E1lddnC-0001FN-7O@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Update query_id computation

Properly fix:

- the "ONLY" in FROM [ONLY] isn't hashed
- the agglevelsup field in GROUPING isn't hashed
- WITH TIES not being hashed (new in PG 13)
- "DISTINCT" in "GROUP BY [DISTINCT]" isn't hashed (new in PG 14)

Reported-by: Julien Rouhaud

Discussion: https://postgr.es/m/20210425081119.ulyzxqz23ueh3wuj@nol

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f7a97b6ec31f3f57a6154d0039c4de81ad517064

Modified Files
--------------
.../expected/pg_stat_statements.out                | 151 +++++++++++++++++++++
.../pg_stat_statements/sql/pg_stat_statements.sql  |  52 +++++++
src/backend/utils/misc/queryjumble.c               |   4 +
3 files changed, 207 insertions(+)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: doc: Add index entry for "multirange type"
Next
From: Peter Eisentraut
Date:
Subject: pgsql: Prevent lwlock dtrace probes from unnecessary work