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 1lvTkq-0002Nl-PU for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Jun 2021 23:55:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lvTkp-000170-N1 for pgsql-bugs@arkaria.postgresql.org; Mon, 21 Jun 2021 23:54:59 +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 1lvTkp-00016s-GS for pgsql-bugs@lists.postgresql.org; Mon, 21 Jun 2021 23:54:59 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lvTkm-0007AF-V8 for pgsql-bugs@lists.postgresql.org; Mon, 21 Jun 2021 23:54:59 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1lvTkk-0001Qa-91; Mon, 21 Jun 2021 19:54:54 -0400 Date: Mon, 21 Jun 2021 19:54:54 -0400 From: Bruce Momjian To: Pavel Stehule Cc: Ram Pratap Maurya , PostgreSQL mailing lists Subject: Re: BUG #17059: postgresql 13 version problem related to query. Message-ID: <20210621235454.GF22121@momjian.us> References: <17059-c96d70e84d7bb4ce@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jun 15, 2021 at 10:02:45PM +0200, Pavel Stehule wrote: > group by "Order".order_no > ,"Order".retailer_code,"Order".order_status,OrderDeliveryNote.assigned_to_username, > OrderDeliveryNote.assigned_to_role, > > OrderDeliveryNote.delivery_note_no, OrderDeliveryNote.date, > OrderDeliveryNote.total_value, > > leave.date, leave.username, RetailerList.retailer_outlet, > DSE_user.first_name, "Order".parent_order_no > > order by OrderDeliveryNote.date desc limit 5; > >   > > please, try to run ANALYZE statement first, and then repeat EXPLAIN ANALYZE > > please, don't send screenshots - use explain.depesz.com application for sharing > plans Pavel, on my laptop, I count 18 screen fulls of the previous email before I got to your reply. Wouldn't trimming the original email make sense here? -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com If only the physical world exists, free will is an illusion.