Re: Ignore 2PC transaction GIDs in query jumbling - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Ignore 2PC transaction GIDs in query jumbling
Date
Msg-id ZMhnQMpS2YnvuyFb@paquier.xyz
Whole thread Raw
In response to Re: Ignore 2PC transaction GIDs in query jumbling  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: Ignore 2PC transaction GIDs in query jumbling
List pgsql-hackers
On Tue, Aug 01, 2023 at 09:28:08AM +0800, Julien Rouhaud wrote:
> Having an application relying on 2pc leads to pg_stat_statements being
> virtually unusable on the whole instance, so +1 for the patch.

Cool, thanks for the feedback!

> FTR we had to entirely ignore all those statements in powa years ago to try to
> make the tool usable in such case for some users who where using 2pc, it would
> be nice to be able to track them back for pg16+.

That would be nice for your users.  Are there more query patterns you'd
be interested in grouping in the backend?  I had a few folks aiming
for CallStmt and SetStmt, but both a a bit tricky without a custom
routine.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Simplify some logical replication worker type checking
Next
From: Laurenz Albe
Date:
Subject: Re: [PATCH] Add support function for containment operators