Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?

From:	David Geier <geidav(dot)pg(at)gmail(dot)com>
To:	Michael Paquier <michael(at)paquier(dot)xyz>, Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>
Cc:	Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Lukas Fittl <lukas(at)fittl(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:	Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?
Date:	2022-11-19 20:06:23
Message-ID:	d6e84dc8-75d1-4c3b-4b32-c4fcb7852275@gmail.com
Views:	Whole Thread | Raw Message | Download mbox | Resend email
Thread:	2020-06-12 23:28:10 from Andres Freund <andres(at)anarazel(dot)de> 📎  2020-06-13 03:53:01 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>  2021-03-13 00:34:16 from Thomas Munro <thomas(dot)munro(at)gmail(dot)com>  2022-07-01 08:23:01 from Lukas Fittl <lukas(at)fittl(dot)com> 📎   2022-07-01 17:26:39 from Andres Freund <andres(at)anarazel(dot)de>    2022-07-15 18:21:51 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>     2022-09-06 06:32:18 from Ibrar Ahmed <ibrar(dot)ahmad(at)gmail(dot)com>      2022-10-12 08:33:42 from Michael Paquier <michael(at)paquier(dot)xyz>       2022-11-19 20:05:28 from David Geier <geidav(dot)pg(at)gmail(dot)com>        2022-11-19 20:06:23 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎         2023-01-02 13:28:20 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎          2023-01-02 19:50:04 from Lukas Fittl <lukas(at)fittl(dot)com>           2023-01-03 08:38:20 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎            2023-01-04 10:15:05 from vignesh C <vignesh21(at)gmail(dot)com>             2023-01-04 12:02:05 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎              2023-01-13 19:55:47 from Andres Freund <andres(at)anarazel(dot)de>               2023-01-13 20:25:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                2023-01-13 20:59:33 from Andres Freund <andres(at)anarazel(dot)de>               2023-01-16 02:36:39 from Andres Freund <andres(at)anarazel(dot)de>               2023-01-17 13:46:12 from Robert Haas <robertmhaas(at)gmail(dot)com>                2023-01-17 16:47:58 from Andres Freund <andres(at)anarazel(dot)de> 📎                 2023-01-17 17:26:57 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                  2023-01-17 18:50:53 from Andres Freund <andres(at)anarazel(dot)de>                   2023-01-18 13:05:35 from David Geier <geidav(dot)pg(at)gmail(dot)com>                    2023-01-21 04:16:13 from Andres Freund <andres(at)anarazel(dot)de>                     2023-01-21 05:31:57 from Andres Freund <andres(at)anarazel(dot)de> 📎                      2023-01-21 19:03:03 from Andres Freund <andres(at)anarazel(dot)de>                      2023-01-23 17:52:44 from David Geier <geidav(dot)pg(at)gmail(dot)com>                       2023-01-23 20:30:06 from Andres Freund <andres(at)anarazel(dot)de>                        2023-01-26 11:21:13 from David Geier <geidav(dot)pg(at)gmail(dot)com>                   2023-01-21 00:40:32 from Andres Freund <andres(at)anarazel(dot)de> 📎                    2023-01-21 03:27:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>                     2023-01-21 03:54:56 from Andres Freund <andres(at)anarazel(dot)de>                    2023-01-21 04:50:37 from Justin Pryzby <pryzby(at)telsasoft(dot)com>                     2023-01-21 05:14:14 from Andres Freund <andres(at)anarazel(dot)de>                 2023-01-19 10:47:49 from David Geier <geidav(dot)pg(at)gmail(dot)com>                  2023-01-21 04:12:00 from Andres Freund <andres(at)anarazel(dot)de>                   2023-01-23 17:49:37 from David Geier <geidav(dot)pg(at)gmail(dot)com>                    2023-01-23 20:26:19 from Andres Freund <andres(at)anarazel(dot)de>                     2023-01-24 13:35:45 from David Geier <geidav(dot)pg(at)gmail(dot)com>              2023-01-14 06:58:44 from vignesh C <vignesh21(at)gmail(dot)com>              2023-01-16 20:34:42 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>               2023-01-16 20:39:04 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>                2023-01-18 12:52:05 from David Geier <geidav(dot)pg(at)gmail(dot)com>                 2023-01-20 06:43:00 from David Geier <geidav(dot)pg(at)gmail(dot)com>                  2023-01-20 11:13:09 from Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>                  2023-01-21 04:14:39 from Andres Freund <andres(at)anarazel(dot)de>                   2023-01-23 17:23:17 from David Geier <geidav(dot)pg(at)gmail(dot)com>                    2023-01-23 17:41:58 from Andres Freund <andres(at)anarazel(dot)de>                     2023-01-24 13:30:34 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                      2023-02-07 18:12:18 from Andres Freund <andres(at)anarazel(dot)de>                       2023-02-14 11:11:01 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                        2023-02-14 12:48:56 from David Geier <geidav(dot)pg(at)gmail(dot)com>                         2023-02-20 10:36:32 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                          2024-01-20 03:33:47 from vignesh C <vignesh21(at)gmail(dot)com>                           2024-02-01 18:44:05 from vignesh C <vignesh21(at)gmail(dot)com>                          2024-06-01 18:52:00 from Andres Freund <andres(at)anarazel(dot)de>                           2025-03-01 07:45:58 from Lukas Fittl <lukas(at)fittl(dot)com> 📎                            2025-07-17 00:48:00 from Andres Freund <andres(at)anarazel(dot)de>                             2025-07-27 19:50:54 from Lukas Fittl <lukas(at)fittl(dot)com> 📎                              2025-07-28 06:38:20 from Michael Paquier <michael(at)paquier(dot)xyz>                               2025-07-29 02:30:11 from Michael Paquier <michael(at)paquier(dot)xyz>                              2025-10-19 18:16:20 from Álvaro Herrera <alvherre(at)kurilemu(dot)de> 📎                               2025-10-20 19:59:51 from Robert Haas <robertmhaas(at)gmail(dot)com>                                2025-11-19 07:20:25 from David Geier <geidav(dot)pg(at)gmail(dot)com>                                 2025-12-03 09:50:15 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                                  2025-12-04 08:07:20 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                            2025-09-01 10:36:24 from David Geier <geidav(dot)pg(at)gmail(dot)com>                             2025-10-22 13:32:03 from Andres Freund <andres(at)anarazel(dot)de>                              2025-11-19 07:25:58 from David Geier <geidav(dot)pg(at)gmail(dot)com>                               2025-11-19 16:54:20 from Lukas Fittl <lukas(at)fittl(dot)com>                                2025-11-19 19:36:53 from Robert Haas <robertmhaas(at)gmail(dot)com>                                 2025-12-03 11:03:25 from David Geier <geidav(dot)pg(at)gmail(dot)com>                                  2025-12-03 14:15:00 from Robert Haas <robertmhaas(at)gmail(dot)com>                                   2025-12-04 21:21:29 from Hannu Krosing <hannuk(at)google(dot)com>                                    2025-12-05 07:46:38 from David Geier <geidav(dot)pg(at)gmail(dot)com>                                     2026-01-11 19:26:17 from David Geier <geidav(dot)pg(at)gmail(dot)com> 📎                                      2026-01-31 20:11:33 from Lukas Fittl <lukas(at)fittl(dot)com> 📎                                       2026-02-01 03:14:56 from Lukas Fittl <lukas(at)fittl(dot)com> 📎                                        2026-02-02 09:22:37 from Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>                                         2026-02-02 16:11:32 from Lukas Fittl <lukas(at)fittl(dot)com>                                          2026-02-04 10:06:50 from David Geier <geidav(dot)pg(at)gmail(dot)com>                                         2026-02-03 17:44:21 from Andres Freund <andres(at)anarazel(dot)de>                                          2026-02-04 10:09:32 from David Geier <geidav(dot)pg(at)gmail(dot)com>                                          2026-02-04 14:22:54 from Andres Freund <andres(at)anarazel(dot)de>                                           2026-02-05 09:23:15 from Ants Aasma <ants(dot)aasma(at)cybertec(dot)at>                                       2026-02-04 10:02:42 from David Geier <geidav(dot)pg(at)gmail(dot)com>          2023-01-16 17:37:23 from Andres Freund <andres(at)anarazel(dot)de>           2023-01-18 13:02:48 from David Geier <geidav(dot)pg(at)gmail(dot)com>            2023-01-21 04:29:10 from Andres Freund <andres(at)anarazel(dot)de>     2023-01-02 20:44:42 from Maciek Sakrejda <m(dot)sakrejda(at)gmail(dot)com>
Lists:	pgsql-hackers

Attachment	Content-Type	Size
0001-WIP-Change-instr_time-to-just-store-nanoseconds-v3.patch	text/x-patch	2.8 KB
0002-WIP-Use-cpu-reference-cycles-via-rdtsc-to-measure-v3.patch	text/x-patch	10.5 KB

In response to

• Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? at 2022-11-19 20:05:28 from David Geier

Responses

• Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? at 2023-01-02 13:28:20 from David Geier

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Andres Freund	2022-11-19 20:16:15	Re: ssl tests aren't concurrency safe due to get_free_port()
Previous Message	David Geier	2022-11-19 20:05:28	Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?