Postgres Pro
Downloads
Home   >   mailing lists

Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!! - Mailing list pgsql-performance

From pavan95
Subject Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!
Date
Msg-id 1526986304012-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!  (Justin Pryzby <pryzby@telsasoft.com>)
Responses Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!
List pgsql-performance
Tree view 
Hi Justin,

Please find the output of explain(analyze,buffers) for the whole query in
the below link.

Link:  https://explain.depesz.com/s/dNkb <https://explain.depesz.com/s/dNkb>  

Thanks in Advance!


Regards,
Pavan



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!
Next
From: Justin Pryzby
Date:
Subject: Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!