explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GWNr : Optimization for: plan #NtYB

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 10.682 ↑ 1.0 1 1

Limit (cost=1.14..2.82 rows=1 width=57) (actual time=10.681..10.682 rows=1 loops=1)

2. 10.605 10.680 ↑ 2,714,505.0 1 1

Nested Loop (cost=1.14..4,552,059.79 rows=2,714,505 width=57) (actual time=10.680..10.680 rows=1 loops=1)

3. 0.000 0.061 ↑ 2,819,093.0 1 1

Nested Loop (cost=0.86..2,979,366.81 rows=2,819,093 width=49) (actual time=0.061..0.061 rows=1 loops=1)

4. 0.002 0.053 ↑ 2,591,861.0 1 1

Nested Loop (cost=0.43..1,672,893.11 rows=2,591,861 width=36) (actual time=0.053..0.053 rows=1 loops=1)

5. 0.004 0.004 ↑ 2,613,413.0 1 1

Seq Scan on yrk_callforservice cfs (cost=0.00..346,383.13 rows=2,613,413 width=12) (actual time=0.004..0.004 rows=1 loops=1)

6. 0.047 0.047 ↑ 1.0 1 1

Index Scan using stg_combined_incidents_wtrun_convertedid_idx on stg_combined_incidents ci (cost=0.43..0.50 rows=1 width=40) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: ((wtrun = 101) AND (convertedid = cfs.yrk_callforservice_zid))
7. 0.008 0.008 ↑ 2.0 1 1

Index Scan using distinct_unit_index on z_distinct_unit u (cost=0.43..0.48 rows=2 width=21) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ((cfsid = cfs.cfsid) AND (cad_unitsid IS NOT NULL))
8. 0.014 0.014 ↑ 1.0 1 1

Index Scan using cad_units_pkey on cad_units cu (cost=0.28..0.30 rows=1 width=16) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (cad_unitsid = u.cad_unitsid)
Planning time : 0.515 ms
Execution time : 10.744 ms