explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kP2X : Optimization for: plan #DXeP

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 24.381 ↑ 1.0 1 1

Limit (cost=0.86..2.73 rows=1 width=264) (actual time=24.380..24.381 rows=1 loops=1)

2. 24.297 24.378 ↑ 7,412,259.0 1 1

Nested Loop (cost=0.86..13,856,368.41 rows=7,412,259 width=264) (actual time=24.378..24.378 rows=1 loops=1)

3. 0.004 0.060 ↑ 7,422,740.0 1 1

Nested Loop (cost=0.43..4,193,571.95 rows=7,422,740 width=236) (actual time=0.060..0.060 rows=1 loops=1)

4. 0.020 0.020 ↑ 7,422,740.0 1 1

Seq Scan on z_yrk_cad_unit_resp r (cost=0.00..445,364.40 rows=7,422,740 width=208) (actual time=0.020..0.020 rows=1 loops=1)

5. 0.036 0.036 ↑ 1.0 1 1

Index Scan using unique_cfsid on yrk_callforservice c (cost=0.43..0.49 rows=1 width=36) (actual time=0.036..0.036 rows=1 loops=1)

  • Index Cond: (cfsid = r.cfsid)
6. 0.021 0.021 ↑ 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=44) (actual time=0.021..0.021 rows=1 loops=1)

  • Index Cond: ((wtrun = 101) AND (convertedid = c.yrk_callforservice_zid))
Planning time : 0.431 ms
Execution time : 24.513 ms