pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Ram Pratap Maurya <ram.maurya@lavainternational.in>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17059: postgresql 13 version problem related to query.
Date: Mon, 21 Jun 2021 19:54:54 -0400
Message-ID: <20210621235454.GF22121@momjian.us> (raw)
In-Reply-To: <CAFj8pRCqndO0HkrKmf01w4Yf6KB8MAOpHV2s++bP5dq032H_HA@mail.gmail.com>
References: <17059-c96d70e84d7bb4ce@postgresql.org>
	<CAFj8pRB7-UCRiPhe9E5L=q_07QB-0p9ZgH_kSqaewWcYC8-fHA@mail.gmail.com>
	<KL1PR0601MB443311C42FA40585125D1E0AF0309@KL1PR0601MB4433.apcprd06.prod.outlook.com>
	<CAFj8pRAJu00202QkAGNXQQrvyqSuLH9HbWxpk1++kt4bhvB1Zw@mail.gmail.com>
	<KL1PR0601MB443303F28BCAF682373C8B2AF0309@KL1PR0601MB4433.apcprd06.prod.outlook.com>
	<CAFj8pRCqndO0HkrKmf01w4Yf6KB8MAOpHV2s++bP5dq032H_HA@mail.gmail.com>

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  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.






view thread (10+ messages)  latest in thread

Message-ID: <20210621235454.GF22121@momjian.us>
Permalink:  ../20210621235454.GF22121@momjian.us/
Also on:    postgresql.org/message-id/20210621235454.GF22121@momjian.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: bruce@momjian.us, pavel.stehule@gmail.com, ram.maurya@lavainternational.in, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #17059: postgresql 13 version problem related to query.
  In-Reply-To: <20210621235454.GF22121@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox