Query 0b4ecc5f6aec963e:85221a3b00000000
3
3
(BCAST * 1)
4
2
5,084
90,858
179,637
1
39
2
5,084
90,858
179,637
1
19
179,637
2,750,652
2,750,652
100,000
100,000
(BCAST * 3)
1
(BCAST * 3)
3
3
(BCAST * 1)
76,412
114,827
114,827
1,616,595
1,616,595
1,616,595
100,000
1,461
100,000
(BCAST * 3)
1,461
(BCAST * 3)
39
13,295
43
13,295
13,295
29
29
(BCAST * 3)
43
1,491,144
1,491,144
1,655,574
1,655,574
1,655,574
1,461
18,000
1,461
(BCAST * 3)
18,000
(BCAST * 3)
179,637
2,750,652
2,750,652
100,000
100,000
(BCAST * 3)
1
(BCAST * 3)
3
3
(BCAST * 1)
76,412
114,827
114,827
1,616,595
2,750,652
2,880,404
100,000
1,461
100,000
(BCAST * 3)
1,461
(BCAST * 3)
19
43
6,726
43
1,491,144
1,491,144
1,655,574
1,655,574
2,880,404
1,461
18,000
1,461
(BCAST * 3)
18,000
(BCAST * 3)
6,726
719,384
29
29
(BCAST * 2)
85:AGGREGATE
FINALIZE
1 instance
Max: 185.069us, avg: 185.069us
84:EXCHANGE
UNPARTITIONED
1 instance
Max: 48.683us, avg: 48.683us
47:AGGREGATE
3 instances
Max: 0.000ns, avg: 0.000ns
00:UNION
3 instances
Max: 0.000ns, avg: 0.000ns
23:HASH JOIN
RIGHT SEMI JOIN, PARTITIONED
3 instances
Max: 12.502ms, avg: 6.930ms
20:NESTED LOOP JOIN
INNER JOIN, BROADCAST
3 instances
Max: 16.102ms, avg: 10.648ms
50:AGGREGATE
FINALIZE
3 instances
Max: 91.400ms, avg: 48.433ms
49:EXCHANGE
HASH(c_customer_sk)
3 instances
Max: 13.575ms, avg: 10.290ms
57:EXCHANGE
BROADCAST
3 instances
Max: 18.406us, avg: 17.468us
65:EXCHANGE
HASH(cs_bill_customer_sk)
3 instances
Max: 39.793us, avg: 32.165us
46:HASH JOIN
RIGHT SEMI JOIN, PARTITIONED
3 instances
Max: 364.599us, avg: 319.500us
43:NESTED LOOP JOIN
INNER JOIN, BROADCAST
3 instances
Max: 3.330ms, avg: 3.309ms
68:AGGREGATE
FINALIZE
3 instances
Max: 4.845ms, avg: 4.756ms
67:EXCHANGE
HASH(c_customer_sk)
3 instances
Max: 5.742ms, avg: 5.671ms
75:EXCHANGE
BROADCAST
3 instances
Max: 11.261us, avg: 10.343us
83:EXCHANGE
HASH(ws_bill_customer_sk)
3 instances
Max: 18.468us, avg: 17.466us
12:AGGREGATE
STREAMING
3 instances
Max: 227.452ms, avg: 184.898ms
11:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 197.170ms, avg: 173.745ms
09:SCAN HDFS
tpcds_parquet.store_sales
3 instances
Max: 2s495ms, avg: 2s456ms
48:EXCHANGE
BROADCAST
3 instances
Max: 28.556ms, avg: 18.366ms
10:SCAN HDFS
tpcds_parquet.customer
1 instance
Max: 387.229ms, avg: 387.229ms
56:AGGREGATE
FINALIZE
1 instance
Max: 7.534ms, avg: 7.534ms
55:EXCHANGE
UNPARTITIONED
1 instance
Max: 34.017us, avg: 34.017us
19:AGGREGATE
3 instances
Max: 385.930us, avg: 356.334us
54:AGGREGATE
FINALIZE
3 instances
Max: 81.076ms, avg: 35.929ms
53:EXCHANGE
HASH(c_customer_sk)
3 instances
Max: 5.057ms, avg: 5.034ms
18:AGGREGATE
STREAMING
3 instances
Max: 86.742ms, avg: 84.128ms
17:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 50.309ms, avg: 37.850ms
16:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 104.556ms, avg: 99.215ms
13:SCAN HDFS
tpcds_parquet.store_sales
3 instances
Max: 2s128ms, avg: 1s999ms
51:EXCHANGE
BROADCAST
3 instances
Max: 20.280ms, avg: 16.282ms
52:EXCHANGE
BROADCAST
3 instances
Max: 220.141us, avg: 191.219us
14:SCAN HDFS
tpcds_parquet.customer
1 instance
Max: 217.810ms, avg: 217.810ms
15:SCAN HDFS
tpcds_parquet.date_dim
1 instance
Max: 223.713ms, avg: 223.713ms
22:HASH JOIN
LEFT SEMI JOIN, PARTITIONED
3 instances
Max: 12.428ms, avg: 11.794ms
63:EXCHANGE
HASH(cs_item_sk)
3 instances
Max: 957.145us, avg: 640.378us
64:EXCHANGE
HASH(i_item_sk)
3 instances
Max: 48.427us, avg: 38.394us
21:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 19.898ms, avg: 12.549ms
01:SCAN HDFS
tpcds_parquet.catalog_sales
3 instances
Max: 469.081ms, avg: 308.611ms
58:EXCHANGE
BROADCAST
3 instances
Max: 23.304us, avg: 22.263us
02:SCAN HDFS
tpcds_parquet.date_dim
1 instance
Max: 149.564ms, avg: 149.564ms
62:AGGREGATE
FINALIZE
3 instances
Max: 249.954ms, avg: 213.201ms
61:EXCHANGE
HASH(substr(i_item_desc, 1, 30),i_item_sk,d_date)
3 instances
Max: 86.649ms, avg: 80.703ms
08:AGGREGATE
STREAMING
3 instances
Max: 946.861ms, avg: 891.220ms
07:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 446.757ms, avg: 398.442ms
06:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 140.359ms, avg: 123.255ms
03:SCAN HDFS
tpcds_parquet.store_sales
3 instances
Max: 1s501ms, avg: 1s184ms
59:EXCHANGE
BROADCAST
3 instances
Max: 215.276us, avg: 204.274us
60:EXCHANGE
BROADCAST
3 instances
Max: 3.052ms, avg: 2.557ms
04:SCAN HDFS
tpcds_parquet.date_dim
1 instance
Max: 504.422ms, avg: 504.422ms
05:SCAN HDFS
tpcds_parquet.item
1 instance
Max: 518.584ms, avg: 518.584ms
35:AGGREGATE
STREAMING
3 instances
Max: 251.784ms, avg: 183.129ms
34:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 367.947ms, avg: 246.990ms
32:SCAN HDFS
tpcds_parquet.store_sales
3 instances
Max: 2s535ms, avg: 2s504ms
66:EXCHANGE
BROADCAST
3 instances
Max: 18.030ms, avg: 14.997ms
33:SCAN HDFS
tpcds_parquet.customer
1 instance
Max: 479.316ms, avg: 479.316ms
74:AGGREGATE
FINALIZE
1 instance
Max: 463.941us, avg: 463.941us
73:EXCHANGE
UNPARTITIONED
1 instance
Max: 25.113us, avg: 25.113us
42:AGGREGATE
3 instances
Max: 381.138us, avg: 374.030us
72:AGGREGATE
FINALIZE
3 instances
Max: 45.296ms, avg: 25.746ms
71:EXCHANGE
HASH(c_customer_sk)
3 instances
Max: 4.991ms, avg: 4.935ms
41:AGGREGATE
STREAMING
3 instances
Max: 102.657ms, avg: 88.685ms
40:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 121.012ms, avg: 96.854ms
39:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 295.360ms, avg: 197.878ms
36:SCAN HDFS
tpcds_parquet.store_sales
3 instances
Max: 2s689ms, avg: 2s652ms
69:EXCHANGE
BROADCAST
3 instances
Max: 17.688ms, avg: 14.120ms
70:EXCHANGE
BROADCAST
3 instances
Max: 205.232us, avg: 198.569us
37:SCAN HDFS
tpcds_parquet.customer
1 instance
Max: 669.998ms, avg: 669.998ms
38:SCAN HDFS
tpcds_parquet.date_dim
1 instance
Max: 498.254ms, avg: 498.254ms
45:HASH JOIN
RIGHT SEMI JOIN, PARTITIONED
3 instances
Max: 30.098ms, avg: 17.951ms
81:EXCHANGE
HASH(i_item_sk)
3 instances
Max: 28.649us, avg: 28.117us
82:EXCHANGE
HASH(ws_item_sk)
3 instances
Max: 42.061ms, avg: 14.256ms
79:AGGREGATE
FINALIZE
3 instances
Max: 206.015ms, avg: 191.772ms
78:EXCHANGE
HASH(substr(i_item_desc, 1, 30),i_item_sk,d_date)
3 instances
Max: 97.660ms, avg: 85.208ms
31:AGGREGATE
STREAMING
3 instances
Max: 1s120ms, avg: 941.927ms
30:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 401.740ms, avg: 328.157ms
29:HASH JOIN
INNER JOIN, BROADCAST
3 instances
Max: 149.841ms, avg: 146.983ms
26:SCAN HDFS
tpcds_parquet.store_sales
3 instances
Max: 1s890ms, avg: 1s632ms
76:EXCHANGE
BROADCAST
3 instances
Max: 194.906us, avg: 190.717us
77:EXCHANGE
BROADCAST
3 instances
Max: 7.541ms, avg: 4.637ms
27:SCAN HDFS
tpcds_parquet.date_dim
1 instance
Max: 533.521ms, avg: 533.521ms
28:SCAN HDFS
tpcds_parquet.item
1 instance
Max: 721.026ms, avg: 721.026ms
44:HASH JOIN
INNER JOIN, BROADCAST
2 instances
Max: 40.750ms, avg: 26.866ms
24:SCAN HDFS
tpcds_parquet.web_sales
2 instances
Max: 366.900ms, avg: 212.171ms
80:EXCHANGE
BROADCAST
2 instances
Max: 21.486us, avg: 19.951us
25:SCAN HDFS
tpcds_parquet.date_dim
1 instance
Max: 652.683ms, avg: 652.683ms