[PERFORM] Query is very much slow

Hi team, We are getting very slow response of this query. SELECT date_trunc('day', insert_time),workflow.project.project_name, workflow.tool_performance.project_id,workflow.tool_performance.user_id,workflow.tool_performance.step_id,count(*), round(sum(execution_time)/1000) as Sum_time_sec,round(

[PERFORM] join estimate of subqueries with range conditions and constraint exclusion

We got bitten again by what appears to be the same issue I reported (perhaps poorly) here: https://www.postgresql.org/message-id/20170326193344.GS31628%40telsasoft.com We have PG9.6.3 table heirarchies partitioned by time. Our reports use subqueries each with their own copies of a range clauses o

Re: [PERFORM] Query is running very slow......

Hi, On 5/24/17 7:04 PM, Dinesh Chandra 12108 wrote: Dear Expert, While executing the blow query, its taking too long time to fetch output. Could you please help to fine tune the same? You'll have to provide far more details - the query alone is certainly not enough for anyone to guess why

[PERFORM] Query is running very slow......

Dear Expert, While executing the blow query, its taking too long time to fetch output. Could you please help to fine tune the same? SELECT date_trunc('day', insert_time), workflow.project.project_name, workflow.tool_performance.project_id, workflow.tool_performance.user_id, workflow.tool_performa