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

From: mlunnon <mlunnon(at)rwa-net(dot)co(dot)uk>
To: 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-23 11:12:10
Message-ID: 1527073930538-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Pavan,
that's quite a big query. I can see that the generate_series function is
getting repeatedly called and the planner estimates for this sub query are
out by a factor of 66. You might try to re-write using a WITH query. I am
assuming that you have already analyzed all the tables and also added
appropriate indexes on join/query columns.
Regards
Matthew

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message pavan95 2018-05-23 13:39:21 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-23 07:01:06 Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!