Limit (cost=16666.46..16666.71 rows=100 width=195) (actual time=40.686..40.744 rows=100 loops=1) AQO not used, fss=0 -> Sort (cost=16666.46..16666.93 rows=187 width=195) (actual time=40.685..40.739 rows=100 loops=1) AQO not used, fss=0 Sort Key: supplier.s_acctbal DESC, nation.n_name, supplier.s_name, part.p_partkey Sort Method: top-N heapsort Memory: 73kB -> Nested Loop (cost=1049.43..16659.40 rows=187 width=195) (actual time=0.246..40.378 rows=485 loops=1) AQO: rows=187, error=-159%, fss=1472849439 Join Filter: (nation.n_nationkey = supplier.s_nationkey) Rows Removed by Join Filter: 1940 -> Nested Loop (cost=0.00..2.62 rows=5 width=33) (actual time=0.018..0.024 rows=5 loops=1) AQO: rows=5, error=0%, fss=1568513763 Join Filter: (region.r_regionkey = nation.n_regionkey) Rows Removed by Join Filter: 20 -> Seq Scan on region (cost=0.00..1.06 rows=1 width=4) (actual time=0.012..0.013 rows=1 loops=1) AQO: rows=1, error=0%, fss=-1505563826 Filter: (r_name = 'ASIA'::bpchar) Rows Removed by Filter: 4 -> Seq Scan on nation (cost=0.00..1.25 rows=25 width=37) (actual time=0.002..0.005 rows=25 loops=1) AQO: rows=25, error=0%, fss=-400844413 -> Materialize (cost=1049.43..16621.61 rows=485 width=170) (actual time=0.045..8.009 rows=485 loops=5) AQO: rows=485, error=0%, fss=-666749616 -> Nested Loop (cost=1049.43..16619.19 rows=485 width=170) (actual time=0.224..39.642 rows=485 loops=1) AQO: rows=485, error=0%, fss=-666749616 -> Nested Loop (cost=1049.15..16471.86 rows=485 width=34) (actual time=0.220..38.151 rows=485 loops=1) AQO: rows=485, error=0%, fss=1786374427 -> Gather (cost=1000.00..6460.60 rows=826 width=30) (actual time=0.151..9.554 rows=826 loops=1) AQO: rows=826, error=0%, fss=-156496080 Workers Planned: 2 Workers Launched: 2 -> Parallel Seq Scan on part (cost=0.00..5378.00 rows=344 width=30) (actual time=0.065..13.921 rows=275 loops=3) AQO: rows=826, error=0%, fss=-156496080 Filter: (((p_type)::text ~~ '%STEEL'::text) AND (p_size = 30)) Rows Removed by Filter: 66391 -> Hash Join (cost=49.15..61.20 rows=1 width=8) (actual time=0.033..0.033 rows=1 loops=826) AQO not used, fss=0 Hash Cond: (partsupp.ps_supplycost = (min(partsupp_1.ps_supplycost))) -> Index Scan using partsupp_pkey on partsupp (cost=0.42..12.47 rows=4 width=14) (actual time=0.004..0.005 rows=4 loops=485) AQO: rows=4, error=0%, fss=1039583350 Index Cond: (ps_partkey = part.p_partkey) -> Hash (cost=48.71..48.71 rows=1 width=32) (actual time=0.029..0.029 rows=1 loops=826) Buckets: 1024 Batches: 1 Memory Usage: 9kB -> Aggregate (cost=48.70..48.71 rows=1 width=32) (actual time=0.028..0.028 rows=1 loops=826) AQO not used, fss=0 -> Nested Loop (cost=0.85..48.70 rows=2 width=6) (actual time=0.022..0.027 rows=1 loops=826) AQO: rows=2, error=61%, fss=-1497906424 Join Filter: (region_1.r_regionkey = nation_1.n_regionkey) Rows Removed by Join Filter: 3 -> Seq Scan on region region_1 (cost=0.00..1.06 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=826) AQO: rows=1, error=0%, fss=-1430902349 Filter: (r_name = 'ASIA'::bpchar) Rows Removed by Filter: 4 -> Nested Loop (cost=0.85..47.58 rows=4 width=10) (actual time=0.010..0.025 rows=4 loops=826) AQO: rows=4, error=0%, fss=492761352 -> Nested Loop (cost=0.71..46.96 rows=4 width=10) (actual time=0.008..0.018 rows=4 loops=826) AQO: rows=4, error=0%, fss=-738103366 -> Index Scan using partsupp_pkey on partsupp partsupp_1 (cost=0.42..13.75 rows=4 width=10) (actual time=0.005..0.006 rows=4 loops=826) AQO: rows=4, error=0%, fss=389205821 Index Cond: (ps_partkey = part.p_partkey) -> Index Scan using supplier_pkey on supplier supplier_1 (cost=0.29..8.30 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=3304) AQO: rows=1, error=0%, fss=-1023226617 Index Cond: (s_suppkey = partsupp_1.ps_suppkey) -> Index Scan using nation_pkey on nation nation_1 (cost=0.14..0.16 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=3304) AQO: rows=1, error=0%, fss=366000422 Index Cond: (n_nationkey = supplier_1.s_nationkey) -> Index Scan using supplier_pkey on supplier (cost=0.29..0.30 rows=1 width=144) (actual time=0.002..0.002 rows=1 loops=485) AQO: rows=1, error=0%, fss=-1728777918 Index Cond: (s_suppkey = partsupp.ps_suppkey) Planning Time: 8.399 ms Execution Time: 41.883 ms Using aqo: true AQO mode: LEARN Query hash: 8280828251003381383 JOINS: 8 (74 rows)