explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TMOB

Settings
# exclusive inclusive rows x rows loops node
1. 15.305 114,820.239 ↓ 0.0 0 1

Insert on intersect_2012 (cost=0.08..7.36 rows=100 width=72) (actual time=114,820.239..114,820.239 rows=0 loops=1)

2. 7.319 114,804.934 ↑ 1.0 100 1

Subquery Scan on *SELECT* (cost=0.08..7.36 rows=100 width=72) (actual time=3.211..114,804.934 rows=100 loops=1)

3. 0.099 114,797.615 ↑ 1.0 100 1

Limit (cost=0.08..6.96 rows=100 width=68) (actual time=3.127..114,797.615 rows=100 loops=1)

4. 49,389.019 114,797.516 ↑ 8,760,917.5 100 1

Nested Loop (cost=0.08..60,214,043.65 rows=876,091,748 width=68) (actual time=3.124..114,797.516 rows=100 loops=1)

5. 0.465 0.465 ↑ 46,202.4 38 1

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

6. 65,408.032 65,408.032 ↑ 17.0 3 38

Index Scan using changetypebuff_geom_geom_idx on changetypebuff (cost=0.08..8.65 rows=51 width=481) (actual time=1,166.378..1,721.264 rows=3 loops=38)

  • Index Cond: (c2c_year_buff.geom && geom)
  • Filter: _st_intersects(c2c_year_buff.geom, geom)
  • Rows Removed by Filter: 2