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 1umVq7-00GuIU-TQ for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Aug 2025 11:09:48 +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 1umVq6-0052AV-4w for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Aug 2025 11:09:46 +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 1umVq5-0052AN-Dc for pgsql-bugs@lists.postgresql.org; Thu, 14 Aug 2025 11:09:46 +0000 Received: from fhigh-a5-smtp.messagingengine.com ([103.168.172.156]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1umVq3-000Wly-0f for pgsql-bugs@lists.postgresql.org; Thu, 14 Aug 2025 11:09:44 +0000 Received: from phl-compute-07.internal (phl-compute-07.internal [10.202.2.47]) by mailfhigh.phl.internal (Postfix) with ESMTP id 452BC14000E4; Thu, 14 Aug 2025 07:09:42 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-07.internal (MEProxy); Thu, 14 Aug 2025 07:09:42 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm2; t=1755169782; x= 1755256182; bh=PF3bewBaTMWHEqb5hpa7GccknTRRQiSrjUFXjp/nPx4=; b=G 5pBwnjY1IpAw4tmyZKMyaAC4dL4sulvd0weNQbM8pSrbo0T5gLtXT9jmGgiRYT6f sXHpMT4EK8JSJRTUK8gk2okrNsqJNTw7drdR4iGPwGcoov6nHkeFmGzlmU4IjGT/ Byv088Hi91XcsiFP/U9KaNhqsGwUf5mFHrn/Z0o2mPS3RrhYcNvB1FdSuFruICFL KNPDD7bZGj9OWORyHiX+jEwvciz/Uow9wXIO/GZy4MqCSMchB7JWtZjoMbAgG2pu /VnsXgNwIwdQ8DMZEGyFqh2K1L/2oRqWxSUAPLPX70KhWLptR5UW866TH9ml/FAP YFdlclHe4UKp3xvadAJ5A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1755169782; x=1755256182; bh=P F3bewBaTMWHEqb5hpa7GccknTRRQiSrjUFXjp/nPx4=; b=TKPpY4D8JsIJP7E5O DUMOfwVDXJQRwl+YaFwFD/tVsA8/DjHDNmLKQmQe1mI09RGy+zwKAb2P3HXLY8nq 2YlA+Zg69DlN8aCdTxQfTgPyrTvh9gLdJgZxcxNvXLqXlKSR1O4SzxSASK4y7kpp xlS/wERRgTr3j+Xxu0N+cnsIZ6bLez9QKsTvnErv6amCPJGz0fzXPqAhGB6PPzoB s09dmGfvfmrzay5jIZVQ8g3XcZjD1kBRLxFQUNryRyGIWm6ybrmEhzyBwxM3xefJ oSTyZCaPj3ZBjfihOKUXGNPP5Wx2qUMUvNvGKtn+dffL0nnaVVzPPGtJKo3hNccw jQMLw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgddugedtledvucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucenucfjughrpeffhffvvefukfggtggugfgjsehtkeertd dttdejnecuhfhrohhmpemllhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgeqnecuggftrfgrthhtvghrnhepteeuvdehffekvefgueehve etveekgfegtddtueefueehuddutdfhfeffhfejfeffnecuffhomhgrihhnpegvnhhtvghr phhrihhsvggusgdrtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmh grihhlfhhrohhmpegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgdpnhgspghrtghp thhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepphhgshhqlhdqsghugh hssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopeiihhhouhgv nhgsihhnghesshhunhifohgurgdqvghvsgdrtghomh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 14 Aug 2025 07:09:41 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1755169778; bh=ixPTeK6gFaIBQLBGzq1U0vQNLSEh0IGUxT9FaatHc1w=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=VYeRjCM672TEqWX+J8s95e5s1e8ZtYdmpdhuWHPDASdZHM4/lZmHLxjn2NWEHh18a 5S4jHSiKKf/S1u60KrFrkCDl1pB9Z6G58NW0mZ/4lojF+m+S2LZm2jddcZ0w1vABWU IPTXqlRhu+DkNvkj8JlLwnsckY2RUlHpsSsbhjjzvt/tbAJ6wbrhZy2v1m6zyO4v5q skqZeso4yXOpbpz4PYLIRQI0cuS3GKIUmgvNMv2ypq6Z/DRxgYmonSmSfdWH3Ud6yC rkjKd2igregI6dx+ByT1nRuVWMDzFHXm8Rq16HYo7vzGkKpPdoV0BvUcNR83fHRwPV AyPSfBvLYEMLQ== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id C849290; Thu, 14 Aug 2025 13:09:38 +0200 (CEST) Date: Thu, 14 Aug 2025 13:09:38 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: zhouenbing Cc: pgsql-bugs@lists.postgresql.org Subject: Re: Empty query_id in pg_stat_activity Message-ID: <202508141109.o32twyl4dbjo@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <000001dc0c37$b4aa8180$1dff8480$@sunwoda-evb.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Aug-13, zhouenbing wrote: > I see that the Message ID is' ae6ef509-7bba-4d5b-aac4-82def6797e61@ewie.name > The email states that the bug with an empty query_id has been fixed in > versions 14.14/15.9/16.5/17.1. However, when I tested versions > 15.4/15.9/17.4 using the pebench-M=simple | extended tool, I still > encountered the issue of an empty query_id. This has caused some related > problems in tracking performance issues on Postgres. Is this a testing > problem or is the bug indeed present? I think you would have to show a concrete example of what you're talking about. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/