@@ -318,6 +318,7 @@ join (select * from test.run_values limit 4) as t2 on t1.id = t2.val;
318
318
-> Limit
319
319
-> Seq Scan on run_values
320
320
-> Custom Scan (RuntimeAppend)
321
+ Prune by: (run_values.val = t1.id)
321
322
-> Seq Scan on runtime_test_1 t1
322
323
Filter: (run_values.val = id)
323
324
-> Index Only Scan using runtime_test_1_0_pkey on runtime_test_1_0 t1
@@ -332,7 +333,7 @@ join (select * from test.run_values limit 4) as t2 on t1.id = t2.val;
332
333
Index Cond: (id = run_values.val)
333
334
-> Index Only Scan using runtime_test_1_5_pkey on runtime_test_1_5 t1
334
335
Index Cond: (id = run_values.val)
335
- (18 rows)
336
+ (19 rows)
336
337
337
338
select from test.runtime_test_1 as t1
338
339
join (select * from test.run_values limit 4) as t2 on t1.id = t2.val;
@@ -355,6 +356,7 @@ join (select * from test.run_values limit 4) as t2 on t1.id = t2.val;
355
356
-> Limit
356
357
-> Seq Scan on run_values
357
358
-> Custom Scan (RuntimeAppend)
359
+ Prune by: (run_values.val = t1.id)
358
360
-> Index Only Scan using runtime_test_1_0_pkey on runtime_test_1_0 t1
359
361
Index Cond: (id = run_values.val)
360
362
-> Index Only Scan using runtime_test_1_1_pkey on runtime_test_1_1 t1
@@ -367,7 +369,7 @@ join (select * from test.run_values limit 4) as t2 on t1.id = t2.val;
367
369
Index Cond: (id = run_values.val)
368
370
-> Index Only Scan using runtime_test_1_5_pkey on runtime_test_1_5 t1
369
371
Index Cond: (id = run_values.val)
370
- (16 rows)
372
+ (17 rows)
371
373
372
374
select from test.runtime_test_1 as t1
373
375
join (select * from test.run_values limit 4) as t2 on t1.id = t2.val;