q4_idx_orderdate.out
application/octet-stream
Filename: q4_idx_orderdate.out
Type: application/octet-stream
Part: 0
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=3509818.78..3509818.78 rows=1 width=24) (actual time=310491.603..310491.604 rows=1 loops=1)
-> Sort (cost=3509818.78..3509818.79 rows=5 width=24) (actual time=310491.601..310491.601 rows=1 loops=1)
Sort Key: orders_001.o_orderpriority
Sort Method: top-N heapsort Memory: 25kB
-> HashAggregate (cost=3509818.70..3509818.75 rows=5 width=24) (actual time=310491.551..310491.554 rows=5 loops=1)
Group Key: orders_001.o_orderpriority
-> Hash Join (cost=3475038.59..3507644.08 rows=434925 width=16) (actual time=296613.584..309312.040 rows=1029267 loops=1)
Hash Cond: (orders_001.o_orderkey = lineitem_001.l_orderkey)
-> Append (cost=0.43..22357.44 rows=1117500 width=20) (actual time=0.150..5888.004 rows=1122364 loops=1)
-> Index Scan using idx_orders_orderdate_001 on orders_001 (cost=0.43..1429.85 rows=71470 width=20) (actual time=0.149..362.843 rows=69975 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_002 on orders_002 (cost=0.43..1386.31 rows=69294 width=20) (actual time=0.102..352.255 rows=69858 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_003 on orders_003 (cost=0.43..1375.48 rows=68752 width=20) (actual time=0.094..346.035 rows=69939 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_004 on orders_004 (cost=0.43..1422.15 rows=71080 width=20) (actual time=0.095..344.728 rows=70162 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_005 on orders_005 (cost=0.43..1398.98 rows=69926 width=20) (actual time=0.087..347.121 rows=70452 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_006 on orders_006 (cost=0.43..1417.37 rows=70844 width=20) (actual time=0.110..358.077 rows=70386 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_007 on orders_007 (cost=0.43..1395.40 rows=69748 width=20) (actual time=0.061..349.435 rows=70292 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_008 on orders_008 (cost=0.43..1383.73 rows=69165 width=20) (actual time=0.162..343.578 rows=70047 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_009 on orders_009 (cost=0.43..1313.29 rows=65643 width=20) (actual time=0.061..354.964 rows=69637 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_010 on orders_010 (cost=0.43..1452.40 rows=72594 width=20) (actual time=0.085..354.418 rows=70149 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_011 on orders_011 (cost=0.43..1404.49 rows=70203 width=20) (actual time=0.100..374.798 rows=70219 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_012 on orders_012 (cost=0.43..1370.93 rows=68525 width=20) (actual time=0.106..360.906 rows=70006 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_013 on orders_013 (cost=0.43..1423.84 rows=71170 width=20) (actual time=0.070..360.435 rows=70200 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_014 on orders_014 (cost=0.43..1427.29 rows=71343 width=20) (actual time=0.082..359.513 rows=70218 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_015 on orders_015 (cost=0.43..1371.83 rows=68570 width=20) (actual time=0.079..361.363 rows=70170 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using idx_orders_orderdate_016 on orders_016 (cost=0.43..1383.96 rows=69172 width=20) (actual time=0.095..365.796 rows=70654 loops=1)
Index Cond: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
-> Index Scan using orders_017_pkey on orders_017 (cost=0.12..0.15 rows=1 width=20) (actual time=0.044..0.044 rows=0 loops=1)
Filter: ((o_orderdate >= '1996-02-01'::date) AND (o_orderdate < '1996-05-01 00:00:00'::timestamp without time zone))
Rows Removed by Filter: 1
-> Hash (cost=3469601.60..3469601.60 rows=434925 width=4) (actual time=296613.227..296613.227 rows=27508714 loops=1)
Buckets: 33554432 (originally 524288) Batches: 2 (originally 1) Memory Usage: 786433kB
-> HashAggregate (cost=3465252.35..3469601.60 rows=434925 width=4) (actual time=260533.573..279925.695 rows=27508714 loops=1)
Group Key: lineitem_001.l_orderkey
-> Append (cost=0.43..3365256.56 rows=39998314 width=4) (actual time=0.057..188605.049 rows=75869487 loops=1)
-> Index Scan using lineitem_001_pkey on lineitem_001 (cost=0.43..210306.19 rows=2499685 width=4) (actual time=0.057..10942.208 rows=4739980 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2758962
-> Index Scan using lineitem_002_pkey on lineitem_002 (cost=0.43..210274.71 rows=2499279 width=4) (actual time=0.061..10935.982 rows=4739875 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2757773
-> Index Scan using lineitem_003_pkey on lineitem_003 (cost=0.43..210306.99 rows=2499616 width=4) (actual time=0.069..10973.413 rows=4742855 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2756106
-> Index Scan using lineitem_004_pkey on lineitem_004 (cost=0.43..210458.79 rows=2501424 width=4) (actual time=0.065..10989.088 rows=4745393 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2758849
-> Index Scan using lineitem_005_pkey on lineitem_005 (cost=0.43..210285.48 rows=2499366 width=4) (actual time=0.069..11133.979 rows=4741198 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2756810
-> Index Scan using lineitem_006_pkey on lineitem_006 (cost=0.43..210171.05 rows=2498012 width=4) (actual time=0.079..10954.561 rows=4737786 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2756133
-> Index Scan using lineitem_007_pkey on lineitem_007 (cost=0.43..210231.91 rows=2498742 width=4) (actual time=0.061..10973.366 rows=4739910 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2756286
-> Index Scan using lineitem_008_pkey on lineitem_008 (cost=0.43..210285.23 rows=2499404 width=4) (actual time=0.093..10956.254 rows=4742349 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2755780
-> Index Scan using lineitem_009_pkey on lineitem_009 (cost=0.43..210353.33 rows=2500208 width=4) (actual time=0.073..11008.045 rows=4741475 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2759278
-> Index Scan using lineitem_010_pkey on lineitem_010 (cost=0.43..210326.04 rows=2499828 width=4) (actual time=0.065..10990.084 rows=4740827 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2758628
-> Index Scan using lineitem_011_pkey on lineitem_011 (cost=0.43..210387.78 rows=2500575 width=4) (actual time=0.061..10966.980 rows=4744350 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2757363
-> Index Scan using lineitem_012_pkey on lineitem_012 (cost=0.43..210318.18 rows=2499753 width=4) (actual time=0.067..11005.845 rows=4740377 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2759026
-> Index Scan using lineitem_013_pkey on lineitem_013 (cost=0.43..210376.27 rows=2500506 width=4) (actual time=0.065..11129.092 rows=4742764 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2758629
-> Index Scan using lineitem_014_pkey on lineitem_014 (cost=0.43..210266.66 rows=2499222 width=4) (actual time=0.065..10988.437 rows=4741021 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2756542
-> Index Scan using lineitem_015_pkey on lineitem_015 (cost=0.43..210507.39 rows=2501996 width=4) (actual time=0.063..10951.420 rows=4745799 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2760257
-> Index Scan using lineitem_016_pkey on lineitem_016 (cost=0.43..210400.34 rows=2500696 width=4) (actual time=0.063..10986.320 rows=4743525 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2758697
-> Index Scan using idx_lineitem_orderkey_017 on lineitem_017 (cost=0.13..0.22 rows=2 width=4) (actual time=0.043..0.047 rows=3 loops=1)
Filter: (l_commitdate < l_receiptdate)
Rows Removed by Filter: 2
Planning time: 9.050 ms
Execution time: 312348.893 ms
(102 rows)