explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wfdo : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #MDwC; plan #lNxE; plan #NiVG; plan #uBOY; plan #j2md; plan #gqT1

Settings

Optimization path:

Optimization(s) for this plan:

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

Limit (cost=1.83..49.22 rows=1 width=36) (actual time=9.610..9.610 rows=1 loops=1)

2. 0.065 9.610 ↑ 5,029.0 1 1

Nested Loop Left Join (cost=1.83..238,308.36 rows=5,029 width=36) (actual time=9.610..9.610 rows=1 loops=1)

3. 0.001 9.544 ↑ 5,029.0 1 1

Nested Loop (cost=1.55..236,527.00 rows=5,029 width=36) (actual time=9.544..9.544 rows=1 loops=1)

4. 0.002 0.142 ↑ 5,029.0 1 1

Nested Loop (cost=1.27..234,978.67 rows=5,029 width=36) (actual time=0.142..0.142 rows=1 loops=1)

5. 0.000 0.109 ↑ 5,039.0 1 1

Nested Loop (cost=0.85..231,898.02 rows=5,039 width=40) (actual time=0.109..0.109 rows=1 loops=1)

6. 0.003 0.065 ↑ 99,538.0 1 1

Nested Loop (cost=0.42..116,273.63 rows=99,538 width=40) (actual time=0.065..0.065 rows=1 loops=1)

7. 0.023 0.023 ↑ 99,538.0 1 1

Seq Scan on ccmas_tblvehinfo vi (cost=0.00..7,247.38 rows=99,538 width=22) (actual time=0.023..0.023 rows=1 loops=1)

8. 0.039 0.039 ↑ 1.0 1 1

Index Scan using clover_cfs_convert1 on ccmas_tblclosedcalls cc (cost=0.42..1.09 rows=1 width=18) (actual time=0.039..0.039 rows=1 loops=1)

  • Index Cond: (incno = vi.incno)
9. 0.044 0.044 ↑ 1.0 1 1

Index Scan using stg_combined_incidents_wtrun_convertedid_idx on stg_combined_incidents ci (cost=0.43..1.15 rows=1 width=16) (actual time=0.044..0.044 rows=1 loops=1)

  • Index Cond: ((wtrun = 1) AND (convertedid = cc.ccmas_tblclosedcalls_zid))
10. 0.031 0.031 ↑ 2.0 1 1

Index Scan using clover_cad_units on z_cadunit_status_info gfu (cost=0.42..0.59 rows=2 width=26) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: (incno = cc.incno)
  • Filter: (distinctunit = 1)
11. 9.401 9.401 ↑ 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=9.401..9.401 rows=1 loops=1)

  • Index Cond: (cad_unitsid = gfu.z_unitid_cad_units_100)
12. 0.001 0.001 ↓ 0.0 0 1

Index Only Scan using users_pkey on users u (cost=0.28..0.33 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (usersid = cu.current_usersid)
  • Heap Fetches: 0
Planning time : 33.597 ms
Execution time : 9.683 ms