Reduce timing overhead of EXPLAIN ANALYZE using rdtsc

Edit
ID 5622
Title Reduce timing overhead of EXPLAIN ANALYZE using rdtsc
CI (CFBot) Summary
Stats (from CFBot) Patch version: v28, Patch count: 1, First patch: +134−19, All patches: +134−19
Tags Performance
Created 2025-03-01 07:48:09
Last modified 2026-04-08 01:25:59 (5 days ago)
Latest email 2026-04-09 16:02:28 (3 days ago)
Status
PG19-Final (2026-03-01 – 2026-04-09): Committed
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
PG19-2 (2025-09-01 – 2025-09-30): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
Target version
Authors Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav)
Reviewers Become reviewer
Committer Andres Freund (andresfreund)
Links
Emails
Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?
First at 2020-06-12 23:28:10 by Andres Freund <andres at anarazel.de>
Latest at 2026-04-09 16:02:28 by Andres Freund <andres at anarazel.de>
Latest attachment (v26a-0001-instrumentation-Show-additional-TSC-clock-sourc.patch) at 2026-04-09 16:02:28 from Andres Freund <andres at anarazel.de>
    Attachment (v26a-0001-instrumentation-Show-additional-TSC-clock-sourc.patch) at 2026-04-09 16:02:28 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v25-0001-instrumentation-Avoid-CPUID-0x15-0x16-for-Hyperv.patch) at 2026-04-09 04:36:48 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v24-0001-instrumentation-Show-additional-TSC-clock-source.patch) at 2026-04-08 19:25:54 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v23-0001-tsm_system_time-Avoid-repeated-calling-of-INSTR_.patch) at 2026-04-08 06:33:52 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v22-0001-instrumentation-Standardize-ticks-to-nanosecond-.patch) at 2026-04-07 07:04:51 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v21-0005-instrumentation-ARM-support-for-fast-time-measur.patch) at 2026-04-07 03:41:46 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v20-0005-instrumentation-ARM-support-for-fast-time-measur.patch) at 2026-04-06 11:25:36 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v19-0004-pg_test_timing-Also-test-RDTSC-RDTSCP-timing-and.patch) at 2026-04-06 01:47:51 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v18-0003-instrumentation-Use-Time-Stamp-Counter-TSC-on-x8.patch) at 2026-04-04 18:59:41 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v17-0005-instrumentation-ARM-support-for-fast-time-measur.patch) at 2026-04-04 09:21:14 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v16-0002-Allow-retrieving-x86-TSC-frequency-flags-from-CP.patch) at 2026-04-02 23:16:13 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v15-0001-Check-for-HAVE__CPUIDEX-and-HAVE__GET_CPUID_COUN.patch) at 2026-04-02 08:50:08 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v14-0005-pg_test_timing-Also-test-RDTSC-RDTSCP-timing-and.patch) at 2026-03-26 01:17:44 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v13-0001-Refactor-handling-of-x86-CPUID-instructions.patch) at 2026-03-24 07:16:07 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v12-0002-Check-for-HAVE__CPUIDEX-and-HAVE__GET_CPUID_COUN.patch) at 2026-03-22 18:13:11 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v11-0001-Refactor-handling-of-x86-CPUID-instructions.patch) at 2026-03-11 09:11:17 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v10-0002-pg_test_timing-Reduce-per-loop-overhead.patch) at 2026-03-03 10:29:06 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (nocfbot-architecture-macros-v1.patch) at 2026-02-25 11:15:49 from John Naylor <johncnaylorls at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Check-for-HAVE__CPUIDEX-and-HAVE__GET_CPUID_COUNT.patch) at 2026-02-25 10:00:35 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v8-0004-pg_test_timing-Also-test-RDTSC-RDTSCP-timing-and-.patch) at 2026-02-23 15:24:57 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v7-0003-Timing-Use-Time-Stamp-Counter-TSC-on-x86-64-for-f.patch) at 2026-02-13 04:11:12 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v6-0001-Check-for-HAVE__CPUIDEX-and-HAVE__GET_CPUID_COUNT.patch) at 2026-02-12 16:05:27 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v5-0001-Check-for-HAVE__CPUIDEX-and-HAVE__GET_CPUID_COUNT.patch) at 2026-02-01 03:14:56 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v4-0002-Use-time-stamp-counter-to-measure-time-on-Linux-x.patch) at 2026-01-31 20:11:33 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v3-0003-Add-GUC.patch) at 2026-01-11 19:26:17 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v13-0002-pg_test_timing-Also-test-fast-timing-and-report-time.patch) at 2025-12-04 08:07:20 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v12-0002-pg_test_timing-Also-test-fast-timing-and-report-time.patch) at 2025-12-03 09:50:15 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v12-0001-cpuidex-check-Support-detecting-newer-GCC-versio.patch) at 2025-10-19 18:16:20 from Álvaro Herrera <alvherre at kurilemu.de> (Patch: Yes)
    Attachment (v11-0003-pg_test_timing-Add-fast-flag-to-test-fast-timing.patch) at 2025-07-27 19:50:54 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v10-0001-instr_time-Add-INSTR_TIME_SET_SECONDS-INSTR_TIME.patch) at 2025-03-01 07:45:58 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v9-0001-instr_time-Add-INSTR_TIME_SET_SECONDS-INSTR_TIME_.patch) at 2023-02-20 10:36:32 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v8-0001-instr_time-Add-INSTR_TIME_SET_SECONDS-INSTR_TIME_.patch) at 2023-02-14 11:11:01 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v7-0001-instr_time-Add-INSTR_TIME_SET_SECONDS-INSTR_TIME_.patch) at 2023-01-24 13:30:34 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v9-0001-instr_time-Add-INSTR_TIME_SET_SECONDS-INSTR_TIME_.patch) at 2023-01-21 05:31:57 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v8-0001-Zero-initialize-instr_time-uses-causing-compiler-.patch) at 2023-01-21 00:40:32 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v7-0001-Zero-initialize-instr_time-uses-causing-compiler-.patch) at 2023-01-17 16:47:58 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (0001-Change-instr_time-to-just-store-nanoseconds-v6.patch) at 2023-01-04 12:02:05 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (0001-Change-instr_time-to-just-store-nanoseconds-v5.patch) at 2023-01-03 08:38:20 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (0001-Change-instr_time-to-just-store-nanoseconds-v4.patch) at 2023-01-02 13:28:20 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (0001-WIP-Change-instr_time-to-just-store-nanoseconds-v3.patch) at 2022-11-19 20:06:23 from David Geier <geidav.pg at gmail.com> (Patch: Yes)
    Attachment (v2-0002-WIP-Use-cpu-reference-cycles-via-rdtsc-to-measure.patch) at 2022-07-01 08:23:01 from Lukas Fittl <lukas at fittl.com> (Patch: Yes)
    Attachment (v1-0001-WIP-Change-instr_time-to-just-store-nanoseconds-t.patch) at 2020-06-12 23:28:10 from Andres Freund <andres at anarazel.de> (Patch: Yes)
History
When Who What
2026-04-08 01:25:59 Lukas Fittl (lfittl) Closed in commitfest PG19-Final with status: Committed
2026-04-08 01:25:59 Lukas Fittl (lfittl) Changed committer to andresfreund
2026-04-06 11:41:37 CFbot Patch does not need rebase anymore
2026-04-06 02:02:31 CFbot Patch needs rebase
2026-03-03 10:37:32 CFbot Patch does not need rebase anymore
2026-03-01 07:33:29 CFbot Patch needs rebase
2026-02-25 10:36:34 CFbot Patch does not need rebase anymore
2026-02-23 15:31:33 CFbot Patch needs rebase
2026-02-01 17:29:37 Lukas Fittl (lfittl) Moved from CF PG19-4 to CF PG19-Final
2026-01-11 19:33:27 CFbot Patch does not need rebase anymore
2026-01-10 09:11:23 CFbot Patch needs rebase
2025-12-02 23:09:50 Lukas Fittl (lfittl) Moved from CF PG19-3 to CF PG19-4
2025-10-19 18:34:28 CFbot Patch does not need rebase anymore
2025-10-19 18:24:33 Álvaro Herrera (alvherre) Moved from CF PG19-2 to CF PG19-3
2025-08-01 09:33:21 CFbot Patch needs rebase
2025-07-28 20:22:27 CFbot Patch does not need rebase anymore
2025-07-27 19:52:27 Lukas Fittl (lfittl) New status: Needs review
2025-07-27 19:51:45 Lukas Fittl (lfittl) Moved from CF 2025-03 to CF PG19-2
2025-03-11 04:14:43 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2025-03-06 13:19:42 CFbot Patch needs rebase
2025-03-01 07:48:36 Lukas Fittl (lfittl) Changed authors to Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav)
2025-03-01 07:48:10 Lukas Fittl (lfittl) Attached mail thread 20200612232810.f46nbqkdhbutzqdg@alap3.anarazel.de
2025-03-01 07:48:09 Lukas Fittl (lfittl) Created patch record
Edit