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
