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.