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
Hi Justin ,
Thanks for your help , After committing 1 parameter , the whole query executed
in less than 1 min.
Thanks and Regards,
Mukesh Kumar
-Original Message-
From: Justin Pryzby
Sent: Wednesday, February 23, 2022 2:57 AM
To: Kumar, Mukesh
Cc: pgsql-performa...@postgresql.org
On Wed, Feb 23, 2022 at 07:04:15PM -0600, Justin Pryzby wrote:
> And the aforementioned network trace. You could set a capture filter on TCP
> SYN|RST so it's not absurdly large. From my notes, it might look like this:
> (tcp[tcpflags]&(tcp-rst|tcp-syn|tcp-fin)!=0)
I'd also add '|| icmp'. My hu
