explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GUwi : Optimization for: Optimization for: Optimization for: plan #u6Ck; plan #ClBT; plan #TMx7

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 13,893.061 13,895.044 ↑ 25.8 44 1

Nested Loop (cost=0.00..2,236.21 rows=1,134 width=4) (actual time=358.259..13,895.044 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.372 0.372 ↑ 1.0 179 1

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

3. 0.826 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.785 0.785 ↑ 1.0 19 1

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

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