Logging plan of the currently running query

Edit
ID 5330
Title Logging plan of the currently running query
CI (CFBot) Needs rebase! Needs rebase since yesterday. Failing since yesterday.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic Monitoring & Control
Tags Monitoring
Created 2024-10-28 13:21:12
Last modified 2025-10-01 09:36:29 (1 week ago)
Latest email 2025-10-01 09:11:23 (1 week ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
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 18
Authors Atsushi Torikoshi (atsushitorikoshi)
Reviewers Hironobu Suzuki (suzuki_hironobu), 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-10-01 09:11:23 by torikoshia <torikoshia at oss.nttdata.com>
Latest attachment (v49-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-10-01 09:11:23 from torikoshia <torikoshia at oss.nttdata.com>
    Attachment (v49-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-10-01 09:11:23 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v48-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-09-19 12:42:16 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v47-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-09-16 13:30:31 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v46-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-09-01 13:35:11 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    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-10-09 21:56:23 CFbot Patch needs rebase
2025-10-01 09:36:29 Atsushi Torikoshi (atsushitorikoshi) Moved from CF PG19-2 to CF PG19-3
2025-09-19 16:25:25 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2025-09-10 08:42:09 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
2025-09-01 13:29:25 CFbot Patch does not need rebase anymore
2025-08-24 08:05:28 CFbot Patch needs rebase
2025-08-24 08:04:53 Atsushi Torikoshi (atsushitorikoshi) Moved from CF PG19-1 to CF PG19-2
2025-08-18 14:23:47 Hironobu Suzuki (suzuki_hironobu) Added suzuki_hironobu as reviewer
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