hawq 3 执行慢

"Aggregate  (cost=1520822218.88..1520822218.89 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 6776880/6776880 ms to end, start offset by 1.294/1.294 ms."
"  ->  Gather Motion 6:1  (slice1; segments: 6)  (cost=1520822218.78..1520822218.86 rows=1 width=8)"
"        Rows out:  Avg 6.0 rows x 1 workers at destination.  Max/Last(seg-1:hawq2/seg-1:hawq2) 6/6 rows with 3333925/3333925 ms to first row, 6776880/6776880 ms to end, start offset by 1.296/1.296 ms."
"        ->  Aggregate  (cost=1520822218.78..1520822218.79 rows=1 width=8)"
"              Rows out:  Avg 1.0 rows x 6 workers.  Max/Last(seg5:hawq2/seg0:hawq2) 1/1 rows with 4603303/6776878 ms to end, start offset by 3.516/3.481 ms."
"              ->  Hash Join  (cost=7349612.80..1269920578.75 rows=16726776002 width=0)"
"                    Hash Cond: b.d020 = a.d020"
"                    Rows out:  Avg 26902546221.0 rows x 6 workers.  Max/Last(seg0:hawq2/seg0:hawq2) 40017551225/40017551225 rows with 22090/22090 ms to first row, 4359259/4359259 ms to end, start offset by 3.481/3.481 ms."
"                    Executor memory:  3533484K bytes avg, 3538946K bytes max (seg5:hawq2)."
"                    Work_mem used:  1633616K bytes avg, 1638375K bytes max (seg4:hawq2). Workfile: (0 spilling, 0 reused)"
"                    (seg0)   Hash chain length 6.7 avg, 24681 max, using 6270209 of 16777289 buckets."
"                    ->  Parquet table Scan on l_t120 b  (cost=0.00..5267903.24 rows=74506971 width=17)"
"                          Rows out:  Avg 74506971.2 rows x 6 workers.  Max/Last(seg0:hawq2/seg3:hawq2) 75291213/74137581 rows with 12/15 ms to first row, 12657/12949 ms to end, start offset by 3.481/3.532 ms."
"                    ->  Hash  (cost=3845507.80..3845507.80 rows=41820547 width=17)"
"                          Rows in:  Avg 41820546.7 rows x 6 workers.  Max/Last(seg4:hawq2/seg4:hawq2) 41942400/41942400 rows with 22557/22557 ms to end, start offset by 144/144 ms."
"                          ->  Parquet table Scan on l_t054 a  (cost=0.00..3845507.80 rows=41820547 width=17)"
"                                Rows out:  Avg 41820546.7 rows x 6 workers.  Max/Last(seg4:hawq2/seg4:hawq2) 41942400/41942400 rows with 4.706/4.706 ms to first row, 12891/12891 ms to end, start offset by 144/144 ms."
"Slice statistics:"
"  (slice0)    Executor memory: 273K bytes."
"  (slice1)    Executor memory: 3535391K bytes avg x 6 workers, 3540878K bytes max (seg5:hawq2).  Work_mem: 1638375K bytes max."
"Statement statistics:"
"  Memory used: 2097152K bytes"
"Settings:  default_hash_table_bucket_number=6"
"Dispatcher statistics:"
"  executors used(total/cached/new connection): (6/6/0); dispatcher time(total/connection/dispatch data): (0.297 ms/0.000 ms/0.155 ms)."
"  dispatch data time(max/min/avg): (0.064 ms/0.013 ms/0.024 ms); consume executor data time(max/min/avg): (0.061 ms/0.040 ms/0.049 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: 6; different host number: 1; virtual segment number per host(avg/min/max): (6/6/6); segment size(avg/min/max): (11653172379.833 B/11604600658 B/11715153390 B); segment size with penalty(avg/min/max): (0 (...)"
"Total runtime: 6776914.794 ms"