Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6Hgu-0003Ms-Ql for pgsql-performance@arkaria.postgresql.org; Wed, 21 Jul 2021 19:15:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6Hgt-0003oi-Po for pgsql-performance@arkaria.postgresql.org; Wed, 21 Jul 2021 19:15:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6Hgt-0003oX-Ej for pgsql-performance@lists.postgresql.org; Wed, 21 Jul 2021 19:15:35 +0000 Received: from mail-io1-xd2f.google.com ([2607:f8b0:4864:20::d2f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m6Hgq-00041L-5G for pgsql-performance@postgresql.org; Wed, 21 Jul 2021 19:15:35 +0000 Received: by mail-io1-xd2f.google.com with SMTP id u7so3598749ion.3 for ; Wed, 21 Jul 2021 12:15:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=bb5Nq+Hd7R1/yAQl/oUIqplUKGvEMgqMb3hplLHGdSQ=; b=SGuAV4VB15/lxRZEOCyh7eAdoW98A0Hek6PsmkrH3fpzkElRvKySbmzGw/pDYcvMoQ Isb1kcTiJE6w3CQ0Ql8xVwpS/PXrsSK8O0oxnicbJV5vEGtGtwu2V/a4ceLHKwjCtyiT hrFIXqzlJM3YLQ1xHaogjnK5NdJIokwseIKcb+Jt5ai8ngDEAL0ctYZqa9KTnAHGaDi4 ZpSsmZRKOGUnuvPagEhICRO50xq0FBmlEIXG+gne6knynJJ6ZwokceHBqntmxewuh/2e 94IUNEQG20Vso3uKPDy4uRrituWHNN2OSUX4Fwc7GFgGyEZXtDBIobdzA2NzBTXDlwVn eCag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=bb5Nq+Hd7R1/yAQl/oUIqplUKGvEMgqMb3hplLHGdSQ=; b=AxGS/5BDNY7NDxH5pcHdwzEkSwwCUJpIzaGSKnDb//j01yxYy2Eur4+qNt8mQ6f3Z1 DKpj/iZdXAhvRfRC8yC1vsL2U14GSNyIM9wlNZFkdfvNRLlFXWQPwfmmpnxe2dQSrw4/ rPUdsdhOMWrxrHBqU/wdaAyy8OVb5Zrn/cVUCbzr++7oNginZf3vzaY+uzfBtVEYH3xc wYiOjPV+WSBoe/nI+9A9H6PQ+jCRrnNwYn3spBy48a96n0jRPTlWspVbzAtflWIkilKf q8w2+E7yQuViCkyk2zn6h/7rtYPphVE/fK5AefnQZWQyx/Sa2X2Yy7tHAKtNyVLjCoWG nQqQ== X-Gm-Message-State: AOAM531r5fkhS+y7MKlF9W7miw0cuF669MbtBYOavW2lNadMYax0J8my +Xa31osi6eXOtQDRKLmfu5RLdg== X-Google-Smtp-Source: ABdhPJyyY+4aPScl1J//EfhoUFjr5rLdPeoJumZPtI9sXuXRlJCD+9DUheGT2iqcTAjCJHOtLKWdIg== X-Received: by 2002:a05:6638:41a7:: with SMTP id az39mr32298049jab.52.1626894930152; Wed, 21 Jul 2021 12:15:30 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id u13sm14189360iot.29.2021.07.21.12.15.29 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 21 Jul 2021 12:15:29 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id A8A088015F3; Wed, 21 Jul 2021 14:15:28 -0500 (CDT) Date: Wed, 21 Jul 2021 14:15:28 -0500 From: Justin Pryzby To: Laurent Hasson Cc: pgsql-performance@postgresql.org Subject: Re: Big performance slowdown from 11.2 to 13.3 Message-ID: <20210721191528.GC19620@telsasoft.com> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jul 21, 2021 at 06:50:58PM +0000, ldh@laurent-hasson.com wrote: > The plans are pretty much identical too. I checked line by line and couldn't see anything much different (note that I have a view over this query). Here is the V13 version of the plan: > I am out of my wits as to what is causing such a massive slowdown and how I could fix it. > > Any idea out there? Could you send the "explain (analyze,buffers,settings) for query on the v11 and v13 instances ? Or a link to the execution plan pasted into explain.depesz.com. https://wiki.postgresql.org/wiki/Slow_Query_Questions#EXPLAIN_.28ANALYZE.2C_BUFFERS.29.2C_not_just_EXPLAIN It might be good to check using a copy of your data that there's no regression between 11.2 and 11.12. -- Justin