Re: Query Jumbling for CALL and SET utility statements
От | bt22kawamotok |
---|---|
Тема | Re: Query Jumbling for CALL and SET utility statements |
Дата | |
Msg-id | 88c16ab86e915ea8a33d3b62522f5537@oss.nttdata.com обсуждение исходный текст |
Ответ на | Re: Query Jumbling for CALL and SET utility statements ("Drouvot, Bertrand" <bdrouvot@amazon.com>) |
Ответы |
Re: Query Jumbling for CALL and SET utility statements
|
Список | pgsql-hackers |
> Attached v5 to normalize 2PC commands too, so that we get things like: > > > create table test_tx (a int); > begin; > prepare transaction 'tx1'; > insert into test_tx values (1); > commit prepared 'tx1'; > begin; > prepare transaction 'tx2'; > insert into test_tx values (2); > commit prepared 'tx2'; > begin; > prepare transaction 'tx3'; > insert into test_tx values (3); > rollback prepared 'tx3'; > begin; > prepare transaction 'tx4'; > insert into test_tx values (4); > rollback prepared 'tx4'; > SELECT query, calls, rows FROM pg_stat_statements ORDER BY query > COLLATE "C"; > query > | calls | rows > ------------------------------------------------------------------------------+-------+------ > SELECT pg_stat_statements_reset() > | 1 | 1 > SELECT query, calls, rows FROM pg_stat_statements ORDER BY query > COLLATE "C" | 0 | 0 > begin > | 4 | 0 > commit prepared $1 > | 2 | 0 > create table test_tx (a int) > | 1 | 0 > insert into test_tx values ($1) > | 4 | 4 > prepare transaction $1 > | 4 | 0 > rollback prepared $1 > | 2 | 0 > (8 rows) > > For those ones I also had to do some minor changes in gram.y and to > the TransactionStmt struct to record the gid location. Thanks Bertrand. I used your patch. It's looks very good. I found that utility statement is counted separately in upper and lower case. For example BEGIN and begin are counted separately. Is it difficult to fix this problem? Regards, Kotaro Kawamoto
В списке pgsql-hackers по дате отправления: