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: Justin Pryzby <pryzby@xxxxxxxxxxxxx>
Date: Tue, 22 May 2018 05:39:06 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <1526985179479-0.post@n3.nabble.com>
References: <1526883356469-0.post@n3.nabble.com> <1526917693149-0.post@n3.nabble.com> <1526985179479-0.post@n3.nabble.com>
User-agent: Mutt/1.5.23 (2014-03-12)

On Tue, May 22, 2018 at 03:32:59AM -0700, pavan95 wrote:
> Sample query plan: 
> Limit  (cost=92129.35..92129.63 rows=10 width=248)

Would you send the output of explain(analyze,buffers) for the whole query ?
And/or paste it into explain.depesz site and send a link.

Justin

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

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

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]