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 1tKZFg-009Rng-3Q for pgsql-general@arkaria.postgresql.org; Mon, 09 Dec 2024 08:36: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 1tKZFd-0054g7-H6 for pgsql-general@arkaria.postgresql.org; Mon, 09 Dec 2024 08:36: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 1tKZFb-0054a0-KT for pgsql-general@lists.postgresql.org; Mon, 09 Dec 2024 08:36:22 +0000 Received: from fout-a5-smtp.messagingengine.com ([103.168.172.148]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tKZFZ-001ozT-Mm for pgsql-general@lists.postgresql.org; Mon, 09 Dec 2024 08:36:19 +0000 Received: from phl-compute-05.internal (phl-compute-05.phl.internal [10.202.2.45]) by mailfout.phl.internal (Postfix) with ESMTP id 23F1C1383BF8; Mon, 9 Dec 2024 02:48:50 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-05.internal (MEProxy); Mon, 09 Dec 2024 02:48:50 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1733730530; x=1733816930; bh=Dw6iwHWuvU E2/+xocAcMetixpEiamliOIsGaJzrNrWE=; b=MTgGa6co60N9bwb1ZJuhJqjRPR 8SERFBWte+QvunkRDOZeuOBOmk39X/NlPRimkdCcomG81YOiVI+NQ2s7kLf9qa3T omX7eWN+nLS+vhkpkzDQSLnbEm/C2Pevs9EfB+11rQUhbryeQBx98cpuwejhH1Wj NokAMinI4Vq4ctqKsX5WHyTotbQkicVX78M9c2AIq0J79Gb4rEhB+UNJcO9mV0tT 5du2Macmu7nzCuRUBwWbV+mYxZ6QhCtl8cdkhmCDNbNZY27vcpZWvigvDdpbwioi OB9riUW28dcF1TNaE/PKK1Jar5Sxbu2KUbr1c/O1rnEAzFvd4k2bowkMtpew== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1733730530; x=1733816930; bh=Dw6iwHWuvUE2/+xocAcMetixpEiamliOIsG aJzrNrWE=; b=rD1gx02wCbeGoBDQUMNUh37/n8Vgp0uK8P7v8l2TwLZ3FJFCgJT 9c2/k7BXEMkRZO0Dud6DqZcGRivdk6lkgrIz/wanGX7jgF1m2Q2Ac/SWAwrj7uf5 H6z09ogY2ahJ55hTbCUPKDv1bQkPdYLJ1x6e4TqBuPQk7Xf2hOrZOMPfqa2LC+NE ANC7n2PkiM7lXn8Po9z3GZzKDYrKTfxQg1PT0SBqd3mHytboqnERD2EHVYrgmOGS eqodLGsdPW/0QCCWhTyzpZyusG5+JkouJQI6DISJfS6VXwgF2CktKjp5tbf+AH0V DroAjoRnPkmx2kwhS43egL7IhjMazVmP46w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrjeeggdduudefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnegfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhf gggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruc eomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteet gedvvdevueeiudduveekffevvedtudelheellefftddvgeefgedtjeettdeknecuffhomh grihhnpehpohhsthhgrhdrvghsnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghm pehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidpnhgspghrtg hpthhtohepfedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepvgifihgvsegvfihi vgdrnhgrmhgvpdhrtghpthhtoheptghoshhtrgesuggsthhunhgvrdgtohhmpdhrtghpth htohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdho rhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 9 Dec 2024 02:48:47 -0500 (EST) Date: Mon, 9 Dec 2024 16:48:26 +0900 From: Michael Paquier To: Erik Wienhold Cc: Costa Alexoglou , "pgsql-general@lists.postgresql.org" Subject: Re: Empty query_id in pg_stat_activity Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="WVQhfBP5f12/yeCE" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --WVQhfBP5f12/yeCE Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Dec 06, 2024 at 04:44:29PM +0100, Erik Wienhold wrote: > Another possibility is that the session just disabled compute_query_id: > https://postgr.es/m/472115375.225506.1683812791906%40office.mailbox.org Or possibly this uses a path where we're not aggressive enough the query ID while we should know it (there are slight cases where we could finish without one, like some PL contexts). If you could provide more details for the reproduction of the problem that does not involve benchbase, that would save time. -- Michael --WVQhfBP5f12/yeCE Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmdWoMoACgkQnvQgOdby QH05Jg//U6YJZnQCzh2rRwaAtO1CGjn+lwi9JfAw0lSCTJlC4ZOZwUmRnGL/yHsN vMAWu3e5//a4Fl2SALZmD+UfqIGmxb9BgNDsfohX7MPvsxXbq3nKa87C22OLDChF gR6NFBAWNu1ll6WTluAqMv+DWLrR/Y1p75YSzj6SvCNjnvStBL3XoXmggf2kQusd 0mmJOiVVH3WenoXM5tQ2J4O1uX4b+hpqhEyJQy+QbwoIyOBkfYmS+p7r75D78+di 2fXtPqJG6AITwPVeibtZnwjTX4lkRBTqk8wMPkGPg6gT35JdcccSqydgY5hKkU3X QSSeIoNNb5EvDYKGA9Ernh43ED2opMiAcIMtonWPSCf14U8Fw3W2ltDIZsaTt080 B21O18swPbos5BFe4RP8p7K92QyY5HZaS3cEP0mhys/CIKGNK+oWwSywWm6iI8aI 87vqzAGQYj+OQwU9Qj92Uh5bVavbFSng6pCGylX05PysRekkqcdW5fUd/l4P1hGq kySy2RZ4XsSEB3rkwRNJzmRQ8/BLCgtuSNggxUAdD3gRWyXIHEe0jPFYhesOqfJ4 +IZEN00VnKvDeRgib0VibUuOqtap0MaGLSxGQKoFm8Nli6BNMyPmrS46ZCnUm+5s y6lX65lRTjvjvtHPLxSxvG+NHF5DgX89kd+1CrX1UFukPiczJvY= =bgBZ -----END PGP SIGNATURE----- --WVQhfBP5f12/yeCE--