explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rh4r

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Insert on intersect_2012 (cost=0.08..645,594,255.73 rows=2,677,840,517 width=314) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Result (cost=0.08..645,594,255.73 rows=2,677,840,517 width=314) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Append (cost=0.08..634,882,893.67 rows=2,677,840,517 width=310) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=0.08..45,905,675.11 rows=875,507,784 width=68) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.08..43,279,151.76 rows=875,507,784 width=68) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on c2c_year_buff a (cost=0.00..77,792.08 rows=1,755,692 width=423) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using changetypebuff_geom_geom_idx on changetypebuff b (cost=0.08..24.20 rows=51 width=481) (actual rows= loops=)

  • Index Cond: (a.geom && geom)
  • Filter: (_st_intersects(a.geom, geom) AND ((NOT (geom ~ a.geom)) OR (NOT _st_contains(geom, a.geom))) AND ((NOT (a.geom ~ geom)) OR (NOT _st_contains(a.geom, geom))))
8. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=4.94..588,977,218.56 rows=1,802,332,733 width=427) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.94..583,570,220.36 rows=1,802,332,733 width=427) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on c2c_year_buff a_1 (cost=0.00..77,792.08 rows=1,755,692 width=423) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on changetypebuff b_1 (cost=4.94..329.26 rows=1,027 width=481) (actual rows= loops=)

  • Recheck Cond: ((geom ~ a_1.geom) OR (a_1.geom ~ geom))
  • Filter: (((geom ~ a_1.geom) AND _st_contains(geom, a_1.geom)) OR ((a_1.geom ~ geom) AND _st_contains(a_1.geom, geom)))
12. 0.000 0.000 ↓ 0.0

BitmapOr (cost=4.94..4.94 rows=3,080 width=0) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on changetypebuff_geom_geom_idx (cost=0.00..2.42 rows=1,540 width=0) (actual rows= loops=)

  • Index Cond: (geom ~ a_1.geom)
14. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on changetypebuff_geom_geom_idx (cost=0.00..2.42 rows=1,540 width=0) (actual rows= loops=)

  • Index Cond: (a_1.geom ~ geom)