Q21_SE_patch.out
application/octet-stream
Filename: Q21_SE_patch.out
Type: application/octet-stream
Part: 0
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=4671892.90..4671892.90 rows=1 width=34) (actual time=165743.300..165743.324 rows=100 loops=1)
-> Sort (cost=4671892.90..4671892.90 rows=1 width=34) (actual time=165743.298..165743.308 rows=100 loops=1)
Sort Key: (count(*)) DESC, supplier.s_name
Sort Method: top-N heapsort Memory: 38kB
-> GroupAggregate (cost=4671892.87..4671892.89 rows=1 width=34) (actual time=165667.913..165734.651 rows=7901 loops=1)
Group Key: supplier.s_name
-> Sort (cost=4671892.87..4671892.87 rows=1 width=26) (actual time=165667.886..165677.946 rows=78214 loops=1)
Sort Key: supplier.s_name
Sort Method: quicksort Memory: 9794kB
-> Nested Loop (cost=5970.34..4671892.86 rows=1 width=26) (actual time=55.209..164686.680 rows=78214 loops=1)
-> Nested Loop Semi Join (cost=5969.91..4671818.26 rows=1 width=34) (actual time=55.163..145891.301 rows=159108 loops=1)
-> Gather (cost=5969.47..4671693.81 rows=1 width=34) (actual time=55.133..113787.359 rows=265680 loops=1)
Workers Planned: 2
Workers Launched: 2
-> Nested Loop Anti Join (cost=4969.47..4670693.71 rows=1 width=34) (actual time=46.536..147546.571 rows=88560 loops=3)
-> Hash Join (cost=4969.04..2948614.42 rows=666638 width=34) (actual time=46.147..54467.899 rows=998433 loops=3)
Hash Cond: (l1.l_suppkey = supplier.s_suppkey)
-> Append (cost=0.00..2874481.63 rows=16665964 width=8) (actual time=0.018..43663.252 rows=25289829 loops=3)
-> Parallel Seq Scan on lineitem_001 l1 (cost=0.00..179631.07 rows=1041522 width=8) (actual time=0.018..2388.661 rows=1579993 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919654
-> Parallel Seq Scan on lineitem_002 l1_1 (cost=0.00..179606.66 rows=1041351 width=8) (actual time=0.035..2474.520 rows=1579958 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919258
-> Parallel Seq Scan on lineitem_003 l1_2 (cost=0.00..179638.02 rows=1041494 width=8) (actual time=0.024..2487.148 rows=1580952 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 918702
-> Parallel Seq Scan on lineitem_004 l1_3 (cost=0.00..179767.84 rows=1042262 width=8) (actual time=0.024..2598.393 rows=1581798 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919616
-> Parallel Seq Scan on lineitem_005 l1_4 (cost=0.00..179619.94 rows=1041412 width=8) (actual time=0.035..2624.030 rows=1580399 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 918937
-> Parallel Seq Scan on lineitem_006 l1_5 (cost=0.00..179521.09 rows=1040829 width=8) (actual time=0.027..2521.973 rows=1579262 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 918711
-> Parallel Seq Scan on lineitem_007 l1_6 (cost=0.00..179571.96 rows=1041119 width=8) (actual time=0.030..2499.981 rows=1579970 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 918762
-> Parallel Seq Scan on lineitem_008 l1_7 (cost=0.00..179616.05 rows=1041415 width=8) (actual time=0.023..2542.276 rows=1580783 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 918593
-> Parallel Seq Scan on lineitem_009 l1_8 (cost=0.00..179675.15 rows=1041764 width=8) (actual time=0.026..2320.356 rows=1580492 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919759
-> Parallel Seq Scan on lineitem_010 l1_9 (cost=0.00..179656.02 rows=1041600 width=8) (actual time=0.052..2436.583 rows=1580276 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919543
-> Parallel Seq Scan on lineitem_011 l1_10 (cost=0.00..179707.68 rows=1041912 width=8) (actual time=0.044..2332.089 rows=1581450 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919121
-> Parallel Seq Scan on lineitem_012 l1_11 (cost=0.00..179648.40 rows=1041584 width=8) (actual time=0.023..2390.770 rows=1580126 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919675
-> Parallel Seq Scan on lineitem_013 l1_12 (cost=0.00..179692.53 rows=1041881 width=8) (actual time=0.033..2488.269 rows=1580921 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919543
-> Parallel Seq Scan on lineitem_014 l1_13 (cost=0.00..179597.56 rows=1041348 width=8) (actual time=0.043..2420.870 rows=1580340 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 918847
-> Parallel Seq Scan on lineitem_015 l1_14 (cost=0.00..179809.78 rows=1042501 width=8) (actual time=0.034..2456.134 rows=1581933 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 920086
-> Parallel Seq Scan on lineitem_016 l1_15 (cost=0.00..179720.85 rows=1041969 width=8) (actual time=0.036..2393.696 rows=1581175 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 919566
-> Parallel Seq Scan on lineitem_017 l1_16 (cost=0.00..1.04 rows=1 width=8) (actual time=0.002..0.003 rows=1 loops=3)
Filter: (l_receiptdate > l_commitdate)
Rows Removed by Filter: 1
-> Hash (cost=4869.04..4869.04 rows=8000 width=30) (actual time=45.838..45.838 rows=7901 loops=3)
Buckets: 8192 Batches: 1 Memory Usage: 558kB
-> Nested Loop (cost=154.42..4869.04 rows=8000 width=30) (actual time=6.789..40.132 rows=7901 loops=3)
-> Seq Scan on nation (cost=0.00..1.31 rows=1 width=4) (actual time=0.015..0.027 rows=1 loops=3)
Filter: (n_name = 'FRANCE'::bpchar)
Rows Removed by Filter: 24
-> Bitmap Heap Scan on supplier (cost=154.42..4787.73 rows=8000 width=34) (actual time=6.770..36.422 rows=7901 loops=3)
Recheck Cond: (s_nationkey = nation.n_nationkey)
Heap Blocks: exact=3680
-> Bitmap Index Scan on idx_supplier_nation_key (cost=0.00..152.42 rows=8000 width=0) (actual time=5.551..5.551 rows=7901 loops=3)
Index Cond: (s_nationkey = nation.n_nationkey)
-> Append (cost=0.43..125.21 rows=102 width=8) (actual time=0.089..0.089 rows=1 loops=2995300)
-> Index Scan using idx_lineitem_orderkey_001 on lineitem_001 l3 (cost=0.43..7.76 rows=6 width=8) (actual time=0.009..0.009 rows=0 loops=2995300)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_002 on lineitem_002 l3_1 (cost=0.43..7.74 rows=6 width=8) (actual time=0.009..0.009 rows=0 loops=2824249)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_003 on lineitem_003 l3_2 (cost=0.43..7.73 rows=6 width=8) (actual time=0.009..0.009 rows=0 loops=2653937)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_004 on lineitem_004 l3_3 (cost=0.43..7.78 rows=7 width=8) (actual time=0.009..0.009 rows=0 loops=2483517)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_005 on lineitem_005 l3_4 (cost=0.43..7.76 rows=6 width=8) (actual time=0.009..0.009 rows=0 loops=2312378)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_006 on lineitem_006 l3_5 (cost=0.43..7.74 rows=6 width=8) (actual time=0.009..0.009 rows=0 loops=2141959)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_007 on lineitem_007 l3_6 (cost=0.43..7.78 rows=7 width=8) (actual time=0.009..0.009 rows=0 loops=1971332)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_008 on lineitem_008 l3_7 (cost=0.43..7.76 rows=6 width=8) (actual time=0.009..0.009 rows=0 loops=1801044)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_009 on lineitem_009 l3_8 (cost=0.43..7.74 rows=6 width=8) (actual time=0.009..0.009 rows=0 loops=1630299)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_010 on lineitem_010 l3_9 (cost=0.43..7.78 rows=7 width=8) (actual time=0.009..0.009 rows=0 loops=1460055)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_011 on lineitem_011 l3_10 (cost=0.43..7.80 rows=7 width=8) (actual time=0.009..0.009 rows=0 loops=1290011)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_012 on lineitem_012 l3_11 (cost=0.43..7.78 rows=7 width=8) (actual time=0.009..0.009 rows=0 loops=1118690)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_013 on lineitem_013 l3_12 (cost=0.43..7.76 rows=6 width=8) (actual time=0.010..0.010 rows=0 loops=947585)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_014 on lineitem_014 l3_13 (cost=0.43..7.74 rows=6 width=8) (actual time=0.010..0.010 rows=0 loops=776755)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_015 on lineitem_015 l3_14 (cost=0.43..7.74 rows=6 width=8) (actual time=0.011..0.011 rows=0 loops=606205)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_016 on lineitem_016 l3_15 (cost=0.43..7.76 rows=6 width=8) (actual time=0.012..0.012 rows=0 loops=435655)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey))
Rows Removed by Filter: 0
-> Seq Scan on lineitem_017 l3_16 (cost=0.00..1.09 rows=1 width=8) (actual time=0.006..0.006 rows=0 loops=265680)
Filter: ((l_receiptdate > l_commitdate) AND (l_suppkey <> l1.l_suppkey) AND (l_orderkey = l1.l_orderkey))
Rows Removed by Filter: 5
-> Append (cost=0.43..124.44 rows=308 width=8) (actual time=0.117..0.117 rows=1 loops=265680)
-> Index Scan using idx_lineitem_orderkey_001 on lineitem_001 l2 (cost=0.43..7.71 rows=19 width=8) (actual time=0.009..0.009 rows=0 loops=265680)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_002 on lineitem_002 l2_1 (cost=0.43..7.69 rows=18 width=8) (actual time=0.009..0.009 rows=0 loops=255687)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_003 on lineitem_003 l2_2 (cost=0.43..7.69 rows=18 width=8) (actual time=0.009..0.009 rows=0 loops=245688)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_004 on lineitem_004 l2_3 (cost=0.43..7.73 rows=20 width=8) (actual time=0.009..0.009 rows=0 loops=235863)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_005 on lineitem_005 l2_4 (cost=0.43..7.71 rows=19 width=8) (actual time=0.009..0.009 rows=0 loops=225870)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_006 on lineitem_006 l2_5 (cost=0.43..7.69 rows=18 width=8) (actual time=0.009..0.009 rows=0 loops=215942)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_007 on lineitem_007 l2_6 (cost=0.43..7.73 rows=20 width=8) (actual time=0.009..0.009 rows=0 loops=205878)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_008 on lineitem_008 l2_7 (cost=0.43..7.71 rows=19 width=8) (actual time=0.009..0.009 rows=0 loops=196058)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_009 on lineitem_009 l2_8 (cost=0.43..7.69 rows=18 width=8) (actual time=0.009..0.009 rows=0 loops=186057)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_010 on lineitem_010 l2_9 (cost=0.43..7.73 rows=20 width=8) (actual time=0.009..0.009 rows=0 loops=176069)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_011 on lineitem_011 l2_10 (cost=0.43..7.75 rows=21 width=8) (actual time=0.009..0.009 rows=0 loops=166152)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_012 on lineitem_012 l2_11 (cost=0.43..7.73 rows=20 width=8) (actual time=0.009..0.009 rows=0 loops=156272)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_013 on lineitem_013 l2_12 (cost=0.43..7.71 rows=19 width=8) (actual time=0.010..0.010 rows=0 loops=146315)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_014 on lineitem_014 l2_13 (cost=0.43..7.69 rows=18 width=8) (actual time=0.010..0.010 rows=0 loops=136377)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_015 on lineitem_015 l2_14 (cost=0.43..7.69 rows=18 width=8) (actual time=0.010..0.010 rows=0 loops=126340)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Index Scan using idx_lineitem_orderkey_016 on lineitem_016 l2_15 (cost=0.43..7.71 rows=19 width=8) (actual time=0.010..0.010 rows=0 loops=116432)
Index Cond: (l_orderkey = l1.l_orderkey)
Filter: (l_suppkey <> l1.l_suppkey)
Rows Removed by Filter: 0
-> Seq Scan on lineitem_017 l2_16 (cost=0.00..1.07 rows=4 width=8) (actual time=0.005..0.005 rows=0 loops=106572)
Filter: ((l_suppkey <> l1.l_suppkey) AND (l1.l_orderkey = l_orderkey))
Rows Removed by Filter: 5
-> Append (cost=0.43..74.49 rows=11 width=4) (actual time=0.090..0.116 rows=0 loops=159108)
-> Index Scan using orders_001_pkey on orders_001 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_002_pkey on orders_002 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_003_pkey on orders_003 (cost=0.43..7.35 rows=1 width=4) (actual time=0.011..0.011 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_004_pkey on orders_004 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_005_pkey on orders_005 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.011 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_006_pkey on orders_006 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_007_pkey on orders_007 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_008_pkey on orders_008 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_009_pkey on orders_009 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Index Scan using orders_010_pkey on orders_010 (cost=0.43..7.35 rows=1 width=4) (actual time=0.010..0.010 rows=0 loops=159108)
Index Cond: (o_orderkey = l1.l_orderkey)
Filter: (o_orderstatus = 'F'::bpchar)
Rows Removed by Filter: 0
-> Seq Scan on orders_011 (cost=0.00..1.03 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=159108)
Filter: ((o_orderstatus = 'F'::bpchar) AND (l1.l_orderkey = o_orderkey))
Rows Removed by Filter: 2
Planning time: 56.436 ms
Execution time: 165747.892 ms
(262 rows)