Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?
От
Andres Freund
Тема
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?
Дата
Msg-id
20230121053157.hsdemsvq7oqydfl6@awork3.anarazel.de
Ответ на
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? (Andres Freund)
Список
Дерево обсуждения
Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Pavel Stehule <pavel.stehule@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Maciek Sakrejda <m.sakrejda@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Ibrar Ahmed <ibrar.ahmad@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Michael Paquier <michael@paquier.xyz>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? vignesh C <vignesh21@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Tom Lane <tgl@sss.pgh.pa.us>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Robert Haas <robertmhaas@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Tom Lane <tgl@sss.pgh.pa.us>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Justin Pryzby <pryzby@telsasoft.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Tom Lane <tgl@sss.pgh.pa.us>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Pavel Stehule <pavel.stehule@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Robert Haas <robertmhaas@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Robert Haas <robertmhaas@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Hannu Krosing <hannuk@google.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Jakub Wartak <jakub.wartak@enterprisedb.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Jakub Wartak <jakub.wartak@enterprisedb.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Zsolt Parragi <zsolt.parragi@percona.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Zsolt Parragi <zsolt.parragi@percona.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? John Naylor <johncnaylorls@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andrew Dunstan <andrew@dunslane.net>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Haibo Yan <tristan.yim@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Tom Lane <tgl@sss.pgh.pa.us>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Tom Lane <tgl@sss.pgh.pa.us>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Zsolt Parragi <zsolt.parragi@percona.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Zsolt Parragi <zsolt.parragi@percona.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Hannu Krosing <hannuk@google.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andreas Karlsson <andreas@proxel.se>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Ants Aasma <ants.aasma@cybertec.at>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Andres Freund <andres@anarazel.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Lukas Fittl <lukas@fittl.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Álvaro Herrera <alvherre@kurilemu.de>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Robert Haas <robertmhaas@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? David Geier <geidav.pg@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Michael Paquier <michael@paquier.xyz>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Michael Paquier <michael@paquier.xyz>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? vignesh C <vignesh21@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? vignesh C <vignesh21@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? vignesh C <vignesh21@gmail.com>
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Maciek Sakrejda <m.sakrejda@gmail.com>
Hi, On 2023-01-20 20:16:13 -0800, Andres Freund wrote: > On 2023-01-18 14:05:35 +0100, David Geier wrote: > > @Andres: will you take care of these changes and provide me with an updated > > patch set so I can rebase the RDTSC changes? > > Otherwise, I can also apply Tom suggestions to your patch set and send out > > the complete patch set. > > I'm planning to push most of my changes soon, had hoped to get to it a bit > sooner, but ... I pushed the int64-ification commits. > If you have time to look at the pg_test_timing part, it'd be > appreciated. That's a it larger, and nobody looked at it yet. So I'm a bit > hesitant to push it. I haven't yet pushed the pg_test_timing (nor it's small prerequisite) patch. Thanks to Justin I've polished the pg_test_timing docs some. I've attached those two patches. Feel free to include them in your series if you want, then the CF entry (and thus cfbot) makes sense again... Greetings, Andres Freund
В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
От: Drouvot, Bertrand
Дата: