Logging plan of the currently running query

Edit

5330

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v45, Patch count: 1, First patch: +573−54, All patches: +573−54

Topic

Monitoring & Control

Tags

Monitoring

Created

2024-10-28 13:21:12

Last modified

2025-06-24 01:17:44 (2 days ago)

Latest email

2025-06-02 12:56:38 (3 weeks ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Needs review

2025-03 (2025-03-01 - 2025-04-08): Moved to different CF

2025-01 (2025-01-01 - 2025-01-31): Moved to different CF

2024-11 (2024-11-01 - 2024-11-30): Moved to different CF

Target version

Authors

Atsushi Torikoshi (atsushitorikoshi)

Reviewers

Akshat Jaimini (akshatj), Sadeq Dousti (msdousti)Become reviewer

Committer

Links

Emails

Re: RFC: Logging plan of the running query: First at 2021-11-02 11:32:59 by Ekaterina Sokolova <e.sokolova at postgrespro.ru>
Latest at 2025-06-02 12:56:38 by torikoshia <torikoshia at oss.nttdata.com>
Latest attachment (v45-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-06-02 12:56:38 from torikoshia <torikoshia at oss.nttdata.com>
    Attachment (v45-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-06-02 12:56:38 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (example-execprocnodefirst-patch.diff) at 2025-05-22 15:07:50 from Robert Haas <robertmhaas at gmail.com> (Patch: Yes)
    Attachment (v45-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-05-20 13:17:59 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v44-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-04-24 12:48:57 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v43-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-04-05 06:13:47 from Atsushi Torikoshi <torikoshia.tech at gmail.com> (Patch: Yes)
    Attachment (v42-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-03-21 12:40:00 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v41-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-03-10 05:10:27 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v40-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-02-03 12:46:29 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v39-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2024-10-28 13:05:03 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v38-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2024-03-13 05:28:42 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v37-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2024-02-26 12:01:45 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v36-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2024-02-14 06:29:35 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v35-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2024-01-29 13:02:29 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v34-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-12-06 23:33:56 from Rafael Thofehrn Castro <rafaelthca at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-11-09 06:33:36 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v32-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-10-26 06:53:22 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v31-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-10-12 13:21:26 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v30-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-10-10 13:27:08 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (improve.diff) at 2023-09-15 06:21:27 from "Lepikhov Andrei" <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (ps.txt) at 2023-08-28 13:47:19 from James Coleman <jtc331 at gmail.com> (Patch: No)
    Attachment (v29-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-08-17 14:02:22 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v28-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-06-15 16:34:23 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-06-05 18:26:25 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Add-function-to-log-the-plan-of-the-query.patch) at 2023-06-02 17:51:22 from James Coleman <jtc331 at gmail.com> (Patch: Yes)
    Attachment (v25-0001-log-running-query-plan.patch) at 2022-12-08 05:10:32 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v24-0001-log-running-query-plan.patch) at 2022-09-20 14:41:57 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (unknown_filename) at 2022-09-19 08:47:21 from Алена Рыбакина <lena.ribackina at yandex.ru> (Patch: No)
    Attachment (v23-0001-log-running-query-plan.patch) at 2022-09-08 10:19:09 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v22-0001-log-running-query-plan.patch) at 2022-05-16 08:02:40 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v21-0001-log-running-query-plan.patch) at 2022-03-09 10:04:49 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v20-0001-log-running-query-plan.patch) at 2022-02-08 15:12:50 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v19-0001-log-running-query-plan.patch) at 2022-02-02 12:59:12 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v18-0001-log-running-query-plan.patch) at 2022-01-28 08:45:49 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v17-0001-log-running-query-plan.patch) at 2022-01-24 05:33:05 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v16-0001-log-running-query-plan.patch) at 2022-01-07 11:58:19 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v15-0001-log-running-query-plan.patch) at 2022-01-07 05:30:37 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v14-0001-log-running-query-plan.patch) at 2021-11-26 03:39:48 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v13-0002-log-running-query-plan.patch) at 2021-11-17 13:44:51 from Ekaterina Sokolova <e.sokolova at postgrespro.ru> (Patch: Yes)

History

When	Who	What
2025-06-24 01:17:44	Atsushi Torikoshi (atsushitorikoshi)	Changed tags to Monitoring
2025-06-02 13:34:11	atsushi torikoshi (atorik)	New status: Needs review
2025-05-24 05:29:59	atsushi torikoshi (atorik)	New status: Waiting on Author
2025-05-20 13:35:56	Atsushi Torikoshi (atsushitorikoshi)	New status: Needs review
2025-05-08 13:52:09	Atsushi Torikoshi (atsushitorikoshi)	New status: Waiting on Author
2025-04-24 13:14:53	CFbot	Patch does not need rebase anymore
2025-04-12 08:29:39	CFbot	Patch needs rebase
2025-04-11 00:40:04	Atsushi Torikoshi (atsushitorikoshi)	Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-31 18:54:44	Sadeq Dousti (msdousti)	Added msdousti as reviewer
2025-03-21 13:14:44	CFbot	Patch does not need rebase anymore
2025-03-19 17:51:43	CFbot	Patch needs rebase
2025-03-10 05:31:44	CFbot	Patch does not need rebase anymore
2025-03-08 15:42:22	Akshat Jaimini (akshatj)	Posted comment with messageid <174144854199.294105.9417032645816235284.pgcf@coridan.postgresql.org>
2025-02-28 22:05:36	CFbot	Patch needs rebase
2025-02-17 06:05:04	Akshat Jaimini (akshatj)	Added akshatj as reviewer
2025-02-10 02:07:11	Atsushi Torikoshi (atsushitorikoshi)	Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-02 14:19:17	Kirill Reshke (reshke)	Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-28 13:21:40	atsushi torikoshi (atorik)	Changed authors to Atsushi Torikoshi (atsushitorikoshi)
2024-10-28 13:21:40	atsushi torikoshi (atorik)	Changed targetversion to 18
2024-10-28 13:21:12	atsushi torikoshi (atorik)	Attached mail thread d68c3ae31672664876b22d2dcbb526d2@postgrespro.ru
2024-10-28 13:21:12	atsushi torikoshi (atorik)	Created patch record

Edit