Detecting plan changes with plan_id in pg_stat

Detecting plan changes with plan_id in pg_stat_activity

Title

Detecting plan changes with plan_id in pg_stat_activity

Topic

Performance

Created

2022-06-21 19:56:31

Last modified

2022-08-08 17:50:55 (2 years, 3 months ago)

Latest email

2022-07-14 07:13:10 (2 years, 4 months ago)

Status

2022-07: Returned with feedback

Target version

Authors

Sami Imseih (simseih)

Reviewers

Julien Rouhaud (rjuju)Become reviewer

Committer

Links

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/3700
git checkout commitfest/cf/3700

Emails

[PROPOSAL] Detecting plan changes with plan_id in pg_stat_activity: First at 2022-06-15 18:45:38 by "Imseih (AWS), Sami" <simseih at amazon.com>
Latest at 2022-07-14 07:13:10 by Julien Rouhaud <rjuju123 at gmail.com>
Latest attachment (benchmark.sh) at 2022-06-22 23:05:54 from "Imseih (AWS), Sami" <simseih at amazon.com>
    Attachment (benchmark.sh) at 2022-06-22 23:05:54 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: No)
    Attachment (0001-Improve-pg_stat_statements-performance-for-similar-q.patch) at 2022-06-21 20:04:01 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)
    Attachment (POC-Compute-Plan-ID-in-Core.patch) at 2022-06-15 18:45:38 from "Imseih (AWS), Sami" <simseih at amazon.com> (Patch: Yes)

History

When	Who	What
2022-08-08 17:50:55	Sami Imseih (simseih)	Changed name to Detecting plan changes with plan_id in pg_stat_activity
2022-08-02 18:11:31	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Returned with feedback
2022-07-14 07:12:00	Julien Rouhaud (rjuju)	New status: Waiting on Author
2022-07-14 07:11:55	Julien Rouhaud (rjuju)	Added rjuju as reviewer
2022-06-21 19:56:39	Sami Imseih (simseih)	Changed authors to Sami Imseih (simseih)
2022-06-21 19:56:31	Sami Imseih (simseih)	Attached mail thread 604E3199-2DD2-47DD-AC47-774A6F97DCA9@amazon.com
2022-06-21 19:56:31	Sami Imseih (simseih)	Created patch record