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

From: Justin Pryzby <pryzby(at)telsasoft(dot)com>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Date: 2018-05-22 10:39:06
Message-ID: 20180522103906.GF30060@telsasoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message pavan95 2018-05-22 10:51:44 Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Previous Message pavan95 2018-05-22 10:32:59 Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!