Re: [PERFORM] Query is very much slow

2017-05-25 Thread Andreas Kretschmer
Hi, there is a similar question from dinesh.chan...@cyient.com, but it is not exact the same query. [PERFORM] Query is running very slow.., some hours ago. Regards, Andreas -- 2ndQuadrant - The PostgreSQL Support Company. www.2ndQuadrant.com -- Sent via pgsql-performance mailing list

Re: [PERFORM] Query is very much slow

2017-05-25 Thread Andreas Kretschmer
Am 25.05.2017 um 07:13 schrieb Daulat Ram: 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

[PERFORM] Query is very much slow

2017-05-24 Thread Daulat Ram
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(