Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pK102-0001ji-0u for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Jan 2023 17:52:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pK100-0005dJ-OP for pgsql-hackers@arkaria.postgresql.org; Mon, 23 Jan 2023 17:52:52 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pK100-0005d1-Dc for pgsql-hackers@lists.postgresql.org; Mon, 23 Jan 2023 17:52:52 +0000 Received: from mail-qt1-x834.google.com ([2607:f8b0:4864:20::834]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pK0zx-0004PE-Vk for pgsql-hackers@postgresql.org; Mon, 23 Jan 2023 17:52:51 +0000 Received: by mail-qt1-x834.google.com with SMTP id o5so10273258qtr.11 for ; Mon, 23 Jan 2023 09:52:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=LULIB1p2Ltql5NhaRzh/vf/iqFMmTLMnNoiRbWSSUcg=; b=jXXIkapwISYBepKXpzmqwnDgGOE5vcqvHF8Ng5fK9353Vq12PrZ18Oz5aZP3o1ugNi M5lySpy0/f4rwKIRDm6IgTYl9OnWtzcR/mC4AQJXfV+BZKUicPpq5KO/RurGO9eB7BO6 YK6EB1ofHuToeMqz2FtUlXjedr70ZFxze0OZKCZpAItcKLyePHtqFspxzm39pHwWzamh i1Pby4TPFM6m40F89KPmgcOWOBEPu5F9wOCjjFX0VviZALPBklUOVodHrT/Fz4nRVmCa Im3CX8/DKRioVan5amLfPLG/lOtQYG3ybCsqexJTCwD/X7PHrRpZJo4cKXTRdJQrptfz Os8Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=LULIB1p2Ltql5NhaRzh/vf/iqFMmTLMnNoiRbWSSUcg=; b=sWQBWalkSW4l9F80FbHxN0PG7Hh4zJh5TkbVBWGkF51qoLVIjYtgbtQPNz6tzI0P3j Co3HaFsfx1kVGL8bUrkKIyuln6ISSSZ/VDR7wJreuaKy3DsW+xnaR1FaOtqXtY/C2QxX NNArpxMgEfTHCeU2nHPqtBOtaAz1+Tom/abWDWsrSBVIaa2JxbjVqQzJIO16Yw22Uy4k MR7rKrRg9AoCy6T05h7SFMyAoXGCezIVpnPpxLRjcQ0Ow0+dEBzoakWYFlxAQC8CzuKW XK6hofHSl+HOO7Ig0g5RFLlXm7O6zcp0ZMTsvIabJNFc1uTXFHhwVTMc3+qJRaKNmuD0 3n9w== X-Gm-Message-State: AFqh2kq+Ma87s9YwruRas+mXcY46NRoibIYk3zroUXIYfsJgg8V2cEl5 3Hq0sHw55ICxb+9mE3gZSIQ= X-Google-Smtp-Source: AMrXdXsXpb2zA8Mubarn06OQb4zr/3cHPy3Q6YuXJfao6mGD6bLW/englM0WaFjnmZfgIH/CjYx+9A== X-Received: by 2002:ac8:5513:0:b0:3a7:f599:1d2c with SMTP id j19-20020ac85513000000b003a7f5991d2cmr34101730qtq.63.1674496369097; Mon, 23 Jan 2023 09:52:49 -0800 (PST) Received: from [172.16.209.129] (vip-148-139-0-229.cust.service-now.com. [148.139.0.229]) by smtp.gmail.com with ESMTPSA id hg20-20020a05622a611400b003a81eef14efsm25097135qtb.45.2023.01.23.09.52.46 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 23 Jan 2023 09:52:48 -0800 (PST) Message-ID: <7c5f2170-f99d-5cd2-cb80-375155107ca7@gmail.com> Date: Mon, 23 Jan 2023 18:52:44 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? Content-Language: en-US To: Andres Freund Cc: Tom Lane , Robert Haas , vignesh C , Lukas Fittl , Michael Paquier , Ibrar Ahmed , Maciek Sakrejda , pgsql-hackers@postgresql.org References: <20230113195547.k4nlrmawpijqwlsa@awork3.anarazel.de> <20230117164758.gx4uuzhk5grw7zea@awork3.anarazel.de> <3044621.1673976417@sss.pgh.pa.us> <20230117185053.owqxw4ebp5ny6zhd@awork3.anarazel.de> <51876d9a-6812-24b6-57ab-a555e85afb6b@gmail.com> <20230121041613.xhjfzk7iobhpqm3u@awork3.anarazel.de> <20230121053157.hsdemsvq7oqydfl6@awork3.anarazel.de> From: David Geier In-Reply-To: <20230121053157.hsdemsvq7oqydfl6@awork3.anarazel.de> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 1/21/23 06:31, Andres Freund wrote: > I pushed the int64-ification commits. Great. I started rebasing. One thing I was wondering about: why did you chose to use a signed instead of an unsigned 64-bit integer for the ticks? >> 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. > > 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... I'll include them in my new patch set and also have a careful look at them. -- David Geier (ServiceNow)