Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLujQ-00HGTe-CB for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Jun 2024 01:12:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sLujO-00D4TM-LK for pgsql-hackers@arkaria.postgresql.org; Tue, 25 Jun 2024 01:12:22 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLujO-00D4TE-8g for pgsql-hackers@lists.postgresql.org; Tue, 25 Jun 2024 01:12:22 +0000 Received: from smtp-fw-52005.amazon.com ([52.119.213.156]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sLujL-002yVK-Kj for pgsql-hackers@lists.postgresql.org; Tue, 25 Jun 2024 01:12:21 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1719277940; x=1750813940; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=P5DgRmf1e8M8sgNBT/W/42ANZ008DS5EuYZa8RM8GmU=; b=nxJuQ0f5IogFzKRQetxe50iiHnWMMQ4bAc1xLr6Trw6Fx865ZqqdDOsH S5exAbQLbTwFAn7Y5hc3TD+1E+e2tGaR4rJMabOIp/9qetHwLRMicV5Z4 +GFt1/HQR0++BE9XcJnRYKtb6e2OYACdJvD83a42FkUNqifuTT7LNjugJ E=; X-IronPort-AV: E=Sophos;i="6.08,263,1712620800"; d="scan'208";a="662732379" Subject: Re: Track the amount of time waiting due to cost_delay Thread-Topic: Track the amount of time waiting due to cost_delay Received: from iad12-co-svc-p1-lb1-vlan3.amazon.com (HELO smtpout.prod.us-west-2.prod.farcaster.email.amazon.dev) ([10.43.8.6]) by smtp-border-fw-52005.iad7.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 25 Jun 2024 01:12:18 +0000 Received: from EX19MTAUWC002.ant.amazon.com [10.0.21.151:43516] by smtpin.naws.us-west-2.prod.farcaster.email.amazon.dev [10.0.7.1:2525] with esmtp (Farcaster) id fc45273f-0b30-41de-87f8-0edd69bc0aba; Tue, 25 Jun 2024 01:12:17 +0000 (UTC) X-Farcaster-Flow-ID: fc45273f-0b30-41de-87f8-0edd69bc0aba Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX19MTAUWC002.ant.amazon.com (10.250.64.143) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1258.34; Tue, 25 Jun 2024 01:12:17 +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_256_GCM_SHA384) id 15.2.1258.34; Tue, 25 Jun 2024 01:12:16 +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.1258.034; Tue, 25 Jun 2024 01:12:16 +0000 From: "Imseih (AWS), Sami" To: Bertrand Drouvot , Masahiko Sawada CC: "pgsql-hackers@lists.postgresql.org" , Robert Haas Thread-Index: AQHauvw6Ynk1Zt5L40Og+G5z08doqbHCJfWAgAAWKICAA19aAIAOM4uAgAMDmoCAAJ0JAA== Date: Tue, 25 Jun 2024 01:12:16 +0000 Message-ID: <42B4800A-D8D0-4734-930A-4D94D0EA90C7@amazon.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.178.14] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Pj4gMi4gdGhlIGxlYWRlciBiZWluZyBpbnRlcnJ1cHRlZCB3aGlsZSB3YWl0aW5nIGlzIGFsc28g YWxyZWFkeSBoYXBwZW5pbmcgb24gbWFzdGVyDQo+PiBkdWUgdG8gdGhlIHBnc3RhdF9wcm9ncmVz c19wYXJhbGxlbF9pbmNyX3BhcmFtKCkgY2FsbHMgaW4NCj4+IHBhcmFsbGVsX3ZhY3V1bV9wcm9j ZXNzX29uZV9pbmRleCgpICh0aGF0IGhhdmUgYmVlbiBhZGRlZCBpbg0KPj4gNDZlYmRmZTE2NCku IEl0IGhhcyBiZWVuIHRoZSBjYXNlICJvbmx5IiAzNiB0aW1lcyBkdXJpbmcgbXkgdGVzdCBjYXNl Lg0KDQo0NmViZGZlMTY0IHdpbGwgaW50ZXJydXB0IHRoZSBsZWFkZXJzIHNsZWVwIGV2ZXJ5IHRp bWUgYSBwYXJhbGxlbCB3b3JrZXJzIHJlcG9ydHMNCnByb2dyZXNzLCBhbmQgd2UgY3VycmVudGx5 IGRvbid0IGhhbmRsZSBpbnRlcnJ1cHRzIGJ5IHJlc3RhcnRpbmcgdGhlIHNsZWVwIHdpdGgNCnRo ZSByZW1haW5pbmcgdGltZS4gbmFub3NsZWVwIGRvZXMgcHJvdmlkZSB0aGUgYWJpbGl0eSB0byBy ZXN0YXJ0IHdpdGggdGhlIHJlbWFpbmluZw0KdGltZSBbMV0sIGJ1dCBJIGRvbid0IHRoaW5rIGl0 J3Mgd29ydGggdGhlIGVmZm9ydCB0byBlbnN1cmUgbW9yZSBhY2N1cmF0ZQ0KdmFjdXVtIGRlbGF5 cyBmb3IgdGhlIGxlYWRlciBwcm9jZXNzLiANCg0KDQo+IDEuIEhhdmluZyBhIHRpbWUgYmFzZWQg b25seSBhcHByb2FjaCB0byB0aHJvdHRsZSANCg0KSSBkbyBhZ3JlZSB3aXRoIGEgdGltZSBiYXNl ZCBhcHByb2FjaCBvdmVyYWxsLg0KDQoNCj4gMS4xKSB0aGUgbW9yZSBwYXJhbGxlbCB3b3JrZXJz IGlzIHVzZWQsIHRoZSBsZXNzIHRoZSBpbXBhY3Qgb2YgdGhlIGxlYWRlciBvbg0KPiB0aGUgdmFj dXVtIGluZGV4IHBoYXNlIGR1cmF0aW9uL3dvcmtsb2FkIGlzIChiZWNhdXNlIHRoZSByZXBhcnRp dGlvbiBpcyBkb25lDQo+IG9uIG1vcmUgcHJvY2Vzc2VzKS4NCg0KRGlkIHlvdSBtZWFuICIgYmVj YXVzZSB0aGUgdmFjdXVtIGlzIGRvbmUgb24gbW9yZSBwcm9jZXNzZXMiPyANCg0KV2hlbiBhIGxl YWRlciBpcyBvcGVyYXRpbmcgb24gYSBsYXJnZSBpbmRleChzKSBkdXJpbmcgdGhlIGVudGlyZXR5 DQpvZiB0aGUgdmFjdXVtIG9wZXJhdGlvbiwgd291bGRuJ3QgbW9yZSBwYXJhbGxlbCB3b3JrZXJz IGVuZCB1cA0KaW50ZXJydXB0aW5nIHRoZSBsZWFkZXIgbW9yZSBvZnRlbj8gVGhpcyBpcyB3aHkg SSB0aGluayByZXBvcnRpbmcgZXZlbiBtb3JlDQpvZnRlbiB0aGFuIDEgc2Vjb25kIChtb3JlIGJl bG93KSB3aWxsIGJlIGJldHRlci4NCg0KPiAzLiBBIDEgc2Vjb25kIHJlcG9ydGluZyAidGhyb3R0 bGluZyIgbG9va3MgYSByZWFzb25hYmxlIHRocmVzaG9sZCBhczoNCg0KPiAzLjEgdGhlIGlkZWEg aXMgdG8gaGF2ZSBhIHNpZ25pZmljYW50IGltcGFjdCB3aGVuIHRoZSBsZWFkZXIgY291bGQgaGF2 ZSBiZWVuDQo+IGludGVycnVwdGVkIHNheSBodW5kcmVkL3Rob3VzYW5kIHRpbWVzIHBlciBzZWNv bmQuDQoNCj4gMy4yIGl0IGRvZXMgbm90IG1ha2UgdGhhdCBtdWNoIHNlbnNlIGZvciBhbnkgdG9v bHMgdG8gc2FtcGxlIHBnX3N0YXRfcHJvZ3Jlc3NfdmFjdXVtDQo+IG11bHRpcGxlIHRpbWVzIHBl ciBzZWNvbmQgKHNvIGEgb25lIHNlY29uZCByZXBvcnRpbmcgZ3JhbnVsYXJpdHkgc2VlbXMgb2sp Lg0KDQpJIGZlZWwgMSBzZWNvbmQgbWF5IHN0aWxsIGJlIHRvbyBmcmVxdWVudC4gDQpXaGF0IGFi b3V0IDEwIHNlY29uZHMgKCBvciAzMCBzZWNvbmRzICk/IA0KSSB0aGluayB0aGlzIG1ldHJpYyBp biBwYXJ0aWN1bGFyIHdpbGwgYmUgbWFpbmx5IHVzZWZ1bCBmb3IgdmFjdXVtIHJ1bnMgdGhhdCBh cmUgDQpydW5uaW5nIGZvciBtaW51dGVzIG9yIG1vcmUsIG1ha2luZyByZXBvcnRpbmcgZXZlcnkg MTAgb3IgMzAgc2Vjb25kcyANCnN0aWxsIHVzZWZ1bC4NCg0KSXQganVzdCBvY2N1cnJlZCB0byBt ZSBhbHNvIHRoYXQgcGdzdGF0X3Byb2dyZXNzX3BhcmFsbGVsX2luY3JfcGFyYW0gDQpzaG91bGQg aGF2ZSBhIGNvZGUgY29tbWVudCB0aGF0IGl0IHdpbGwgaW50ZXJydXB0IGEgbGVhZGVyIHByb2Nl c3MgYW5kDQpjYXVzZSBhY3Rpdml0eSBzdWNoIGFzIGEgc2xlZXAgdG8gZW5kIGVhcmx5Lg0KDQoN Cg0KUmVnYXJkcywNCg0KU2FtaSBJbXNlaWgNCkFtYXpvbiBXZWIgU2VydmljZXMgKEFXUykNCg0K DQpbMV0gaHR0cHM6Ly9tYW43Lm9yZy9saW51eC9tYW4tcGFnZXMvbWFuMi9uYW5vc2xlZXAuMi5o dG1sDQoNCg0K