pavan95 wrote
> Hi all,
>
> Hope my mail finds you in good time. I had a problem with a query which is
> hitting the production seriously.
> The below is the sub part of the query for which I cannot reduce the CPU
> cost.
>
> Please check and verify whether I'm doing wrong or whether that type i
pavan95 wrote
> *Query*:
>
> explain select ... from tms_timesheet_details, tms_wsr_header header
> where wsr_header_id=header.id and work_order_no != 'CORPORATE';
>
> QUERY PLAN
> -
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 add
