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: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Mon, 21 May 2018 08:06:51 -0700
Cc: PostgreSQL mailing lists <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <1526913837692-0.post@n3.nabble.com>
References: <1526883356469-0.post@n3.nabble.com> <1526889830358-0.post@n3.nabble.com> <1526901200599-0.post@n3.nabble.com> <1526902087.12183.0@homie.mail.dreamhost.com> <1526909995520-0.post@n3.nabble.com> <CAKFQuwZqxACMe47Ag6+ioBhQ-Pb+vkCHpZr70ejbTpSqne15wQ@mail.gmail.com> <1526913837692-0.post@n3.nabble.com>

On Mon, May 21, 2018 at 7:43 AM, pavan95 <pavan.postgresdba@xxxxxxxxx> wrote:

Hi David,

Thank you so much for your valuable inputs. Is there anything that I need
to look from Indexes perspective or Join order ??

Kindly let me know if it can be tuned further.

What I've got to give here is what you've received.

David J.

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: Abbas
- 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: David G. Johnston
- 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]