hawq4 查询慢

CPU利用率16%，内存利用率25%  io几乎为0.

"Aggregate  (cost=1536786884.36..1536786884.37 rows=1 width=8)"

"  Rows out:  Avg 1.0 rows x 1 workers.  Max/Last(seg-1:hawq2/seg-1:hawq2) 1/1 rows with 6649618/6649618 ms to end, start offset by 113/113 ms."
"  ->  Gather Motion 10:1  (slice3; segments: 10)  (cost=1536786884.23..1536786884.35 rows=1 width=8)"
"        Rows out:  Avg 10.0 rows x 1 workers at destination.  Max/Last(seg-1:hawq2/seg-1:hawq2) 10/10 rows with 6648325/6648325 ms to first row, 6649617/6649617 ms to end, start offset by 113/113 ms."
"        ->  Aggregate  (cost=1536786884.23..1536786884.24 rows=1 width=8)"
"              Rows out:  Avg 1.0 rows x 10 workers.  Max/Last(seg9:hawq2/seg9:hawq2) 1/1 rows with 6649610/6649610 ms to end, start offset by 121/121 ms."
"              ->  Hash Join  (cost=12378550.40..1285548817.13 rows=10049522684 width=0)"
"                    Hash Cond: b.d020 = a.d020"
"                    Rows out:  Avg 16141527732.6 rows x 10 workers.  Max/Last(seg0:hawq2/seg5:hawq2) 27038055797/9284446408 rows with 35849/35849 ms to first row, 4934249/6012099 ms to end, start offset by 118/118 ms."
"                    Executor memory:  2094695K bytes avg, 2105345K bytes max (seg0:hawq2)."
"                    Work_mem used:  980170K bytes avg, 986138K bytes max (seg0:hawq2). Workfile: (0 spilling, 0 reused)"
"                    (seg0)   Hash chain length 7.0 avg, 33634 max, using 3604842 of 8388619 buckets."
"                    ->  Redistribute Motion 10:10  (slice1; segments: 10)  (cost=0.00..14185068.72 rows=44704183 width=17)"
"                          Hash Key: b.d020"
"                          Rows out:  Avg 44704182.7 rows x 10 workers at destination.  Max/Last(seg0:hawq2/seg5:hawq2) 45085306/44249168 rows with 0.081/0.080 ms to first row, 1605183/4777121 ms to end, start offset by 35967/35967 ms."
"                          ->  Parquet table Scan on l_t120_2 b  (cost=0.00..5244232.24 rows=44704183 width=17)"
"                                Rows out:  Avg 44704182.7 rows x 10 workers.  Max/Last(seg3:hawq2/seg8:hawq2) 74341361/74302880 rows with 234/267 ms to first row, 18454/19178 ms to end, start offset by 122/121 ms."
"                    ->  Hash  (cost=8874445.40..8874445.40 rows=25092328 width=17)"
"                          Rows in:  Avg 25092328.0 rows x 10 workers.  Max/Last(seg0:hawq2/seg4:hawq2) 25245113/25126160 rows with 35466/35721 ms to end, start offset by 501/245 ms."
"                          ->  Redistribute Motion 10:10  (slice2; segments: 10)  (cost=0.00..8874445.40 rows=25092328 width=17)"
"                                Hash Key: a.d020"
"                                Rows out:  Avg 25092328.0 rows x 10 workers at destination.  Max/Last(seg0:hawq2/seg4:hawq2) 25245113/25126160 rows with 0.070/130 ms to first row, 24725/26788 ms to end, start offset by 501/245 ms."
"                                ->  Parquet table Scan on l_t054_2 a  (cost=0.00..3855979.80 rows=25092328 width=17)"
"                                      Rows out:  Avg 25092328.0 rows x 10 workers.  Max/Last(seg9:hawq2/seg3:hawq2) 41827991/41803377 rows with 258/232 ms to first row, 17404/17795 ms to end, start offset by 120/121 ms."
"Slice statistics:"
"  (slice0)    Executor memory: 280K bytes."
"  (slice1)    Executor memory: 1478K bytes avg x 10 workers, 1507K bytes max (seg3:hawq2)."
"  (slice2)    Executor memory: 980K bytes avg x 10 workers, 1186K bytes max (seg3:hawq2)."
"  (slice3)    Executor memory: 2094969K bytes avg x 10 workers, 2105619K bytes max (seg0:hawq2).  Work_mem: 986138K bytes max."
"Statement statistics:"
"  Memory used: 2097152K bytes"
"Settings:  default_hash_table_bucket_number=6"
"Dispatcher statistics:"
"  executors used(total/cached/new connection): (30/6/24); dispatcher time(total/connection/dispatch data): (104.471 ms/1484580702556.456 ms/0.568 ms)."
"  dispatch data time(max/min/avg): (0.026 ms/0.010 ms/0.017 ms); consume executor data time(max/min/avg): (0.055 ms/0.022 ms/0.035 ms); free executor time(max/min/avg): (0.000 ms/0.000 ms/0.000 ms)."
"Data locality statistics:"
"  data locality ratio: 1.000; virtual segment number: 10; different host number: 1; virtual segment number per host(avg/min/max): (10/10/10); segment size(avg/min/max): (6948649552.100 B/5788629230 B/11566372775 B); segment size with penalty(avg/min/max):  (...)"
"Total runtime: 6650049.359 ms"