Logging plan of the currently running query

Edit
Comment/Review
Change Status
ID 3142
Title Logging plan of the currently running query
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Monitoring & Control
Tags
Created 2021-05-31 02:19:04
Last modified 2023-06-06 06:47:56 (2 years ago)
Latest email 2025-06-02 12:56:38 (1 month ago)
Status
2023-01 (2023-01-01 - 2023-01-31): Withdrawn
2022-11 (2022-11-01 - 2022-11-30): Moved to different CF
2022-09 (2022-09-01 - 2022-09-30): Moved to different CF
2022-07 (2022-07-01 - 2022-07-31): Moved to different CF
2022-03 (2022-03-01 - 2022-03-31): Moved to different CF
2022-01 (2022-01-01 - 2022-01-31): Moved to different CF
2021-11 (2021-11-01 - 2021-11-30): Moved to different CF
2021-09 (2021-09-01 - 2021-09-30): Moved to different CF
2021-07 (2021-07-01 - 2021-07-31): Moved to different CF
Target version 16
Authors atsushi torikoshi (atorik)
Reviewers Fujii Masao (masaofujii), Ekaterina Sokolova (e.sokolova), Justin Pryzby (justinpryzby), Alena Rybakina (a.rybakina), James Coleman (jcole1989)Become reviewer
Committer
Links
Emails
RFC: Logging plan of the running query
First at 2021-05-12 11:24:04 by torikoshia <torikoshia at oss.nttdata.com>
Latest at 2021-11-16 11:48:27 by torikoshia <torikoshia at oss.nttdata.com>
Latest attachment (v13-0001-log-running-query-plan.patch) at 2021-11-15 14:00:12 from torikoshia <torikoshia at oss.nttdata.com>
    Attachment (v13-0001-log-running-query-plan.patch) at 2021-11-15 14:00:12 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v12-0001-log-running-query-plan.patch) at 2021-11-15 12:59:15 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v11-0001-log-running-query-plan.patch) at 2021-10-13 14:28:30 from Ekaterina Sokolova <e.sokolova at postgrespro.ru> (Patch: Yes)
    Attachment (v10-0001-log-running-query-plan.patch) at 2021-09-08 12:06:26 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v9-0001-log-running-query-plan.patch) at 2021-09-07 03:39:46 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v8-0001-log-running-query-plan.patch) at 2021-08-11 12:14:05 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v7-0001-log-running-query-plan.patch) at 2021-08-10 12:22:49 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v6-0001-log-running-query-plan.patch) at 2021-07-19 02:28:40 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v5-0001-log-running-query-plan.patch) at 2021-07-09 05:05:16 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v4-0001-log-running-query-plan.patch) at 2021-06-22 02:30:31 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v3-0001-log-running-query-plan.patch) at 2021-06-09 07:44:55 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v2-0001-log-running-query-plan.patch) at 2021-05-28 06:51:37 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
    Attachment (v1-0001-log-running-query-plan.patch) at 2021-05-12 11:24:04 from torikoshia <torikoshia at oss.nttdata.com> (Patch: Yes)
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
2023-06-06 06:47:56 Atsushi Torikoshi (atsushitorikoshi) Closed in commitfest 2023-01 with status: Withdrawn
2023-06-06 06:41:37 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2023-06-02 17:07:22 James Coleman (jcole1989) Added jcole1989 as reviewer
2023-01-31 14:28:43 Atsushi Torikoshi (atsushitorikoshi) Closed in commitfest 2023-01 with status: Withdrawn
2023-01-31 02:50:38 Fujii Masao (masaofujii) Removed masaofujii from committers
2022-12-08 14:10:21 Ian Barwick (barwick) Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-07 18:28:42 Andres Freund (andresfreund) New status: Waiting on Author
2022-10-12 07:10:39 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-09-27 11:37:54 Alena Rybakina (a.rybakina) Added a.rybakina as reviewer
2022-09-20 14:57:10 Atsushi Torikoshi (atsushitorikoshi) Detached mail thread 6ee42413-41db-91af-4391-614f6af39000@postgrespro.ru
2022-09-19 11:10:02 Alena Rybakina (a.rybakina) Attached mail thread 6ee42413-41db-91af-4391-614f6af39000@postgrespro.ru
2022-09-16 18:51:57 Alena Rybakina (a.rybakina) Removed a.rybakina from reviewers
2022-09-16 18:51:49 Alena Rybakina (a.rybakina) Added a.rybakina as reviewer
2022-08-01 17:29:06 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-05-17 13:19:39 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2022-04-09 02:16:05 Justin Pryzby (justinpryzby) Changed targetversion to 16
2022-04-09 01:55:15 Atsushi Torikoshi (atsushitorikoshi) New status: Waiting on Author
2022-03-30 18:46:38 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:23:51 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2022-01-31 04:40:47 Fujii Masao (masaofujii) Added masaofujii as committer
2022-01-24 06:28:32 Justin Pryzby (justinpryzby) New status: Needs review
2022-01-14 06:38:52 Julien Rouhaud (rjuju) New status: Waiting on Author
2021-12-02 21:36:20 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2021-11 with status: Moved to next CF
2021-11-26 05:07:42 Atsushi Torikoshi (atsushitorikoshi) Attached mail thread d68c3ae31672664876b22d2dcbb526d2@postgrespro.ru
2021-11-17 11:04:41 atsushi torikoshi (atorik) New status: Needs review
2021-11-15 19:29:45 Justin Pryzby (justinpryzby) Added justinpryzby as reviewer
2021-11-03 12:49:01 Daniel Gustafsson (d_gustafsson) New status: Waiting on Author
2021-10-13 14:06:07 Ekaterina Sokolova (e.sokolova) Added e.sokolova as reviewer
2021-10-06 13:15:33 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-09-08 13:23:52 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2021-08-25 05:03:20 Fujii Masao (masaofujii) New status: Waiting on Author
2021-08-11 13:19:49 Atsushi Torikoshi (atsushitorikoshi) New status: Needs review
2021-08-03 02:43:32 Masahiko Sawada (masahikosawada) New status: Waiting on Author
2021-08-03 02:42:29 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:42:26 Masahiko Sawada (masahikosawada) New status: Needs review
2021-07-18 15:12:22 Dongming Liu (inferyes) Removed inferyes from reviewers
2021-07-18 15:12:10 Dongming Liu (inferyes) Added inferyes as reviewer
2021-07-08 14:06:34 atsushi torikoshi (atorik) New status: Waiting on Author
2021-07-01 07:45:44 Fujii Masao (masaofujii) Added masaofujii as reviewer
2021-05-31 02:23:58 Atsushi Torikoshi (atsushitorikoshi) Changed authors to atsushi torikoshi (atorik)
2021-05-31 02:23:58 Atsushi Torikoshi (atsushitorikoshi) Changed targetversion to 15
2021-05-31 02:19:04 Atsushi Torikoshi (atsushitorikoshi) Attached mail thread cf8501bcd95ba4d727cbba886ba9eea8@oss.nttdata.com
2021-05-31 02:19:04 Atsushi Torikoshi (atsushitorikoshi) Created patch record
Edit
Comment/Review
Change Status