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 1u9MFT-000txC-1q for pgsql-general@arkaria.postgresql.org; Mon, 28 Apr 2025 11:02:07 +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 1u9MFQ-0008xK-Vm for pgsql-general@arkaria.postgresql.org; Mon, 28 Apr 2025 11:02:06 +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 1u9MFQ-0008xB-LJ for pgsql-general@lists.postgresql.org; Mon, 28 Apr 2025 11:02:05 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u9MFP-002PPC-29 for pgsql-general@lists.postgresql.org; Mon, 28 Apr 2025 11:02:04 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 53SB210P698411; Mon, 28 Apr 2025 07:02:01 -0400 From: Tom Lane To: Laurenz Albe cc: chandan Kumar , pgsql-general@lists.postgresql.org Subject: Re: Fwd: SQL transactions executing from VMSS In-reply-to: <74357b166a8e522d1a14aca7d763d0f0365df5da.camel@cybertec.at> References: <74357b166a8e522d1a14aca7d763d0f0365df5da.camel@cybertec.at> Comments: In-reply-to Laurenz Albe message dated "Mon, 28 Apr 2025 11:05:31 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <698409.1745838121.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Mon, 28 Apr 2025 07:02:01 -0400 Message-ID: <698410.1745838121@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Laurenz Albe writes: > I think that the answer you didn't get was as helpful as your problem de= scription: > "I got some statement that is slow, but I will neither tell you the st= atement nor > show you the execution plan. What is the cause of the slowness?" The OP did say that the execution plan was the same on both servers. That would appear to imply that the problem is in the client-side software stack. Unfortunately, this is not the place to come for expertise in VMSS (I for one have no idea what that even is). Suggest asking in whatever community exists around that software. regards, tom lane