slow query to improve performace

From: Ayub Khan <ayub(dot)hp(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: slow query to improve performace
Date: 2022-02-25 20:18:22
Message-ID: CAHdeyEKbZgCY1C+LkAYoKKnJ-sajk5Ky8sfhQNP_+wKWRs9iVQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

Could some some verify the attached query to verify the performance and
suggest some steps to improve it, this query is created as a view. This
view is used to get the aggregates of orders based on its current status

Thanks

Attachment Content-Type Size
explain.txt text/plain 10.2 KB
slow_query.sql application/octet-stream 6.7 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Justin Pryzby 2022-02-25 22:52:01 Re: slow query to improve performace
Previous Message Justin Pryzby 2022-02-25 13:02:13 Re: An I/O error occurred while sending to the backend (PG 13.4)