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 1paHGl-00021K-5R for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Mar 2023 14:29:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1paHGi-0001TT-Ux for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Mar 2023 14:29:20 +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 1paHGi-0001TK-IR for pgsql-hackers@lists.postgresql.org; Thu, 09 Mar 2023 14:29:20 +0000 Received: from smtp-fw-9103.amazon.com ([207.171.188.200]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1paHGb-0006Ne-8T for pgsql-hackers@postgresql.org; Thu, 09 Mar 2023 14:29:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1678372153; x=1709908153; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=Ey7x9h8zBlot06brpr4tRPKwGunrtj6U2BK+NCdrt5k=; b=mSrlZtOLBmA48aa/ff5yidAHR0qgJhXUF3wXZxjrOrhJlWm8J+MV82lf jdI8KvaJGd4dy4Zep8NDLznePuO9/2NDjcGpinOc9uD6t0VjDjlNhAxwp L+aKSMyP2EVRBSPWsPvhUUpJhUSSPi4dG0mdEegxzdeHJHrlH5RvUl78T 0=; X-IronPort-AV: E=Sophos;i="5.98,246,1673913600"; d="scan'208";a="1111003680" Subject: Re: Track IO times in pg_stat_io Thread-Topic: Track IO times in pg_stat_io Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO email-inbound-relay-iad-1d-m6i4x-00fceed5.us-east-1.amazon.com) ([10.25.36.214]) by smtp-border-fw-9103.sea19.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 09 Mar 2023 14:28:45 +0000 Received: from EX13MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1d-m6i4x-00fceed5.us-east-1.amazon.com (Postfix) with ESMTPS id 756EBA0574; Thu, 9 Mar 2023 14:28:42 +0000 (UTC) Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX13MTAUWB001.ant.amazon.com (10.43.161.207) with Microsoft SMTP Server (TLS) id 15.0.1497.45; Thu, 9 Mar 2023 14:28:38 +0000 Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX19D013UWA001.ant.amazon.com (10.13.138.253) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1118.24; Thu, 9 Mar 2023 14:28:38 +0000 Received: from EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964]) by EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964%5]) with mapi id 15.02.1118.024; Thu, 9 Mar 2023 14:28:38 +0000 From: "Imseih (AWS), Sami" To: "Drouvot, Bertrand" , Andres Freund , Melanie Plageman CC: Pg Hackers , Maciek Sakrejda , Justin Pryzby , "smilingsamay@gmail.com" , Kyotaro Horiguchi , Lukas Fittl , Magnus Hagander , Alvaro Herrera Thread-Index: AQHZS1oQ8bMB+Guv20+51kSZgbjnwK7t+yaAgAGH04CAAC+8AIAAATqAgAEfJACAAViCgA== Date: Thu, 9 Mar 2023 14:28:38 +0000 Message-ID: <3BCD168B-CFE2-453C-B3C1-4CC9EE7AB293@amazon.com> References: <20230307184751.jdokdy2xmx3xpaua@awork3.anarazel.de> <7b450eef-8717-ce4a-a9c8-ccab24ecd89a@gmail.com> In-Reply-To: <7b450eef-8717-ce4a-a9c8-ccab24ecd89a@gmail.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.95.191.54] Content-Type: text/plain; charset="utf-8" Content-ID: <9C28F1BCD33342498CD3BFCF719F9BA6@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiA+Pj4gTm93IEkndmUgYSBzZWNvbmQgdGhvdWdodDogd2hhdCBkbyB5b3UgdGhpbmsgYWJvdXQg cmVzZXR0aW5nIHRoZSByZWxhdGVkIG51bWJlcg0KPiA+Pj4gb2Ygb3BlcmF0aW9ucyBhbmQgKl90 aW1lIGZpZWxkcyB3aGVuIGVuYWJsaW5nL2Rpc2FibGluZyB0cmFja19pb190aW1pbmc/IChBbmQg bWVudGlvbiBpdCBpbiB0aGUgZG9jKS4NCj4gPj4+DQo+ID4+PiBUaGF0IHdheSBpdCdkIHByZXZl bnQgYmFkIGludGVycHJldGF0aW9uIChhdCBsZWFzdCBhcyBmYXIgdGhlIHRpbWUgcGVyIG9wZXJh dGlvbiBtZXRyaWNzIGFyZSBjb25jZXJuZWQpLg0KPiA+Pj4NCj4gPj4+IFRoaW5raW5nIHRoYXQg d2F5IGFzIHdlJ2QgbG9vc2Ugc29tZSAobW9zdD8pIGJlbmVmaXRzIG9mIHRoZSBuZXcgKl90aW1l IGNvbHVtbnMNCj4gPj4+IGlmIG9uZSBjYW4ndCAidHJ1c3QiIHRoZWlyIHJlbGF0ZWQgb3BlcmF0 aW9ucyBhbmQvb3Igb25lIGlzIG5vdCBzYW1wbGluZyBwZ19zdGF0X2lvIGZyZXF1ZW50bHkgZW5v dWdoICh0byBkaXNjYXJkIHRoZSBzYW1wbGVzDQo+ID4+PiB3aGVyZSB0aGUgdHJhY2tfaW9fdGlt aW5nIGNoYW5nZXMgb2NjdXIpLg0KPiA+Pj4NCj4gPj4+IEJ1dCB3ZWxsLCByZXNldHRpbmcgdGhl IG9wZXJhdGlvbnMgY291bGQgYWxzbyBsZWFkIHRvIGJhZCBpbnRlcnByZXRhdGlvbiBhYm91dCB0 aGUgb3BlcmF0aW9ucy4uLg0KPiA+Pj4NCj4gPj4+IE5vdCBzdXJlIGFib3V0IHdoaWNoIGFwcHJv YWNoIEkgbGlrZSB0aGUgbW9zdCB5ZXQsIHdoYXQgZG8geW91IHRoaW5rPw0KPiA+Pg0KPiA+PiBP aCwgdGhpcyBpcyBhbiBpbnRlcmVzdGluZyBpZGVhLiBJIHRoaW5rIHlvdSBhcmUgcmlnaHQgYWJv dXQgdGhlDQo+ID4+IHN5bmNocm9uaXphdGlvbiBpc3N1ZXMgbWFraW5nIHRoZSBzdGF0aXN0aWNz IHVudHJ1c3R3b3J0aHkgYW5kLCB0aHVzLA0KPiA+PiB1bnVzZWFibGUuDQo+ID4gDQo+ID4gTm8s IEkgZG9uJ3QgdGhpbmsgd2UgY2FuIGRvIHRoYXQuIEl0IGNhbiBiZSBlbmFibGVkIG9uIGEgcGVy LXNlc3Npb24gYmFzaXMuDQoNCj4gT2ggcmlnaHQuIFNvIGl0J3MgZXZlbiBsZXNzIGNsZWFyIHRv IG1lIHRvIGdldCBob3cgb25lIHdvdWxkIG1ha2UgdXNlIG9mIHRob3NlIG5ldyAqX3RpbWUgZmll bGRzLCBnaXZlbiB0aGF0Og0KDQo+IC0gcGdfc3RhdF9pbyBpcyAiZ2xvYmFsIiBhY3Jvc3MgYWxs IHNlc3Npb25zLiBTbywgZXZlbiBpZiBvbmUgc2Vzc2lvbiBpcyBkb2luZyBzb21lICJ0ZXN0aW5n IiBhbmQgbmVlZHMgdG8gdHVybiB0cmFja19pb190aW1pbmcgb24sIHRoZW4gaXQNCj4gaXMgZXZl biBub3Qgc3VyZSBpdCdzIG9ubHkgcmVmbGVjdGluZyBpdHMgb3duIHRlc3RpbmcgKGFzIG90aGVy IHNlc3Npb25zIG1heSBoYXZlIHR1cm5lZCBpdCBvbiB0b28pLg0KDQo+IC0gVGhlcmUgaXMgdGhl IHJpc2sgbWVudGlvbmVkIGFib3ZlIG9mIGJhZCBpbnRlcnByZXRhdGlvbnMgZm9yIHRoZSAidGlt ZSBwZXIgb3BlcmF0aW9uIiBtZXRyaWNzLg0KDQo+IC0gRXZlbiBpZiB0aGVyZSBpcyBmcmVxdWVu dCBlbm91Z2ggc2FtcGxpbmcgb2YgaXQgcGdfc3RhdF9pbywgb25lIGRvZXMgbm90IGtub3cgd2hp Y2ggc2FtcGxlcyBjb250YWluIHRyYWNrX2lvX3RpbWluZyBjaGFuZ2VzIChhdCB0aGUgY2x1c3Rl ciBvciBzZXNzaW9uIGxldmVsKS4NCg0KQXMgbG9uZyBhcyB0cmFja19pb190aW1pbmcgY2FuIGJl IHRvZ2dsZWQsIGJsa193cml0ZV90aW1lIGNvdWxkIGxlYWQgdG8gd3JvbmcgY29uY2x1c2lvbnMu DQpJIHRoaW5rIGl0IG1heSBiZSBoZWxwZnVsIHRvIHRyYWNrIHRoZSBibGtzX3JlYWQgd2hlbiB0 cmFja19pb190aW1pbmcgaXMgZW5hYmxlZA0KU2VwYXJhdGVseS4NCg0KYmxrc19yZWFkIHdpbGwg YmUgYXMgaXMgYW5kIGdpdmUgdGhlIG92ZXJhbGwgYmxrc19yZWFkLCB3aGlsZSBhIG5ldyBjb2x1 bW4NCmJsa3NfcmVhZF93aXRoX3RpbWluZyB3aWxsIG9ubHkgcmVwb3J0IG9uIGJsa3NfcmVhZCB3 aXRoIHRyYWNrX2lvX3RpbWluZyBlbmFibGVkLg0KDQpibGtzX3JlYWRfd2l0aF90aW1pbmcgc2hv dWxkIG5ldmVyIGJlIGxhcmdlciB0aGFuIGJsa3NfcmVhZC4NCg0KVGhpcyB3aWxsIHRoZW4gbWFr ZSB0aGUgYmxrc19yZWFkX3RpbWUgdmFsdWFibGUgaWYgaXQncyBsb29rZWQgYXQgd2l0aA0KdGhl IGJsa3NfcmVhZF93aXRoX3RpbWluZyBjb2x1bW4uDQoNCg0KUmVnYXJkcywNCg0KLS0gDQoNClNh bWkgSW1zZWloDQpBbWF6b24gV2ViIFNlcnZpY2VzIChBV1MpDQoNCg==