SELECT * FROM test_table_1 AS lhs 
INNER JOIN test_table_2 AS rhs ON lhs.id = rhs.id 
WHERE test_table_1.id = 5;
 
Elapsed: 22.130 sec. 
Processed 150.01 million rows, 3.79 GB (6.78 million rows/s., 171.21 MB/s.)
Peak memory usage: 18.41 GiB.