explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EO12

Settings
# exclusive inclusive rows x rows loops node
1. 6.185 54,185.424 ↓ 0.0 0 1

Insert on intersect_2012 (cost=0.08..3.72 rows=50 width=72) (actual time=54,185.424..54,185.424 rows=0 loops=1)

2. 4.202 54,179.239 ↑ 1.0 50 1

Subquery Scan on *SELECT* (cost=0.08..3.72 rows=50 width=72) (actual time=4.146..54,179.239 rows=50 loops=1)

3. 0.060 54,175.037 ↑ 1.0 50 1

Limit (cost=0.08..3.52 rows=50 width=68) (actual time=4.107..54,175.037 rows=50 loops=1)

4. 20,072.635 54,174.977 ↑ 17,521,835.0 50 1

Nested Loop (cost=0.08..60,214,043.65 rows=876,091,748 width=68) (actual time=4.106..54,174.977 rows=50 loops=1)

5. 0.538 0.538 ↑ 79,804.2 22 1

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

6. 34,101.804 34,101.804 ↑ 25.5 2 22

Index Scan using changetypebuff_geom_geom_idx on changetypebuff (cost=0.08..8.65 rows=51 width=481) (actual time=973.229..1,550.082 rows=2 loops=22)

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