explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pdfb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 50.998 170.530 ↓ 1.8 203,421 1

Nested Loop (cost=1.11..19,917.31 rows=113,789 width=153) (actual time=0.043..170.530 rows=203,421 loops=1)

2. 11.536 36.432 ↓ 1.0 13,850 1

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

3. 5.950 5.950 ↑ 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=95) (actual time=0.015..5.950 rows=9,473 loops=1)

  • Index Cond: (version = 2)
4. 18.946 18.946 ↑ 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.002..0.002 rows=1 loops=9,473)

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

Index Scan using link_id_pk on link_id li (cost=0.42..0.89 rows=15 width=17) (actual time=0.004..0.006 rows=15 loops=13,850)

  • Index Cond: (forecast_section_id = rs.forecast_section_id)
Planning time : 1.027 ms
Execution time : 178.418 ms