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 1phOcx-0004xi-EO for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Mar 2023 05:45:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1phOcw-0000BJ-AI for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Mar 2023 05:45:42 +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 1phOcw-0008S3-1K for pgsql-hackers@lists.postgresql.org; Wed, 29 Mar 2023 05:45:42 +0000 Received: from mail-wr1-x435.google.com ([2a00:1450:4864:20::435]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1phOct-0002pu-IC for pgsql-hackers@lists.postgresql.org; Wed, 29 Mar 2023 05:45:41 +0000 Received: by mail-wr1-x435.google.com with SMTP id t4so9170771wra.7 for ; Tue, 28 Mar 2023 22:45:39 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; t=1680068738; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=iQIIsVdVCcVnFww7IYmOKDLjFVAhwHD8PyJzpjiRGwk=; b=RS77WIoug24VVQRGK2vF1AM8P7Vs/efYQCCvGjNpXz58rAq8aWoS0AfqWLoC+gEhwh QFM2LweQJDXC8MhZU4ed17I2Ue/cKZ0v8EYDE4DjIilvUCynecAnT+lT2Tad7om4F5OD EQ9lLM8McZ2pi8/psKPLjScaQi3XLbsUY52YzxeNBribf1Q18CVo/00FGzYjyw/ySXd9 ItP2E+DWseTQS3V2AIrluRlGlJqVm0pPwTpZy0dNJM9E7yuPBxnmUU59CjzDDEov5cTS +RCgsd15ShLsD/ggWYfQq7l8Gfdeettu4+onvwd06lORXWE+lnq4WGDDYqsKNvVGRt8E It1Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; t=1680068738; h=in-reply-to:from:content-language:references:cc:to:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=iQIIsVdVCcVnFww7IYmOKDLjFVAhwHD8PyJzpjiRGwk=; b=SjUK6jv+IKVyfGojBP1/AFiHXyNfPuWBU6dOxCwfJ8jkjVU9tbHyoTY2JoU/T7tFh2 Mcs3rAfYemdIQINLTGTHHGWRLjEJL6Drh8U1NrkcZdRIaf8lNdze2FUTVT/ufx+gy3BC 46PRtriWFY3fDqgjC3AIwId3qG8RcmkErOP5nlVMY9fWwUq8WBwLIPtpe96aJHWl1ntS trD8GeFlfLJuk0ndk3hUIAl/AgZmCgIDnUSwmrMEGGo1W+8GYTKXlQ/qLVawvJcdA+Ut 1Si+OIq2Akn9B5aqwfh0DomQAciP9lsK0bbd71TmrbjYpLTLsUiyooQaAN6z55GPNOyl Wz7w== X-Gm-Message-State: AAQBX9fjzectOUW4IeHgjRE69sETIQq5FhgVGMBTB02ipOK23MmvYq9k rXrH0g4DzcKtpdAIdluYO0i4VB6pUWS0cg== X-Google-Smtp-Source: AKy350YASfleuMq+RSJlGFlcSyVdoqua0t9w1K6imFLrwn7htVLbPOEcaNNFpDX/i8LtgVn72OEu4g== X-Received: by 2002:a5d:628b:0:b0:2ce:a835:83d4 with SMTP id k11-20020a5d628b000000b002cea83583d4mr696719wru.27.1680068737926; Tue, 28 Mar 2023 22:45:37 -0700 (PDT) Received: from [192.168.4.122] ([54.239.6.188]) by smtp.gmail.com with ESMTPSA id x8-20020a5d6508000000b002cea299a575sm29306657wru.101.2023.03.28.22.45.36 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 28 Mar 2023 22:45:37 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------EAivmM0uoKvOmzfVTOiyJEq0" Message-ID: <1bf875d6-43ed-83bd-62df-5355207b329e@gmail.com> Date: Wed, 29 Mar 2023 07:44:20 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.9.0 Subject: Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry To: Michael Paquier , Kyotaro Horiguchi Cc: melanieplageman@gmail.com, andres@anarazel.de, pgsql-hackers@lists.postgresql.org References: <32cd9a82-9221-f081-87d4-1f4fa6359a4d@gmail.com> <20230328.174326.1226788895063455868.horikyota.ntt@gmail.com> Content-Language: en-US From: "Drouvot, Bertrand" In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------EAivmM0uoKvOmzfVTOiyJEq0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hi, On 3/29/23 2:09 AM, Michael Paquier wrote: > On Tue, Mar 28, 2023 at 05:43:26PM +0900, Kyotaro Horiguchi wrote: >> No. Fine by me, except that "block read requests" seems to suggest >> kernel read() calls, maybe because it's not clear whether "block" >> refers to our buffer blocks or file blocks to me.. If it is generally >> clear, I'm fine with the proposal. > > Okay. Would somebody like to draft a patch? Please find a draft attached. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com --------------EAivmM0uoKvOmzfVTOiyJEq0 Content-Type: text/plain; charset=UTF-8; name="v3-0001-pg_stat_get_xact_blocks_fetched-and_hit-doc.patch" Content-Disposition: attachment; filename*0="v3-0001-pg_stat_get_xact_blocks_fetched-and_hit-doc.patch" Content-Transfer-Encoding: base64 ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNnbWwgYi9kb2Mvc3JjL3Nn bWwvbW9uaXRvcmluZy5zZ21sCmluZGV4IGM4MDlmZjFiYTQuLmFlNWQ5YTAyMjYgMTAwNjQ0 Ci0tLSBhL2RvYy9zcmMvc2dtbC9tb25pdG9yaW5nLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21s L21vbml0b3Jpbmcuc2dtbApAQCAtNTcyNCw4ICs1NzI0LDEwIEBAIFNFTEVDVCBwaWQsIHdh aXRfZXZlbnRfdHlwZSwgd2FpdF9ldmVudCBGUk9NIHBnX3N0YXRfYWN0aXZpdHkgV0hFUkUg d2FpdF9ldmVudCBpCiAgICAgICAgIDxyZXR1cm52YWx1ZT5iaWdpbnQ8L3JldHVybnZhbHVl PgogICAgICAgIDwvcGFyYT4KICAgICAgICA8cGFyYT4KLSAgICAgICAgUmV0dXJucyB0aGUg bnVtYmVyIG9mIGJ1ZmZlcnMgZmV0Y2hlZCBmb3IgdGFibGUgb3IgaW5kZXgsIGluIHRoZSBj dXJyZW50Ci0gICAgICAgIHRyYW5zYWN0aW9uLgorICAgICAgICBSZXR1cm5zIHRoZSBudW1i ZXIgb2YgYmxvY2sgcmVhZCByZXF1ZXN0cyBmb3IgdGFibGUgb3IgaW5kZXgsIGluIHRoZQor ICAgICAgICBjdXJyZW50IHRyYW5zYWN0aW9uLiBUaGlzIG51bWJlciBtaW51cyA8ZnVuY3Rp b24+CisgICAgICAgIHBnX3N0YXRfZ2V0X3hhY3RfYmxvY2tzX2hpdDwvZnVuY3Rpb24+IGdp dmVzIHRoZSBudW1iZXIgb2Yga2VybmVsCisgICAgICAgIDxmdW5jdGlvbj5yZWFkKCk8L2Z1 bmN0aW9uPiBjYWxscy4KICAgICAgICA8L3BhcmE+PC9lbnRyeT4KICAgICAgIDwvcm93Pgog CkBAIC01NzM4LDggKzU3NDAsOSBAQCBTRUxFQ1QgcGlkLCB3YWl0X2V2ZW50X3R5cGUsIHdh aXRfZXZlbnQgRlJPTSBwZ19zdGF0X2FjdGl2aXR5IFdIRVJFIHdhaXRfZXZlbnQgaQogICAg ICAgICA8cmV0dXJudmFsdWU+YmlnaW50PC9yZXR1cm52YWx1ZT4KICAgICAgICA8L3BhcmE+ CiAgICAgICAgPHBhcmE+Ci0gICAgICAgIFJldHVybnMgdGhlIG51bWJlciBvZiBidWZmZXIg aGl0cyBmb3IgdGFibGUgb3IgaW5kZXgsIGluIHRoZSBjdXJyZW50Ci0gICAgICAgIHRyYW5z YWN0aW9uLgorICAgICAgICBSZXR1cm5zIHRoZSBudW1iZXIgb2YgYmxvY2sgcmVhZCByZXF1 ZXN0cyBmb3IgdGFibGUgb3IgaW5kZXgsIGluIHRoZQorICAgICAgICBjdXJyZW50IHRyYW5z YWN0aW9uLCBmb3VuZCBpbiBjYWNoZSAobm90IHRyaWdnZXJpbmcga2VybmVsCisgICAgICAg IDxmdW5jdGlvbj5yZWFkKCk8L2Z1bmN0aW9uPiBjYWxscykuCiAgICAgICAgPC9wYXJhPjwv ZW50cnk+CiAgICAgICA8L3Jvdz4KIAo= --------------EAivmM0uoKvOmzfVTOiyJEq0--