JustPaste.it

int1:

"Gather  (cost=1000.14..8327493.05 rows=264060 width=58)"
"  Workers Planned: 1"
"  ->  Nested Loop  (cost=0.14..8300087.05 rows=155329 width=58)"
"        ->  Parallel Seq Scan on stream_dist_final a  (cost=0.00..1639.16 rows=10216 width=622)"
"        ->  Index Scan using hab_vul_final_geom_idx on hab_vul_final b  (cost=0.14..50.16 rows=1 width=655)"
"              Index Cond: (geom && a.geom)"
"              Filter: (st_intersects(a.geom, geom) AND (NOT st_touches(a.geom, geom)))"

int2:

"Nested Loop  (cost=0.14..15598586.43 rows=194675 width=96)"
"  ->  Seq Scan on int1  (cost=0.00..2825.40 rows=116340 width=88)"
"  ->  Index Scan using rd_dist_final_geom_idx on rd_dist_final c  (cost=0.14..50.17 rows=1 width=616)"
"        Index Cond: (geom && int1.geom)"
"        Filter: (st_intersects(int1.geom, geom) AND (NOT st_touches(int1.geom, geom)))"

int3:
"Nested Loop  (cost=0.14..22179698.31 rows=276810 width=104)"
"  ->  Seq Scan on int2  (cost=0.00..4199.25 rows=165425 width=96)"
"  ->  Index Scan using wetland_dist_final_geom_idx on wetland_dist_final d  (cost=0.14..50.17 rows=1 width=616)"
"        Index Cond: (geom && int2.geom)"
"        Filter: (st_intersects(int2.geom, geom) AND (NOT st_touches(int2.geom, geom)))"

int4:
"Nested Loop  (cost=0.14..34374969.40 rows=429012 width=112)"
"  ->  Seq Scan on int3  (cost=0.00..6766.83 rows=256383 width=104)"
"  ->  Index Scan using dwn_rd_cross_geom_idx on dwn_rd_cross e  (cost=0.14..50.16 rows=1 width=616)"
"        Index Cond: (geom && int3.geom)"
"        Filter: (st_intersects(int3.geom, geom) AND (NOT st_touches(int3.geom, geom)))"

int5:
"Nested Loop  (cost=0.14..59046480.16 rows=736922 width=120)"
"  ->  Seq Scan on int4  (cost=0.00..11996.94 rows=440394 width=112)"
"  ->  Index Scan using dwn_wtr_cross_geom_idx on dwn_wtr_cross f  (cost=0.14..50.16 rows=1 width=616)"
"        Index Cond: (geom && int4.geom)"
"        Filter: (st_intersects(int4.geom, geom) AND (NOT st_touches(int4.geom, geom)))"

int6:
"Nested Loop  (cost=0.14..108865681.74 rows=1358681 width=128)"
"  ->  Seq Scan on int5  (cost=0.00..22882.65 rows=811965 width=120)"
"  ->  Index Scan using dwn_pop_cross_geom_idx on dwn_pop_cross g  (cost=0.14..50.16 rows=1 width=616)"
"        Index Cond: (geom && int5.geom)"
"        Filter: (st_intersects(int5.geom, geom) AND (NOT st_touches(int5.geom, geom)))"