explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ClBT : Optimization for: plan #u6Ck

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 13,411.088 13,413.120 ↑ 25.8 44 1

Nested Loop (cost=0.00..2,236.21 rows=1,134 width=4) (actual time=372.189..13,413.120 rows=44 loops=1)

  • Join Filter: st_intersects((st_transform(st_setsrid(routes.the_geom, 4326), 25832))::geometry(MultiLineString,25832), kommune.the_geom)
  • Rows Removed by Join Filter: 3,357
2. 0.421 0.421 ↑ 1.0 179 1

Seq Scan on routes (cost=0.00..138.79 rows=179 width=32,177) (actual time=0.024..0.421 rows=179 loops=1)

3. 0.621 1.611 ↑ 1.0 19 179

Materialize (cost=0.00..260.93 rows=19 width=15,663) (actual time=0.001..0.009 rows=19 loops=179)

4. 0.990 0.990 ↑ 1.0 19 1

Seq Scan on kommune (cost=0.00..260.84 rows=19 width=15,663) (actual time=0.077..0.990 rows=19 loops=1)

  • Filter: ((komkode)::text = '430'::text)
  • Rows Removed by Filter: 1,568
Planning time : 0.168 ms
Execution time : 13,413.178 ms