[HACKERS] BUG: pg_stat_statements query normalization issues with combinedqueries

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема [HACKERS] BUG: pg_stat_statements query normalization issues with combinedqueries
Дата
Msg-id alpine.DEB.2.20.1612200926310.29821@lancre
обсуждение исходный текст
Ответы Re: [HACKERS] BUG: pg_stat_statements query normalization issueswith combined queries  (Fabien COELHO <coelho@cri.ensmp.fr>)
Список pgsql-hackers
Hello,

While investigating a performance issue, I tried to get informations from 
pg_stat_statements, however I ran into another issue: it seems that when 
using combined queries pg_stat_statements query normalization does not 
work properly... 2 queries that should have been mapped to only one are 
instead map to... 3 cases, as constants are not all ignored:
                query
 BEGIN ;                               + SELECT data FROM Stuff WHERE id = 1 ; + SELECT data FROM Stuff WHERE id = 2 ;
+SELECT data FROM Stuff WHERE id = 3 ; + COMMIT;
 
 BEGIN ;                               + SELECT data FROM Stuff WHERE id = 4 ; + SELECT data FROM Stuff WHERE id = 5 ;
+SELECT data FROM Stuff WHERE id = 6 ; + COMMIT;
 
 BEGIN ;                               + SELECT data FROM Stuff WHERE id = ?   + SELECT data FROM Stuff WHERE id = 2
+SELECT data FROM Stuff WHERE id = 3   + COMMIT;
 

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...

-- 
Fabien



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] increasing the default WAL segment size
Следующее
От: Petr Jelinek
Дата:
Сообщение: Re: [HACKERS] Logical Replication WIP