Re: pg_stat_statements and "IN" conditions

From:	Dmitry Dolgov <9erthalion6(at)gmail(dot)com>
To:	vignesh C <vignesh21(at)gmail(dot)com>
Cc:	Sergei Kornilov <sk(at)zsrv(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Zhihong Yu <zyu(at)yugabyte(dot)com>, David Steele <david(at)pgmasters(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Greg Stark <stark(at)mit(dot)edu>, Pavel Trukhanov <pavel(dot)trukhanov(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject:	Re: pg_stat_statements and "IN" conditions
Date:	2023-01-29 12:22:42
Message-ID:	20230129122242.72idgrhuzwgycmwt@erthalion.local
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2020-08-12 16:19:02 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎  2020-11-18 16:04:32 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎   2020-12-09 03:37:40 from Chengxi Sun <sunchengxi(at)highgo(dot)com>    2020-12-09 18:49:44 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>   2020-12-26 10:46:35 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎    2020-12-26 16:53:28 from Zhihong Yu <zyu(at)yugabyte(dot)com>     2021-01-05 12:52:30 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎      2021-01-05 15:51:42 from Zhihong Yu <zyu(at)yugabyte(dot)com>       2021-03-18 13:38:09 from David Steele <david(at)pgmasters(dot)net>        2021-03-18 15:50:02 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>         2021-06-15 15:18:50 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎          2021-06-16 14:02:12 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎           2021-09-30 13:49:30 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎            2021-09-30 15:03:16 from Zhihong Yu <zyu(at)yugabyte(dot)com>             2021-09-30 15:09:57 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>              2022-01-04 23:02:43 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2022-01-05 04:37:33 from "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru>                2022-01-05 05:13:30 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>               2022-01-05 21:11:11 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                2022-03-10 16:38:37 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                 2022-03-10 17:11:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2022-03-10 17:32:08 from Robert Haas <robertmhaas(at)gmail(dot)com>                   2022-03-10 19:06:51 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                  2022-03-12 14:10:30 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                   2022-03-14 14:17:57 from Robert Haas <robertmhaas(at)gmail(dot)com>                    2022-03-14 14:57:34 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                     2022-03-14 15:02:16 from Robert Haas <robertmhaas(at)gmail(dot)com>                      2022-03-14 15:10:28 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                      2022-03-14 15:23:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                       2022-03-14 15:33:46 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                        2022-03-14 15:38:23 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                         2022-03-14 15:51:50 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                          2022-03-26 17:40:35 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                           2022-07-24 10:06:36 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                            2022-09-16 18:25:13 from Sergei Kornilov <sk(at)zsrv(dot)org>                             2022-09-24 14:07:14 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                              2022-09-24 23:59:39 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                               2023-01-27 14:45:29 from vignesh C <vignesh21(at)gmail(dot)com>                                2023-01-29 12:22:42 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                 2023-01-29 12:56:02 from Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>                                  2023-01-29 13:32:19 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                   2023-02-02 14:07:27 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                    2023-02-02 15:05:54 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                     2023-02-04 17:08:41 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                      2023-02-05 01:30:25 from Michael Paquier <michael(at)paquier(dot)xyz>                                       2023-02-05 11:33:46 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                        2023-02-05 16:02:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                         2023-02-05 19:56:00 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                          2023-02-07 20:14:52 from Sergei Kornilov <sk(at)zsrv(dot)org>                                           2023-02-09 13:30:34 from Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com>                                            2023-02-09 15:12:26 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                             2023-02-09 17:26:51 from Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>                                              2023-02-09 19:43:29 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                               2023-02-17 15:46:43 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                           2023-02-09 15:02:38 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                            2023-02-11 10:03:36 from David Geier <geidav(dot)pg(at)gmail(dot)com>                                             2023-02-11 10:47:07 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                              2023-02-11 12:08:20 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                               2023-02-15 07:51:56 from David Geier <geidav(dot)pg(at)gmail(dot)com>                                                2023-02-17 15:46:02 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                 2023-02-23 08:48:35 from David Geier <geidav(dot)pg(at)gmail(dot)com>                                                  2023-02-26 10:46:19 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                   2023-03-14 18:14:17 from "Gregory Stark (as CFM)" <stark(dot)cfm(at)gmail(dot)com>                                                    2023-03-14 19:04:32 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                     2023-03-19 12:27:34 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                      2023-07-04 04:46:11 from Nathan Bossart <nathandbossart(at)gmail(dot)com>                                                       2023-07-04 19:02:56 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                        2023-09-21 12:10:09 from Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>                                                         2023-10-03 06:24:06 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>                                                          2023-10-09 01:46:43 from Yasuo Honda <yasuo(dot)honda(at)gmail(dot)com>                                                        2023-10-13 08:07:00 from Michael Paquier <michael(at)paquier(dot)xyz>                                                         2023-10-13 13:35:19 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                          2023-10-17 08:15:41 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                           2023-10-26 00:08:42 from Michael Paquier <michael(at)paquier(dot)xyz>                                                            2023-10-27 15:02:44 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                             2023-10-31 09:03:07 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                              2024-01-06 15:34:54 from vignesh C <vignesh21(at)gmail(dot)com>                                                               2024-01-08 16:10:20 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                                2024-01-13 14:05:38 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                                 2024-01-22 06:33:26 from Peter Smith <smithpb2250(at)gmail(dot)com>                                                                  2024-01-22 16:11:23 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                                   2024-01-22 16:35:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                                                                    2024-01-22 17:07:27 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                                     2024-01-22 21:00:36 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                                      2024-03-23 07:13:44 from Yasuo Honda <yasuo(dot)honda(at)gmail(dot)com>                                                                       2024-03-23 18:20:26 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                                        2024-03-24 14:36:38 from Yasuo Honda <yasuo(dot)honda(at)gmail(dot)com>                                                                         2024-03-25 16:35:27 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                                          2024-03-26 07:21:46 from Yasuo Honda <yasuo(dot)honda(at)gmail(dot)com>                                                                           2024-03-26 20:59:16 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com>                                                                            2024-03-26 23:56:12 from Yasuo Honda <yasuo(dot)honda(at)gmail(dot)com>                                                                             2024-04-04 14:35:14 from Dmitry Dolgov <9erthalion6(at)gmail(dot)com> 📎                                                                              2024-04-15 09:09:29 from Sutou Kouhei <kou(at)clear-code(dot)com>                                                        2023-10-13 16:37:30 from Nathan Bossart <nathandbossart(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
v10-0001-Prevent-jumbling-of-every-element-in-ArrayExpr.patch	text/x-diff	34.0 KB

In response to

• Re: pg_stat_statements and "IN" conditions at 2023-01-27 14:45:29 from vignesh C

Responses

• Re: pg_stat_statements and "IN" conditions at 2023-01-29 12:56:02 from Marcos Pegoraro

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Tomas Vondra	2023-01-29 12:53:10	Re: lockup in parallel hash join on dikkop (freebsd 14.0-current)
Previous Message	Ankit Kumar Pandey	2023-01-29 12:05:15	Re: Todo: Teach planner to evaluate multiple windows in the optimal order