-- force nestloop indexscan plan set enable_seqscan to 0; set enable_bitmapscan to 0; set enable_mergejoin to 0; set enable_hashjoin to 0; select count(*) from test_data a, test_data b where a.f1 = b.f1;