Re: RFC: Logging plan of the running query

From:	torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>
To:	pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc:	Atsushi Torikoshi <torikoshia(dot)tech(at)gmail(dot)com>, samimseih(at)gmail(dot)com, destrex271(at)gmail(dot)com, robertmhaas(at)gmail(dot)com
Subject:	Re: RFC: Logging plan of the running query
Date:	2026-02-16 15:10:32
Message-ID:	3791a2338d2bc66bd0c94cb49a7ed623@oss.nttdata.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2021-11-02 11:32:59 from Ekaterina Sokolova <e(dot)sokolova(at)postgrespro(dot)ru>  2021-11-03 12:48:51 from Daniel Gustafsson <daniel(at)yesql(dot)se>  2021-11-04 12:49:21 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>   2021-11-17 13:44:51 from Ekaterina Sokolova <e(dot)sokolova(at)postgrespro(dot)ru> 📎    2021-11-26 03:39:48 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎     2022-01-07 05:30:37 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎      2022-01-07 11:58:19 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎       2022-01-07 12:54:31 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>        2022-01-14 06:38:46 from Julien Rouhaud <rjuju123(at)gmail(dot)com>         2022-01-24 05:33:05 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎          2022-01-27 11:18:37 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>           2022-01-28 08:45:49 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎            2022-01-31 16:51:11 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>             2022-02-01 08:27:57 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>              2022-02-01 14:11:03 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>               2022-02-02 07:49:57 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                2022-02-02 08:04:21 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                 2022-02-02 12:59:12 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                  2022-02-03 08:09:07 from Robert Treat <rob(at)xzilla(dot)net>                  2022-02-07 16:13:44 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>                   2022-02-08 08:18:52 from Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>                    2022-02-08 15:12:50 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                     2022-02-21 17:39:16 from Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>                      2022-03-09 10:04:49 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                       2022-05-16 08:02:40 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                        2022-09-08 10:19:09 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                         2022-09-19 08:47:21 from Алена Рыбакина <lena(dot)ribackina(at)yandex(dot)ru> 📎                          2022-09-20 14:41:57 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                           2022-09-21 08:30:25 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>                            2022-09-22 14:12:16 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                             2022-09-23 09:43:19 from Alena Rybakina <lena(dot)ribackina(at)yandex(dot)ru>                           2022-12-06 18:41:01 from Andres Freund <andres(at)anarazel(dot)de>                            2022-12-08 05:10:32 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                             2023-06-02 17:51:22 from James Coleman <jtc331(at)gmail(dot)com> 📎                              2023-06-05 08:30:18 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                               2023-06-05 18:26:25 from James Coleman <jtc331(at)gmail(dot)com> 📎                                2023-06-12 04:07:34 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                 2023-06-12 15:52:01 from James Coleman <jtc331(at)gmail(dot)com>                                  2023-06-13 15:22:14 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                   2023-06-13 15:53:39 from James Coleman <jtc331(at)gmail(dot)com>                                    2023-06-14 16:48:52 from James Coleman <jtc331(at)gmail(dot)com>                                     2023-06-15 13:00:46 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                      2023-06-15 16:34:23 from James Coleman <jtc331(at)gmail(dot)com> 📎                                       2023-06-27 10:03:21 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                        2023-08-17 14:02:22 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                         2023-08-25 11:43:26 from James Coleman <jtc331(at)gmail(dot)com>                                          2023-08-26 12:03:26 from James Coleman <jtc331(at)gmail(dot)com>                                           2023-08-28 07:01:53 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                            2023-08-28 13:47:19 from James Coleman <jtc331(at)gmail(dot)com> 📎                                             2023-09-05 13:58:59 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                              2023-09-06 02:17:08 from James Coleman <jtc331(at)gmail(dot)com>                                               2023-09-07 06:09:12 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                2023-09-15 06:21:27 from "Lepikhov Andrei" <a(dot)lepikhov(at)postgrespro(dot)ru> 📎                                                 2023-09-19 13:39:59 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                  2023-09-20 05:39:13 from "Lepikhov Andrei" <a(dot)lepikhov(at)postgrespro(dot)ru>                                                   2023-09-25 07:21:31 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                    2023-09-25 09:49:18 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                     2023-09-28 02:04:09 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                      2023-09-28 02:32:46 from Andrey Lepikhov <a(dot)lepikhov(at)postgrespro(dot)ru>                                                2023-10-03 18:00:11 from James Coleman <jtc331(at)gmail(dot)com>                                                 2023-10-06 12:58:46 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                  2023-10-06 13:10:15 from James Coleman <jtc331(at)gmail(dot)com>                                                  2023-10-06 15:58:50 from Andres Freund <andres(at)anarazel(dot)de>                                                   2023-10-10 13:27:08 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                    2023-10-11 07:22:00 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                     2023-10-12 13:21:26 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                      2023-10-16 09:46:28 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                       2023-10-18 06:09:38 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                        2023-10-18 10:13:01 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                        2023-10-18 16:34:36 from James Coleman <jtc331(at)gmail(dot)com>                                                         2023-10-25 03:40:06 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                          2023-10-26 06:53:22 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                        2023-10-24 07:12:46 from Étienne BERSAC <etienne(dot)bersac(at)dalibo(dot)com>                                                         2023-10-24 12:30:49 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                          2023-10-27 07:06:31 from Étienne BERSAC <etienne(dot)bersac(at)dalibo(dot)com>                                                           2023-10-27 12:30:02 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                            2023-10-27 12:54:48 from Étienne BERSAC <etienne(dot)bersac(at)dalibo(dot)com>                                                             2023-11-03 14:01:14 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                              2023-11-06 06:32:12 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                               2023-11-09 06:33:36 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                2023-11-09 07:11:49 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                 2023-11-09 11:26:27 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                  2023-11-09 14:58:48 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                   2023-12-06 23:33:56 from Rafael Thofehrn Castro <rafaelthca(at)gmail(dot)com> 📎                                                                    2023-12-11 05:46:23 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                     2024-01-29 13:02:29 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                      2024-02-06 10:51:58 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                       2024-02-07 04:08:24 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                        2024-02-07 04:58:18 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                         2024-02-07 10:14:40 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                          2024-02-13 00:19:03 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                         2024-02-12 00:00:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                          2024-02-12 04:42:21 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                           2024-02-12 07:08:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                      2024-02-12 00:00:00 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                       2024-02-12 04:39:18 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                       2024-02-13 02:30:53 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                        2024-02-14 06:29:35 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                         2024-02-15 09:12:11 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                          2024-02-15 18:59:11 from Andres Freund <andres(at)anarazel(dot)de>                                                                           2024-02-16 14:42:36 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                           2024-02-20 04:53:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                            2024-02-22 00:54:57 from James Coleman <jtc331(at)gmail(dot)com>                                                                             2024-02-22 04:06:06 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                             2024-02-23 04:52:32 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                              2024-02-23 14:20:51 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                               2024-02-23 15:23:22 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                2024-02-24 13:56:41 from James Coleman <jtc331(at)gmail(dot)com>                                                                                 2024-02-25 11:30:37 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                                  2024-02-26 06:49:42 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                                   2024-02-26 07:55:04 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                                    2024-02-26 08:15:08 from Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>                                                                                  2024-02-26 08:26:44 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                   2024-02-26 13:54:41 from Julien Rouhaud <rjuju123(at)gmail(dot)com>                                                                                2024-02-26 12:01:45 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                 2024-02-28 06:18:32 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                  2024-03-02 15:46:36 from James Coleman <jtc331(at)gmail(dot)com>                                                                                   2024-03-04 18:19:45 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                    2024-03-13 05:28:42 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                     2024-03-13 19:33:02 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                      2024-03-26 02:34:47 from Andres Freund <andres(at)anarazel(dot)de>                                                                                       2024-10-28 13:05:03 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                        2025-02-03 12:46:29 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                         2025-03-08 15:42:21 from Akshat Jaimini <destrex271(at)gmail(dot)com>                                                                                          2025-03-10 05:10:27 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                           2025-03-21 12:40:00 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                            2025-03-31 18:51:28 from Sadeq Dousti <msdousti(at)gmail(dot)com>                                                                                             2025-04-03 05:34:27 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                                            2025-03-31 19:24:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                             2025-04-01 01:43:10 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                                              2025-04-01 12:32:04 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                               2025-04-01 13:57:44 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                                            2025-04-01 18:52:30 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                             2025-04-01 19:05:02 from Sami Imseih <samimseih(at)gmail(dot)com>                                                                                              2025-04-01 19:29:27 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                               2025-04-02 16:22:54 from Sami Imseih <samimseih(at)gmail(dot)com>                                                                                                2025-04-03 05:59:02 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                                                 2025-04-03 12:40:14 from Sami Imseih <samimseih(at)gmail(dot)com>                                                                                             2025-04-03 05:32:16 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                                              2025-04-03 14:10:26 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                               2025-04-05 06:13:47 from Atsushi Torikoshi <torikoshia(dot)tech(at)gmail(dot)com> 📎                                                                                                2025-04-24 12:48:57 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                 2025-04-27 23:55:31 from Hannu Krosing <hannuk(at)google(dot)com>                                                                                                  2025-04-30 09:53:40 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                                                   2025-05-20 13:17:59 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                    2025-05-22 15:07:50 from Robert Haas <robertmhaas(at)gmail(dot)com> 📎                                                                                                     2025-05-23 08:50:48 from Atsushi Torikoshi <torikoshia(dot)tech(at)gmail(dot)com>                                                                                                      2025-06-02 12:56:38 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                       2025-09-01 13:35:11 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                        2025-09-09 17:59:46 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                         2025-09-16 13:30:31 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                          2025-09-16 15:05:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                           2025-09-19 12:42:16 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                            2025-09-19 17:03:57 from Rafael Thofehrn Castro <rafaelthca(at)gmail(dot)com>                                                                                                             2025-09-20 03:21:39 from Atsushi Torikoshi <torikoshia(dot)tech(at)gmail(dot)com>                                                                                                            2025-09-24 16:34:47 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                             2025-10-01 09:11:23 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                              2025-10-16 20:15:54 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                               2025-10-20 12:15:03 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                                2025-11-18 20:19:46 from Akshat Jaimini <destrex271(at)gmail(dot)com>                                                                                                                 2025-11-19 03:43:22 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                                                                2025-11-19 17:23:01 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                                 2025-11-20 01:52:25 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                                                  2025-11-20 13:17:58 from Robert Haas <robertmhaas(at)gmail(dot)com>                                                                                                                   2025-11-25 12:43:46 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>                                                                                                                    2026-02-16 15:10:32 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com> 📎                                                                                     2024-03-14 01:02:47 from jian he <jian(dot)universality(at)gmail(dot)com>                                                                                      2024-03-18 05:39:48 from torikoshia <torikoshia(at)oss(dot)nttdata(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v52-0001-Add-function-to-log-the-plan-of-the-currently-ru.patch	text/x-diff	38.6 KB

In response to

• Re: RFC: Logging plan of the running query at 2025-11-25 12:43:46 from torikoshia

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Aditya Kamath	2026-02-16 15:10:38	RE: AIX support
Previous Message	Henson Choi	2026-02-16 15:09:04	Re: Row pattern recognition