explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ToCv9

Settings
# exclusive inclusive rows x rows loops node
1. 2,805.440 2,830.066 ↓ 2.0 1,297 1

Nested Loop Left Join (cost=0.00..194,105.99 rows=659 width=164) (actual time=3.075..2,830.066 rows=1,297 loops=1)

  • Join Filter: ((st_transform(s.linestring, 3857) && st_expand(st_transform(h.geom, 3857), '5'::double precision)) AND (st_transform(h.geom, 3857) && st_expand(st_transform(s.linestring, 3857), '5'::double precision)) AND _st_dwithin(st_transform(s.linestring, 3857), st_transform(h.geom, 3857), '5'::double precision))
  • Rows Removed by Join Filter: 673,610
2. 0.243 0.243 ↑ 1.0 659 1

Seq Scan on test_only_navlog s (cost=0.00..55.59 rows=659 width=222) (actual time=0.013..0.243 rows=659 loops=1)

3. 24.124 24.383 ↑ 1.0 1,024 659

Materialize (cost=0.00..43.36 rows=1,024 width=164) (actual time=0.000..0.037 rows=1,024 loops=659)

4. 0.259 0.259 ↑ 1.0 1,024 1

Seq Scan on test_gesperrt h (cost=0.00..38.24 rows=1,024 width=164) (actual time=0.006..0.259 rows=1,024 loops=1)

Planning time : 28.655 ms
Execution time : 2,830.277 ms