explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 297.432 19,575.099 ↓ 44.0 44 1

Nested Loop (cost=0.42..894.21 rows=1 width=4) (actual time=905.097..19,575.099 rows=44 loops=1)

2. 0.441 0.441 ↑ 1.0 179 1

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

3. 19,277.226 19,277.226 ↓ 0.0 0 179

Index Scan using kommune_the_geom_geom_idx on kommune (cost=0.42..4.21 rows=1 width=15,663) (actual time=106.010..107.694 rows=0 loops=179)

  • Index Cond: ((st_transform(st_setsrid(routes.the_geom, 4326), 25832))::geometry(MultiLineString,25832) && the_geom)
  • Filter: (((komkode)::text = '430'::text) AND st_intersects((st_transform(st_setsrid(routes.the_geom, 4326), 25832))::geometry(MultiLineString,25832), the_geom))
  • Rows Removed by Filter: 5
Planning time : 0.458 ms
Execution time : 19,575.334 ms