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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
From: pavan95 <pavan.postgresdba@xxxxxxxxx>
Date: Tue, 22 May 2018 03:51:44 -0700 (MST)
In-reply-to: <20180522103906.GF30060@telsasoft.com>
References: <1526883356469-0.post@n3.nabble.com> <1526917693149-0.post@n3.nabble.com> <1526985179479-0.post@n3.nabble.com> <20180522103906.GF30060@telsasoft.com>

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

Follow-Ups:
- Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  - From: Justin Pryzby

References:
- Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  - From: pavan95
- Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  - From: mlunnon
- Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  - From: pavan95
- Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  - From: Justin Pryzby

Prev by Date: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Next by Date: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Previous by thread: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Next by thread: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]