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 1qZYK0-005qNS-6B for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Aug 2023 15:02:00 +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 1qZYJy-003oen-Qc for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Aug 2023 15:01:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZYJy-003oec-Fx for pgsql-hackers@lists.postgresql.org; Fri, 25 Aug 2023 15:01:58 +0000 Received: from smtp-fw-9106.amazon.com ([207.171.188.206]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZYJt-000zWf-Fj for pgsql-hackers@postgresql.org; Fri, 25 Aug 2023 15:01:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1692975713; x=1724511713; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=wJs75XefwCp7Dvhzy+s4v86niBcDm21s1hZgbZgWhpk=; b=HY4D1MF/Q9wKxa7ZXzdJwVn4izeZAxJ1Rbe11kOhMNDCFw5ejkfT4Phq oqjzVmVxFSwt4UJnChnx5Vq1YVM52rIxJeeAIKAA69XJNcsXZuhF+0s9n jXzlZAxf9b+tpJFRrYR4oGW/kr8vkxPK/GbqSc0d7WAPRnt0OyOGgspyd k=; X-IronPort-AV: E=Sophos;i="6.02,201,1688428800"; d="scan'208";a="667908272" Subject: Re: pg_stat_get_backend_subxact() and backend IDs? Thread-Topic: pg_stat_get_backend_subxact() and backend IDs? Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-iad-1a-m6i4x-96feee09.us-east-1.amazon.com) ([10.25.36.210]) by smtp-border-fw-9106.sea19.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 25 Aug 2023 15:01:47 +0000 Received: from EX19MTAUWC002.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan2.iad.amazon.com [10.40.163.34]) by email-inbound-relay-iad-1a-m6i4x-96feee09.us-east-1.amazon.com (Postfix) with ESMTPS id 51D4D477B7; Fri, 25 Aug 2023 15:01:45 +0000 (UTC) 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_256_GCM_SHA384) id 15.2.1118.30; Fri, 25 Aug 2023 15:01:41 +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.37; Fri, 25 Aug 2023 15:01:41 +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.037; Fri, 25 Aug 2023 15:01:41 +0000 From: "Imseih (AWS), Sami" To: Ian Lawrence Barwick , Nathan Bossart CC: pgsql-hackers , "robertmhaas@gmail.com" Thread-Index: AQHZ1imd2HrHmnsqrEWCShMGaopqRq/4ugUAgAAFeACAAOGggIAAiuIAgACd9gA= Date: Fri, 25 Aug 2023 15:01:40 +0000 Message-ID: <520F48E5-CFE9-45AC-AF81-FC4C63C3A5D2@amazon.com> References: <20230824023206.GA1128857@nathanxps13.lan> <20230824025140.GB1128857@nathanxps13.lan> <20230824161913.GA1394441@nathanxps13.lan> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.179.12] Content-Type: text/plain; charset="utf-8" Content-ID: <3119BBB9F2B7F0418FD608FFD0C28260@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 SSB0ZXN0ZWQgdGhlIHBhdGNoIGFuZCBpdCBkb2VzIHRoZSBjb3JyZWN0IHRoaW5nLg0KDQpJIGhh dmUgYSBmZXcgY29tbWVudHM6DQoNCjEvIGNhc3QgdGhlIHJldHVybiBvZiBic2VhcmNoLiBUaGlz IHdhcyBkb25lIHByZXZpb3VzbHkgYW5kIGlzIHRoZSBjb21tb24NCmNvbnZlbnRpb24gaW4gdGhl IGNvZGUuDQoNClNvDQoNCisgICAgICAgcmV0dXJuIGJzZWFyY2goJmtleSwgbG9jYWxCYWNrZW5k U3RhdHVzVGFibGUsIGxvY2FsTnVtQmFja2VuZHMsDQorICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIHNpemVvZihMb2NhbFBnQmFja2VuZFN0YXR1cyksIGNtcF9sYmVzdGF0dXMpOw0K DQpTaG91bGQgYmUNCg0KKyAgICAgICByZXR1cm4gKExvY2FsUGdCYWNrZW5kU3RhdHVzICopIGJz ZWFyY2goJmtleSwgbG9jYWxCYWNrZW5kU3RhdHVzVGFibGUsIGxvY2FsTnVtQmFja2VuZHMsDQor ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHNpemVvZihMb2NhbFBnQmFja2VuZFN0 YXR1cyksIGNtcF9sYmVzdGF0dXMpOw0KDQoyLyBUaGlzIHdpbGwgcHJvYmFibHkgYmUgYSBnb29k IHRpbWUgdG8gdXBkYXRlIHRoZSBkb2NzIGZvciBwZ19zdGF0X2dldF9iYWNrZW5kX3N1YnhhY3Qg WzFdDQp0byBjYWxsIG91dCB0aGF0ICJzdWJ4YWN0X2NvdW50IiB3aWxsICJvbmx5IGluY3JlYXNl IGlmIGEgdHJhbnNhY3Rpb24gaXMgcGVyZm9ybWluZyB3cml0ZXMiLiBBbHNvIHRvIGxpbmsNCnRo ZSByZWFkZXIgdG8gdGhlIHN1YnRyYW5zYWN0aW9ucyBkb2MgWzJdLg0KDQoNCjEuIGh0dHBzOi8v d3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTYvbW9uaXRvcmluZy1zdGF0cy5odG1sI1dBSVQtRVZF TlQtVElNRU9VVC1UQUJMRQ0KMi4gaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNi9z dWJ4YWN0cy5odG1sDQoNCg0KUmVnYXJkcywNCg0KU2FtaSBJbXNlaWgNCkFtYXpvbiBXZWIgU2Vy dmljZXMgKEFXUykNCg0K