explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DXeP

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 19.043 ↑ 1.0 1 1

Limit (cost=3.09..4.68 rows=1 width=229) (actual time=19.043..19.043 rows=1 loops=1)

2.          

Initplan (for Limit)

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on cad_incidents_status_types (cost=0.00..1.05 rows=1 width=8) (never executed)

  • Filter: ((abbreviation)::text = 'C'::text)
4. 0.003 0.003 ↑ 1.0 1 1

Seq Scan on cad_incidents_status_types cad_incidents_status_types_1 (cost=0.00..1.05 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

  • Filter: ((abbreviation)::text = 'A'::text)
  • Rows Removed by Filter: 3
5. 19.016 19.042 ↑ 15,330,321.0 1 1

Nested Loop (cost=0.99..24,447,324.06 rows=15,330,321 width=229) (actual time=19.042..19.042 rows=1 loops=1)

6. 0.002 0.017 ↑ 2,591,861.0 1 1

Nested Loop (cost=0.43..1,676,108.22 rows=2,591,861 width=64) (actual time=0.017..0.017 rows=1 loops=1)

7. 0.004 0.004 ↑ 2,595,526.0 1 1

Seq Scan on yrk_callforservice c (cost=0.00..357,826.26 rows=2,595,526 width=36) (actual time=0.004..0.004 rows=1 loops=1)

8. 0.011 0.011 ↑ 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.011..0.011 rows=1 loops=1)

  • Index Cond: ((wtrun = 101) AND (convertedid = c.yrk_callforservice_zid))
9. 0.009 0.009 ↑ 121.0 1 1

Index Scan using yrk_cad_info on z_yrk_cad_unit_resp r (cost=0.56..2.84 rows=121 width=173) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (cfsid = c.cfsid)
Planning time : 0.410 ms
Execution time : 19.154 ms