Logging plan of the currently running query

Edit
ID 5330
Title Logging plan of the currently running query
CI (CFBot) Summary
Stats (from CFBot) Patch version: v51, Patch count: 1, First patch: +645−34, All patches: +645−34
Topic Monitoring & Control
Tags Monitoring
Created 2024-10-28 13:21:12
Last modified 2025-12-07 00:56:23 (3 hours ago)
Latest email 2025-11-25 12:43:46 (1 week ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
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 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-11-25 12:43:46 by torikoshia <torikoshia at oss.nttdata.com>
Latest 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>
    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
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
Edit