QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------- Merge Join (cost=1.88..117183.33 rows=1593920 width=4) (actual time=0.090..4127.465 rows=1604080 loops=1) Merge Cond: (part.p_partkey = t.ps_partkey) -> Index Only Scan using part_pkey on part (cost=0.43..51948.26 rows=1999989 width=4) (actual time=0.038..928.974 rows=2000000 loops=1) Heap Fetches: 0 -> Index Only Scan using t_ps_partkey_idx on t (cost=0.43..40321.23 rows=1593920 width=4) (actual time=0.032..870.579 rows=1604080 loops=1) Heap Fetches: 0 Planning Time: 0.567 ms Execution Time: 4795.921 ms (8 rows)