From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
---|---|
To: | PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: BUG: pg_stat_statements query normalization issues with combined queries |
Date: | 2016-12-20 09:55:08 |
Message-ID: | alpine.DEB.2.20.1612201049360.29821@lancre |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>> I was expecting the 2 combined queries either to be separated in individual
>> queries "SELECT data FROM Stuff WHERE id = ?" or in one large queries with
>> three ?, but not the above result...
>
> Oops, I forgot the attachement, see repeat script on 9.6.1
After some quick investigation, I concluded that the issue is that the
whole combined query string is used instead of the part refering to the
actual query being processed.
As a result:
- the full un-normalized string is used for both BEGIN & COMMIT
=> n shared entries, one for each actual query, begin & commit are mixed together
- the fist-part only normalized string is used for each SELECT
=> 1 shared entry with "query" is the first partially
normalied encountered combined query
--
Fabien.
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Rijkers | 2016-12-20 09:56:39 | Re: Logical Replication WIP |
Previous Message | Alvaro Herrera | 2016-12-20 09:51:36 | Re: Declarative partitioning - another take |