Query jumbling for prepare statement

Started by bt22kawamotokover 3 years ago3 messages
#1bt22kawamotok
bt22kawamotok@oss.nttdata.com

Hi!

I found prepare statement are not jumbled.
Fro example PREPARE 't1'; and PREPARE 't2' are counted separately in
pg_stat_statements.
I think it needs to be fixed.
What do you think?

Regards,

Kotaro Kawamoto

#2Julien Rouhaud
rjuju123@gmail.com
In reply to: bt22kawamotok (#1)
Re: Query jumbling for prepare statement

Hi,

On Wed, Sep 14, 2022 at 05:14:06PM +0900, bt22kawamotok wrote:

I found prepare statement are not jumbled.
Fro example PREPARE 't1'; and PREPARE 't2' are counted separately in
pg_stat_statements.

Are you talking about PREPARE TRANSACTION? If yes I already suggested that a
few days ago (1), and Bertrand implemented it in the v5 version of the patch on
that thread.

[1]: /messages/by-id/20220908112919.2ytxpkitiw6lt2u6@jrouhaud

#3bt22kawamotok
bt22kawamotok@oss.nttdata.com
In reply to: Julien Rouhaud (#2)
Re: Query jumbling for prepare statement

2022-09-14 17:18 に Julien Rouhaud さんは書きました:

Hi,

On Wed, Sep 14, 2022 at 05:14:06PM +0900, bt22kawamotok wrote:

I found prepare statement are not jumbled.
Fro example PREPARE 't1'; and PREPARE 't2' are counted separately in
pg_stat_statements.

Are you talking about PREPARE TRANSACTION? If yes I already suggested
that a
few days ago (1), and Bertrand implemented it in the v5 version of the
patch on
that thread.

[1]
/messages/by-id/20220908112919.2ytxpkitiw6lt2u6@jrouhaud

Oh, I had missed it.
Thanks for telling me about it.

Kotaro Kawmaoto