Logging plan of the currently running query

Log in to 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):
Stats (from CFBot) Unknown
Tags Monitoring
Created 2024-10-28 13:21:12
Last modified 2026-10-01 00:00:09 (1 month ago)
Latest email 2026-10-19 13:09:23 (1 month ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
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 20
Authors Atsushi Torikoshi (atsushitorikoshi)
Reviewers Hironobu Suzuki (suzuki_hironobu), Andrei Lepikhov (lepikhov), Sadeq Dousti (msdousti) Log in to 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 2026-10-19 13:09:23 by torikoshia <torikoshia at oss.nttdata.com>
Latest attachment (v61-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-10-19 13:09:23 from torikoshia <torikoshia at oss.nttdata.com>
    Attachment (v61-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-10-19 13:09:23 from torikoshia <torikoshia at oss.nttdata.com> (Patch: No)
    Attachment (v60-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-09-25 07:08:31 from torikoshia <torikoshia at oss.nttdata.com> (Patch: No)
    Attachment (v59-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-07-21 15:54:25 from torikoshia <torikoshia at oss.nttdata.com> (Patch: No)
    Attachment (v58-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-07-06 06:21:44 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v57-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-07-01 13:09:52 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v56-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-06-24 12:56:17 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v55-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-06-15 13:26:32 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v54-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-06-08 06:08:13 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v53-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-03-16 15:14:06 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v52-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2026-02-16 15:10:32 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v51-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-11-20 01:52:25 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v50-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch) at 2025-10-20 12:15:03 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    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
2026-11-21 05:36:32 CFbot Patch needs rebase
2026-10-01 00:00:09 CFbot Moved from CF PG20-2 to CF PG20-3
2026-09-25 07:35:34 CFbot Patch does not need rebase anymore
2026-09-04 04:55:33 CFbot Patch needs rebase
2026-08-02 02:38:45 Atsushi Torikoshi (atsushitorikoshi) Changed targetversion to 20
2026-08-01 00:00:10 CFbot Moved from CF PG20-1 to CF PG20-2
2026-07-21 15:54:49 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2026-07-06 06:45:37 CFbot Patch does not need rebase anymore
2026-07-04 17:04:27 CFbot Patch needs rebase
2026-07-02 11:26:28 Andrei Lepikhov (lepikhov) Added lepikhov as reviewer
2026-06-25 02:17:37 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
2026-06-24 12:57:35 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2026-06-24 01:47:20 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
2026-06-08 06:42:48 CFbot Patch does not need rebase anymore
2026-06-04 13:44:14 Atsushi Torikoshi (atsushitorikoshi) Changed targetversion to 19
2026-04-12 15:10:55 Akshat Jaimini (akshatj) Removed akshatj from reviewers
2026-04-10 00:00:05 CFbot Moved from CF PG19-Final to CF PG20-1
2026-04-07 07:16:28 CFbot Patch needs rebase
2026-03-16 15:31:39 CFbot Patch does not need rebase anymore
2026-03-07 15:47:27 CFbot Patch needs rebase
2026-02-16 08:10:33 Atsushi Torikoshi (atsushitorikoshi) Moved from CF PG19-4 to CF PG19-Final
2025-12-07 00:56:23 Atsushi Torikoshi (atsushitorikoshi) Moved from CF PG19-3 to CF PG19-4
2025-11-19 03:45:10 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2025-11-18 20:19:56 Akshat Jaimini (akshatj) New status: Waiting on Author
2025-11-18 20:19:46 Akshat Jaimini (akshatj) Posted comment with messageid <176349718657.1015.12677520994128141938.pgcf@coridan.postgresql.org>
2025-10-20 12:42:54 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2025-10-20 12:37:28 CFbot Patch does not need rebase anymore
2025-10-17 04:25:58 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
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
Log in to edit