Horton

Update query_id computation

Bruce Momjian <bruce@momjian.us>

View on postgr.es
Commit: f7a97b6ec31f3f57a6154d0039c4de81ad517064
Author: Bruce Momjian <bruce@momjian.us>
Date: 2021-05-03T18:59:39Z
Releases: 14.0 
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

Files

PathChange+/−
contrib/pg_stat_statements/expected/pg_stat_statements.out modified +151 −0
contrib/pg_stat_statements/sql/pg_stat_statements.sql modified +52 −0
src/backend/utils/misc/queryjumble.c modified +4 −0

Discussion