explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xqc7 : Optimization for: plan #Pdfb

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 55.320 263.928 ↓ 1.8 203,421 1

Nested Loop (cost=1.11..18,408.37 rows=113,789 width=39) (actual time=0.045..263.928 rows=203,421 loops=1)

2. 9.366 70.108 ↓ 1.0 13,850 1

Nested Loop (cost=0.70..5,867.13 rows=13,457 width=45) (actual time=0.025..70.108 rows=13,850 loops=1)

3. 13.377 13.377 ↑ 1.5 9,473 1

Index Scan using forecast_section_ui on forecast_section f (cost=0.41..1,152.51 rows=14,002 width=24) (actual time=0.015..13.377 rows=9,473 loops=1)

  • Index Cond: (version = 2)
4. 47.365 47.365 ↑ 1.0 1 9,473

Index Scan using road_segment_pk on road_segment rs (cost=0.29..0.33 rows=1 width=21) (actual time=0.004..0.005 rows=1 loops=9,473)

  • Index Cond: (forecast_section_id = f.id)
5. 138.500 138.500 ↑ 1.0 15 13,850

Index Only Scan using link_id_pk on link_id li (cost=0.42..0.78 rows=15 width=9) (actual time=0.007..0.010 rows=15 loops=13,850)

  • Index Cond: (forecast_section_id = rs.forecast_section_id)
  • Heap Fetches: 0
Planning time : 2.893 ms
Execution time : 284.709 ms