Re: BUG #17059: postgresql 13 version problem related to query. - Mailing list pgsql-bugs

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.