Re: BUG #17059: postgresql 13 version problem related to query.

út 22. 6. 2021 v 1:54 odesílatel Bruce Momjian <bruce(at)momjian(dot)us> napsal:

> 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?
>

yes. I am sorry

Pavel

> --
> Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
> EDB https://enterprisedb.com
>
> If only the physical world exists, free will is an illusion.
>
>