Add EXPLAIN option GENERIC_PLAN for parameterized queries

Edit

ID 3962

Title Add EXPLAIN option GENERIC_PLAN for parameterized queries

Topic Monitoring & Control

Created 2022-10-25 10:16:16

Last modified 2023-03-24 21:07:45 (1 year, 7 months ago)

Latest email 2023-03-28 06:35:57 (1 year, 7 months ago)

Status

2023-03: Committed

2023-01: Moved to next CF

2022-11: Moved to next CF

Target version 16

Authors Laurenz Albe (laurenz)

Reviewers Julien Rouhaud (rjuju), Michel Pelletier (michelp), Jim Jones (jimus), Christoph Berg (myon)Become reviewer

Committer Tom Lane (tgl)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3962
git checkout commitfest/cf/3962

Emails

Make EXPLAIN generate a generic plan for a parameterized query: First at 2022-10-11 12:37:25 by Laurenz Albe <laurenz.albe at cybertec.at>
Latest at 2023-03-28 06:35:57 by Laurenz Albe <laurenz.albe at cybertec.at>
Latest attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v10.patch) at 2023-03-23 18:31:26 from Laurenz Albe <laurenz.albe at cybertec.at>
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v10.patch) at 2023-03-23 18:31:26 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v9.patch) at 2023-03-22 13:15:23 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v8.patch) at 2023-02-14 12:44:44 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v7.patch) at 2023-02-05 17:24:03 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v6.patch) at 2023-02-03 16:14:29 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v5.patch) at 2023-01-31 18:49:38 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v4.patch) at 2023-01-09 16:40:01 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v3.patch) at 2022-12-07 11:23:02 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.v2.patch) at 2022-10-29 08:35:26 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-option-GENERIC_PLAN.patch) at 2022-10-25 09:08:27 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)
    Attachment (0001-Add-EXPLAIN-support-for-parameterized-statements.patch) at 2022-10-11 12:37:25 from Laurenz Albe <laurenz.albe at cybertec.at> (Patch: Yes)

History

When	Who	What
2023-03-24 21:07:45	Tom Lane (tgl)	Closed in commitfest 2023-03 with status: Committed
2023-03-24 15:42:14	Tom Lane (tgl)	Added tgl as committer
2023-03-24 10:58:28	Christoph Berg (myon)	New status: Ready for Committer
2023-03-22 13:16:22	Laurenz Albe (laurenz)	New status: Needs review
2023-03-21 15:35:26	Christoph Berg (myon)	New status: Waiting on Author
2023-03-21 08:29:55	Christoph Berg (myon)	Added myon as reviewer
2023-01-31 16:14:27	vigneshwaran C (vignesh.postgres)	Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-16 13:45:25	Jim Jones (jimus)	Added jimus as reviewer
2022-12-14 00:03:28	Ian Barwick (barwick)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-05 17:15:02	Michel Pelletier (michelp)	Added michelp as reviewer
2022-10-25 10:47:36	Julien Rouhaud (rjuju)	Added rjuju as reviewer
2022-10-25 10:29:58	Laurenz Albe (laurenz)	Changed authors to Laurenz Albe (laurenz)
2022-10-25 10:16:40	Laurenz Albe (laurenz)	Changed targetversion to 16
2022-10-25 10:16:16	Laurenz Albe (laurenz)	Attached mail thread 0a29b954b10b57f0d135fe12aa0909bd41883eb0.camel@cybertec.at
2022-10-25 10:16:16	Laurenz Albe (laurenz)	Created patch record

Edit