hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chunling Wang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-975) Queries run much slower with 'explain analyze' than which without 'explain analyze'
Date Tue, 02 Aug 2016 07:47:20 GMT
Chunling Wang created HAWQ-975:
----------------------------------

             Summary: 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


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	|	129999	|	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)

Mime
View raw message