[jira] [Updated] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'

2016-12-21 Thread Ed Espino (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HAWQ-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ed Espino updated HAWQ-975:
---
Labels:   (was: ToBeClosed)

> Queries run much slower with 'explain analyze' than which without  'explain 
> analyze'
> 
>
> Key: HAWQ-975
> URL: https://issues.apache.org/jira/browse/HAWQ-975
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Affects Versions: 2.0.0.0-incubating
>Reporter: Chunling Wang
>Assignee: Chunling Wang
>Priority: Critical
> Fix For: 2.1.0.0-incubating
>
>
> When we run queries with 'explain analyze' in AWS cluster, the total running 
> time is about 2-3 times longer than which without 'explain analyze'.
> Here is a group of TPC-H results for queries with 'explain analyze' and 
> queries without 'explain analyze'.
> ||query   ||without 'explain analyze' ||with 'explain analyze'
> ||multiple
> |TPCH_Query_01|   311843  |   818658  |   2.63
> |TPCH_Query_02|   34675   |   117884  |   3.40
> |TPCH_Query_03|   166155  |   422131  |   2.54
> |TPCH_Query_04|   157807  |   507143  |   3.21
> |TPCH_Query_05|   272657  |   710573  |   2.61
> |TPCH_Query_06|   12508   |   22276   |   1.78
> |TPCH_Query_07|   71893   |   370338  |   5.15
> |TPCH_Query_08|   12  |   672625  |   5.17
> |TPCH_Query_09|   575709  |   1171672 |   2.04
> |TPCH_Query_10|   93770   |   233391  |   2.49
> |TPCH_Query_11|   16252   |   58360   |   3.59
> |TPCH_Query_12|   142576  |   237270  |   1.66
> |TPCH_Query_13|   72682   |   343257  |   4.72
> |TPCH_Query_14|   10410   |   32337   |   3.11
> |TPCH_Query_15|   25719   |   98705   |   3.84
> |TPCH_Query_16|   21382   |   76877   |   3.60
> |TPCH_Query_17|   839683  |   2041169 |   2.43
> |TPCH_Query_18|   460570  |   1065940 |   2.31
> |TPCH_Query_19|   69075   |   82286   |   1.19
> |TPCH_Query_20|   78263   |   292041  |   3.73
> |TPCH_Query_21|   505606  |   1549690 |   3.07
> |TPCH_Query_22|   56450   |   329837  |   5.84
> |Total|   4125684 |   11254460|   
> 2.73



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'

2016-08-31 Thread Chunling Wang (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HAWQ-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Chunling Wang updated HAWQ-975:
---
Affects Version/s: 2.0.0.0-incubating

> Queries run much slower with 'explain analyze' than which without  'explain 
> analyze'
> 
>
> Key: HAWQ-975
> URL: https://issues.apache.org/jira/browse/HAWQ-975
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Affects Versions: 2.0.0.0-incubating
>Reporter: Chunling Wang
>Assignee: Chunling Wang
>Priority: Critical
>  Labels: performance
> Fix For: 2.0.1.0-incubating
>
>
> When we run queries with 'explain analyze' in AWS cluster, the total running 
> time is about 2-3 times longer than which without 'explain analyze'.
> Here is a group of TPC-H results for queries with 'explain analyze' and 
> queries without 'explain analyze'.
> ||query   ||without 'explain analyze' ||with 'explain analyze'
> ||multiple
> |TPCH_Query_01|   311843  |   818658  |   2.63
> |TPCH_Query_02|   34675   |   117884  |   3.40
> |TPCH_Query_03|   166155  |   422131  |   2.54
> |TPCH_Query_04|   157807  |   507143  |   3.21
> |TPCH_Query_05|   272657  |   710573  |   2.61
> |TPCH_Query_06|   12508   |   22276   |   1.78
> |TPCH_Query_07|   71893   |   370338  |   5.15
> |TPCH_Query_08|   12  |   672625  |   5.17
> |TPCH_Query_09|   575709  |   1171672 |   2.04
> |TPCH_Query_10|   93770   |   233391  |   2.49
> |TPCH_Query_11|   16252   |   58360   |   3.59
> |TPCH_Query_12|   142576  |   237270  |   1.66
> |TPCH_Query_13|   72682   |   343257  |   4.72
> |TPCH_Query_14|   10410   |   32337   |   3.11
> |TPCH_Query_15|   25719   |   98705   |   3.84
> |TPCH_Query_16|   21382   |   76877   |   3.60
> |TPCH_Query_17|   839683  |   2041169 |   2.43
> |TPCH_Query_18|   460570  |   1065940 |   2.31
> |TPCH_Query_19|   69075   |   82286   |   1.19
> |TPCH_Query_20|   78263   |   292041  |   3.73
> |TPCH_Query_21|   505606  |   1549690 |   3.07
> |TPCH_Query_22|   56450   |   329837  |   5.84
> |Total|   4125684 |   11254460|   
> 2.73



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'

2016-08-09 Thread Goden Yao (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HAWQ-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Goden Yao updated HAWQ-975:
---
Priority: Critical  (was: Major)

> Queries run much slower with 'explain analyze' than which without  'explain 
> analyze'
> 
>
> Key: HAWQ-975
> URL: https://issues.apache.org/jira/browse/HAWQ-975
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Chunling Wang
>Assignee: Lei Chang
>Priority: Critical
>  Labels: performance
> Fix For: 2.0.1.0-incubating
>
>
> When we run queries with 'explain analyze' in AWS cluster, the total running 
> time is about 2-3 times longer than which without 'explain analyze'.
> Here is a group of TPC-H results for queries with 'explain analyze' and 
> queries without 'explain analyze'.
> ||query   ||without 'explain analyze' ||with 'explain analyze'
> ||multiple
> |TPCH_Query_01|   311843  |   818658  |   2.63
> |TPCH_Query_02|   34675   |   117884  |   3.40
> |TPCH_Query_03|   166155  |   422131  |   2.54
> |TPCH_Query_04|   157807  |   507143  |   3.21
> |TPCH_Query_05|   272657  |   710573  |   2.61
> |TPCH_Query_06|   12508   |   22276   |   1.78
> |TPCH_Query_07|   71893   |   370338  |   5.15
> |TPCH_Query_08|   12  |   672625  |   5.17
> |TPCH_Query_09|   575709  |   1171672 |   2.04
> |TPCH_Query_10|   93770   |   233391  |   2.49
> |TPCH_Query_11|   16252   |   58360   |   3.59
> |TPCH_Query_12|   142576  |   237270  |   1.66
> |TPCH_Query_13|   72682   |   343257  |   4.72
> |TPCH_Query_14|   10410   |   32337   |   3.11
> |TPCH_Query_15|   25719   |   98705   |   3.84
> |TPCH_Query_16|   21382   |   76877   |   3.60
> |TPCH_Query_17|   839683  |   2041169 |   2.43
> |TPCH_Query_18|   460570  |   1065940 |   2.31
> |TPCH_Query_19|   69075   |   82286   |   1.19
> |TPCH_Query_20|   78263   |   292041  |   3.73
> |TPCH_Query_21|   505606  |   1549690 |   3.07
> |TPCH_Query_22|   56450   |   329837  |   5.84
> |Total|   4125684 |   11254460|   
> 2.73



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'

2016-08-09 Thread Goden Yao (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HAWQ-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Goden Yao updated HAWQ-975:
---
Fix Version/s: (was: backlog)
   2.0.1.0-incubating

> Queries run much slower with 'explain analyze' than which without  'explain 
> analyze'
> 
>
> Key: HAWQ-975
> URL: https://issues.apache.org/jira/browse/HAWQ-975
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Chunling Wang
>Assignee: Lei Chang
>  Labels: performance
> Fix For: 2.0.1.0-incubating
>
>
> When we run queries with 'explain analyze' in AWS cluster, the total running 
> time is about 2-3 times longer than which without 'explain analyze'.
> Here is a group of TPC-H results for queries with 'explain analyze' and 
> queries without 'explain analyze'.
> ||query   ||without 'explain analyze' ||with 'explain analyze'
> ||multiple
> |TPCH_Query_01|   311843  |   818658  |   2.63
> |TPCH_Query_02|   34675   |   117884  |   3.40
> |TPCH_Query_03|   166155  |   422131  |   2.54
> |TPCH_Query_04|   157807  |   507143  |   3.21
> |TPCH_Query_05|   272657  |   710573  |   2.61
> |TPCH_Query_06|   12508   |   22276   |   1.78
> |TPCH_Query_07|   71893   |   370338  |   5.15
> |TPCH_Query_08|   12  |   672625  |   5.17
> |TPCH_Query_09|   575709  |   1171672 |   2.04
> |TPCH_Query_10|   93770   |   233391  |   2.49
> |TPCH_Query_11|   16252   |   58360   |   3.59
> |TPCH_Query_12|   142576  |   237270  |   1.66
> |TPCH_Query_13|   72682   |   343257  |   4.72
> |TPCH_Query_14|   10410   |   32337   |   3.11
> |TPCH_Query_15|   25719   |   98705   |   3.84
> |TPCH_Query_16|   21382   |   76877   |   3.60
> |TPCH_Query_17|   839683  |   2041169 |   2.43
> |TPCH_Query_18|   460570  |   1065940 |   2.31
> |TPCH_Query_19|   69075   |   82286   |   1.19
> |TPCH_Query_20|   78263   |   292041  |   3.73
> |TPCH_Query_21|   505606  |   1549690 |   3.07
> |TPCH_Query_22|   56450   |   329837  |   5.84
> |Total|   4125684 |   11254460|   
> 2.73



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

[jira] [Updated] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'

2016-08-02 Thread Goden Yao (JIRA) 

 [ 
https://issues.apache.org/jira/browse/HAWQ-975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Goden Yao updated HAWQ-975:
---
Labels: performance  (was: )

> Queries run much slower with 'explain analyze' than which without  'explain 
> analyze'
> 
>
> Key: HAWQ-975
> URL: https://issues.apache.org/jira/browse/HAWQ-975
> Project: Apache HAWQ
>  Issue Type: Bug
>  Components: Core
>Reporter: Chunling Wang
>Assignee: Lei Chang
>  Labels: performance
> Fix For: backlog
>
>
> When we run queries with 'explain analyze' in AWS cluster, the total running 
> time is about 2-3 times longer than which without 'explain analyze'.
> Here is a group of TPC-H results for queries with 'explain analyze' and 
> queries without 'explain analyze'.
> ||query   ||without 'explain analyze' ||with 'explain analyze'
> ||multiple
> |TPCH_Query_01|   311843  |   818658  |   2.63
> |TPCH_Query_02|   34675   |   117884  |   3.40
> |TPCH_Query_03|   166155  |   422131  |   2.54
> |TPCH_Query_04|   157807  |   507143  |   3.21
> |TPCH_Query_05|   272657  |   710573  |   2.61
> |TPCH_Query_06|   12508   |   22276   |   1.78
> |TPCH_Query_07|   71893   |   370338  |   5.15
> |TPCH_Query_08|   12  |   672625  |   5.17
> |TPCH_Query_09|   575709  |   1171672 |   2.04
> |TPCH_Query_10|   93770   |   233391  |   2.49
> |TPCH_Query_11|   16252   |   58360   |   3.59
> |TPCH_Query_12|   142576  |   237270  |   1.66
> |TPCH_Query_13|   72682   |   343257  |   4.72
> |TPCH_Query_14|   10410   |   32337   |   3.11
> |TPCH_Query_15|   25719   |   98705   |   3.84
> |TPCH_Query_16|   21382   |   76877   |   3.60
> |TPCH_Query_17|   839683  |   2041169 |   2.43
> |TPCH_Query_18|   460570  |   1065940 |   2.31
> |TPCH_Query_19|   69075   |   82286   |   1.19
> |TPCH_Query_20|   78263   |   292041  |   3.73
> |TPCH_Query_21|   505606  |   1549690 |   3.07
> |TPCH_Query_22|   56450   |   329837  |   5.84
> |Total|   4125684 |   11254460|   
> 2.73



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)