On Fri, Feb 25, 2022 at 3:18 PM Ayub Khan wrote:
> 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
>
I don't see ho
Please provide some more information, like your postgres version and settings.
Some relevant things are included here.
https://wiki.postgresql.org/wiki/Slow_Query_Questions
--
Justin
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
HashAggregate (cost=334063.59..334064.17 rows=58 width=213) (actual