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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1vHOhM-0066jT-Qu
	for pgsql-general@arkaria.postgresql.org; Fri, 07 Nov 2025 15:48: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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1vHOhL-00FHTf-II
	for pgsql-general@arkaria.postgresql.org; Fri, 07 Nov 2025 15:48:23 +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 <adrian.klaver@aklaver.com>)
	id 1vHOhK-00FHTW-Nw
	for pgsql-general@lists.postgresql.org; Fri, 07 Nov 2025 15:48:23 +0000
Received: from fhigh-a4-smtp.messagingengine.com ([103.168.172.155])
	by makus.postgresql.org with smtp (Exim 4.96)
	(envelope-from <adrian.klaver@aklaver.com>)
	id 1vHOhJ-005vcx-09
	for pgsql-general@postgresql.org;
	Fri, 07 Nov 2025 15:48:21 +0000
Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41])
	by mailfhigh.phl.internal (Postfix) with ESMTP id DFFA21400219;
	Fri,  7 Nov 2025 10:48:19 -0500 (EST)
Received: from phl-mailfrontend-01 ([10.202.2.162])
  by phl-compute-01.internal (MEProxy); Fri, 07 Nov 2025 10:48:19 -0500
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h=
	cc:content-transfer-encoding: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=fm2; t=1762530499;
	 x=1762616899; bh=a5b+fVyh77ZD/fFOSuNXus0wjc2oBu3Fch0W0KEmOgY=; b=
	gyfyE/K7FvJoFtyoGYs6SXczFnwZQjjHUzPxxxRLN300DOI65My/28NCJqBDRTqW
	8kSmHQ4EYpgr3pbUuCequbHRP1HJf5r19XCI9KvxpTwSzsiVweitwakPMqCD4vrn
	bFD3dugjrtV5EXY0taU5trFZTkc6d9LF050SZgVuSGnQ6xIfgiQeXJ6Gwu/UgQ9S
	VX2jznECrcc61i/qSZ3McV0Qwx8l/05VDZhKUDUFlJw/prp/8lIveQ3cD2A2d6jI
	nbp/3NDwsJQ95gznFyPMs1MoMk9WVHxgFtL3hppVUv0NBwV8sgNdKtjKgYmhzYFW
	xqurESWuBgKUltMGeqMS4g==
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=
	messagingengine.com; h=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:references
	:reply-to:subject:subject:to:to:x-me-proxy:x-me-sender
	:x-me-sender:x-sasl-enc; s=fm3; t=1762530499; x=1762616899; bh=a
	5b+fVyh77ZD/fFOSuNXus0wjc2oBu3Fch0W0KEmOgY=; b=bPHPrT3E7cKOTBrSe
	pLrf8dzqrK1jJAqxNEL0O9yLZR28aCtNK1TD7bMfnzii6159hHZmwRjXv2S0kcPn
	DjihtDa1vj2O8hnJovr9b2ojvuIctOYJnznIv4zYhLmQY92N7o+5+BVNo30HGn+W
	So302D1R89itXBlhjp9g7r60l550QbMSf4GGJT+0fv6gsgS74eOQlAzyfbvK3ajn
	lq6esfTw8mR+KtCypbEGV7t2SW9l+zQ0eAtURnp87SF9CmJzv47JemyMsLJjSF2z
	0K1bJ4B5JZdqGNVyb1977LatNmKkxIi6UpMTtkJHMAF9xHJoqifJBwf/monxNoC3
	83p2g==
X-ME-Sender: <xms:wxQOaUjRTcIT4QojgT-R5g1T1ibW1djzoTAw-xXyvrtnpNlYA3oHrQ>
    <xme:wxQOaZW4M8UkM8_T-ykiM_yZHl6F07mk8E_bJpHOfYiLgdFu7hNIYJSHnSTXyUnOX
    U4rlC27tTDZa5Uq_MiS0Y8808edoV98m8GHEhP6CCys6kVfI50>
X-ME-Received: <xmr:wxQOae1-Nt0LAAouoh4A8CXT_5aQ8IjHEyqz95I1rgurvcurxZejy-XAG47-l7uQN1hHuQWAaJV7KEJtkFPERVL5q2ahqg>
X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdduledttdehucetufdoteggodetrf
    dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu
    rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf
    gurhepkfffgggfuffvfhfhjggtgfesthejredttddvjeenucfhrhhomheptegurhhirghn
    ucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmqe
    enucggtffrrghtthgvrhhnpeeivdfhieehheegueeileejieettdejhedugeefleekvdel
    keehtdfgiefffeekudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrih
    hlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpdhnsggp
    rhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopegrshhhihhshh
    drmhhukhhhvghrjhgvvgesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhg
    vghnvghrrghlsehpohhsthhgrhgvshhqlhdrohhrgh
X-ME-Proxy: <xmx:wxQOaXGYTIeoxnyRK33r4RKIrLd8pcURlOd-uBQ8LCdvv1OLFkzWlg>
    <xmx:wxQOaUhkBydHG7-K3SQWJzZDNxyqty8f7eppxvQ1fPHybt8iCjfpYw>
    <xmx:wxQOaa-reEwf2fkwp5rOm-12RtPNCq1e014oZhsPS-0X3LAdeu7KIw>
    <xmx:wxQOaTrRuuovgOmiyj3IgyrOJhQLa1oPcaosraxDN87vM7cMByKg3A>
    <xmx:wxQOafrAo9OHY1e5DFcOe7rTh8ohqP1XLhK1F9WkqKSk37NN9n28s2k->
Feedback-ID: i76984098:Fastmail
Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri,
 7 Nov 2025 10:48:19 -0500 (EST)
Message-ID: <247d1944-abba-4365-ae57-5d5f9354353d@aklaver.com>
Date: Fri, 7 Nov 2025 07:48:18 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Enquiry about long-running queries
To: Ashish Mukherjee <ashish.mukherjee@gmail.com>,
 pgsql-general@postgresql.org
References: <CACgMzfwJQy8QmOFWdb3B1QNBchxC=4PjpBYMk4zgQz_WY8qmLQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CACgMzfwJQy8QmOFWdb3B1QNBchxC=4PjpBYMk4zgQz_WY8qmLQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/247d1944-abba-4365-ae57-5d5f9354353d%40aklaver.com>
Precedence: bulk

On 11/7/25 05:48, Ashish Mukherjee wrote:
> Hello,
> 
> I have a query like this showing up on my production database -

> The query when run from psql prompt finishes in a jiffy, so query

What client is the stuck query being run from?

> 
> Regards,
> Ashish


-- 
Adrian Klaver
adrian.klaver@aklaver.com