| 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: | Whole Thread | Raw Message | 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" |