TPC-H-test/output_9_off_default_statistics=10000 at main · Alena0704/TPC-H-test · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
                                                                     QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=9935986.40..11464594.80 rows=1 width=90)
   ->  GroupAggregate  (cost=9935986.40..210183686.38 rows=131 width=90)
         Group Key: nation.n_name, (EXTRACT(year FROM orders.o_orderdate))
         ->  Incremental Sort  (cost=9935986.40..210183682.12 rows=131 width=81)
               Sort Key: nation.n_name, (EXTRACT(year FROM orders.o_orderdate)) DESC
               Presorted Key: nation.n_name
               ->  Nested Loop  (cost=1592332.50..210183678.42 rows=131 width=81)
                     Join Filter: (lineitem.l_orderkey = orders.o_orderkey)
                     ->  Nested Loop  (cost=1592332.50..12554889.33 rows=131 width=57)
                           Join Filter: (supplier.s_suppkey = lineitem.l_suppkey)
                           ->  Gather Merge  (cost=40501.69..98734.93 rows=500000 width=30)
                                 Workers Planned: 2
                                 ->  Sort  (cost=39501.67..40022.50 rows=208333 width=30)
                                       Sort Key: nation.n_name
                                       ->  Hash Join  (cost=1.56..16109.47 rows=208333 width=30)
                                             Hash Cond: (supplier.s_nationkey = nation.n_nationkey)
                                             ->  Parallel Seq Scan on supplier  (cost=0.00..13243.33 rows=208333 width=8)
                                             ->  Hash  (cost=1.25..1.25 rows=25 width=30)
                                                   ->  Seq Scan on nation  (cost=0.00..1.25 rows=25 width=30)
                           ->  Materialize  (cost=1551830.81..11473654.73 rows=131 width=39)
                                 ->  Gather  (cost=1551830.81..11473654.07 rows=131 width=39)
                                       Workers Planned: 2
                                       ->  Parallel Hash Join  (cost=1550830.81..11472640.97 rows=55 width=39)
                                             Hash Cond: ((lineitem.l_suppkey = partsupp.ps_suppkey) AND (lineitem.l_partkey = partsupp.ps_partkey))
                                             ->  Parallel Seq Scan on lineitem  (cost=0.00..7026012.53 rows=124998853 width=33)
                                             ->  Parallel Hash  (cost=1532327.39..1532327.39 rows=887028 width=18)
                                                   ->  Parallel Hash Join  (cost=260554.27..1532327.39 rows=887028 width=18)
                                                         Hash Cond: (partsupp.ps_partkey = part.p_partkey)
                                                         ->  Parallel Seq Scan on partsupp  (cost=0.00..1041947.77 rows=16666777 width=14)
                                                         ->  Parallel Hash  (cost=256915.33..256915.33 rows=221755 width=4)
                                                               ->  Parallel Seq Scan on part  (cost=0.00..256915.33 rows=221755 width=4)
                                                                     Filter: ((p_name)::text ~~ '%green%'::text)
                     ->  Materialize  (cost=0.00..2833446.16 rows=75000144 width=12)
                           ->  Seq Scan on orders  (cost=0.00..2092233.44 rows=75000144 width=12)
(34 rows)