explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EJp3

Settings
# exclusive inclusive rows x rows loops node
1. 5,391.279 405,832.561 ↓ 653.0 60,711,358 1

Gather (cost=1,000.28..4,039,107.83 rows=92,974 width=44) (actual time=0.848..405,832.561 rows=60,711,358 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 11,903.599 400,441.282 ↓ 522.4 20,237,119 3 / 3

Nested Loop (cost=0.28..4,028,810.43 rows=38,739 width=44) (actual time=0.276..400,441.282 rows=20,237,119 loops=3)

3. 752.136 752.136 ↑ 1.3 846,693 3 / 3

Parallel Seq Scan on reduced_ways h (cost=0.00..543,839.67 rows=1,058,367 width=1,006) (actual time=0.004..752.136 rows=846,693 loops=3)

4. 387,785.547 387,785.547 ↓ 24.0 24 2,540,080 / 3

Index Scan using reduced_locations_geom_idx on reduced_locations rl (cost=0.28..3.28 rows=1 width=44) (actual time=0.102..0.458 rows=24 loops=2,540,080)

  • Index Cond: (geom && st_expand(h.linestring, '0.00020000000000000001'::double precision))
  • Filter: ((h.linestring && st_expand(geom, '0.00020000000000000001'::double precision)) AND _st_dwithin(h.linestring, geom, '0.00020000000000000001'::double precision))
  • Rows Removed by Filter: 127
Planning time : 5.527 ms
Execution time : 418,489.295 ms