Postgres Pro
Downloads
Home   >   mailing lists

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

From pavan95
Subject Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!
Date
Msg-id 1526909995520-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!  (Abbas <abbas@rechat.com>)
Responses Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!  (Abbas <abbas@rechat.com>)
List pgsql-performance
Tree view 
Hi Abbas,

Thanks for your valuable suggestions. To my surprise I got the same output
as what I have executed before. 

But unfortunately I'm unable to understand the logic of the code, in
specific what is base 60 number? The used data type for "effort_hours"
column is 'double precision'. 

Kindly help me in understanding the logic. Thanks in advance.

Regards,
Pavan



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

pgsql-performance by date:

Previous
From: Abbas
Date:
Subject: Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!
Next
From: "David G. Johnston"
Date:
Subject: Re: Help me in reducing the CPU cost for the high cost query below,as it is hitting production seriously!!