Re: [PATCH] Optionally record Plan IDs to track plan changes for a query
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Lukas Fittl <lukas@fittl.com>
Cc: Sami Imseih <samimseih@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Marko M <marko@pganalyze.com>
Date: 2025-01-31T04:37:03Z
Lists: pgsql-hackers
Attachments
- v3-0001-Allow-using-jumbling-logic-outside-of-query-jumbl.patch (text/x-diff) patch v3-0001
- v3-0002-Optionally-record-a-plan_id-in-PlannedStmt-to-ide.patch (text/x-diff) patch v3-0002
- v3-0003-Add-pg_stat_plans-contrib-extension.patch (text/x-diff) patch v3-0003
On Mon, Jan 27, 2025 at 12:53:36PM +0900, Michael Paquier wrote: > Not sure about this part yet. I have looked at 0002 to begin with > something and it is really useful on its own. Stats kinds calling > this routine don't need to worry about the internals of dropping local > references or doing a seqscan on the shared hash table. However, what > you have sent lacks in flexibility to me, and the duplication with > pgstat_drop_all_entries is annoying. This had better be merged in a > single routine. After thinking more about this one, I still want this toy and hearing nothing I have applied it, with a second commit for the addition in injection_points to avoid multiple bullet points in a single commit. I have noticed post-commit that I have made a mistake in the credits of a632cd354d35 and ce5c620fb625 for your family name. Really sorry about that! This mistake is on me.. > What do you think? Attached is a rebased version of the three remaining patches. While looking at this stuff, I have noticed an extra cleanup that would be good to have, as a separate change: we could reformat a bit the plan header comments so as these do not require a rewrite when adding node_attr to them, like d575051b9af9. Sami's patch set posted at [1] has the same problem, making the proposals harder to parse and review, and the devil is in the details with these pg_node_attr() properties attached to the structures. That would be something to do on top of the proposed patch sets. Would any of you be interested in that? [1]: https://www.postgresql.org/message-id/CAA5RZ0sUPPOpkRZD=Za83op2ngcPC7dp249vcHA-X5YS7p3n8Q@mail.gmail.com -- Michael
Commits
-
doc: Update header file mention for CompareType
- b39013b7b1b1 19 (unreleased) cited
-
Allow plugins to set a 64-bit plan identifier in PlannedStmt
- 2a0cd38da5cc 18.0 landed
-
Fix indentation of comment in plannodes.h
- c9238ad85325 18.0 landed
-
Reformat node comments in plannodes.h
- 3d17d7d7fb7a 18.0 landed
-
injection_points: Add routine able to drop all stats
- a632cd354d35 18.0 landed
-
Add pgstat_drop_matching_entries() to pgstats
- ce5c620fb625 18.0 landed
-
Move pg_stat_statements query jumbling to core.
- 5fd9dfa5f50e 14.0 cited