explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YzQx

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

Insert on intersect_2012 (cost=0.00..38,199,906,755.40 rows=73,780,425,102 width=72) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..38,199,906,755.40 rows=73,780,425,102 width=72) (actual rows= loops=)

  • Join Filter: (_st_intersects(a.geom, b.geom) AND (NOT _st_touches(a.geom, b.geom)))
3. 0.000 0.000 ↓ 0.0

Seq Scan on c2c_year_buff b (cost=0.00..77,787.57 rows=1,755,191 width=421) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..12,247.64 rows=189,160 width=1,503) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on difference_type a (cost=0.00..12,058.48 rows=189,160 width=1,503) (actual rows= loops=)