explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bAhs : Optimization for: plan #6MBD

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 12.149 747.167 ↓ 0.0 0 1

Insert on intersect_2012 (cost=10,000,000,000.08..10,000,002,176.93 rows=10 width=72) (actual time=747.167..747.167 rows=0 loops=1)

2. 1.352 735.018 ↑ 1.0 10 1

Subquery Scan on *SELECT* (cost=10,000,000,000.08..10,000,002,176.93 rows=10 width=72) (actual time=215.449..735.018 rows=10 loops=1)

3. 0.015 733.666 ↑ 1.0 10 1

Limit (cost=10,000,000,000.08..10,000,002,176.89 rows=10 width=40) (actual time=214.686..733.666 rows=10 loops=1)

4. 393.061 733.651 ↑ 4,603.0 10 1

Nested Loop (cost=10,000,000,000.08..10,010,019,843.20 rows=46,030 width=40) (actual time=214.684..733.651 rows=10 loops=1)

5. 10.085 10.085 ↑ 59.8 6,745 1

Seq Scan on fixed_difference_year a (cost=0.00..21,745.64 rows=403,213 width=927) (actual time=0.379..10.085 rows=6,745 loops=1)

6. 330.505 330.505 ↓ 0.0 0 6,745

Index Scan using idx_type_geom on changetypebuff b (cost=0.08..24.79 rows=1 width=382) (actual time=0.048..0.049 rows=0 loops=6,745)

  • Index Cond: (geom && st_expand(a.geom, '1'::double precision))
  • Filter: ((a.geom && st_expand(geom, '1'::double precision)) AND _st_dwithin(a.geom, geom, '1'::double precision) AND _st_intersects(a.geom, geom) AND (NOT _st_touches(a.geom, geom)))
  • Rows Removed by Filter: 0