From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Update query_id computation |
Date: | 2021-05-03 18:59:42 |
Message-ID: | E1lddnC-0001FN-7O@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(+)
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2021-05-03 19:09:55 | pgsql: Prevent lwlock dtrace probes from unnecessary work |
Previous Message | Peter Eisentraut | 2021-05-03 18:16:45 | pgsql: doc: Add index entry for "multirange type" |