explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U6Dj : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #MDwC; plan #lNxE; plan #NiVG; plan #uBOY; plan #j2md; plan #gqT1; plan #wfdo; plan #FNsv; plan #1vH; plan #aIhO; plan #JZr9

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.004 38.775 ↑ 1.0 1 1

Limit (cost=0.86..2.96 rows=1 width=295) (actual time=38.774..38.775 rows=1 loops=1)

2. 38.728 38.771 ↑ 1,980,485.0 1 1

Nested Loop (cost=0.86..4,161,841.85 rows=1,980,485 width=295) (actual time=38.771..38.771 rows=1 loops=1)

3. 0.004 0.027 ↑ 1,983,893.0 1 1

Nested Loop (cost=0.43..1,579,432.51 rows=1,983,893 width=266) (actual time=0.027..0.027 rows=1 loops=1)

4. 0.010 0.010 ↑ 1,983,893.0 1 1

Seq Scan on z_yrk_cad_unit_resp_arrive r (cost=0.00..248,695.46 rows=1,983,893 width=238) (actual time=0.010..0.010 rows=1 loops=1)

  • Filter: ((description = 'Arrive'::text) AND (agenciesid = 1))
  • Rows Removed by Filter: 2
5. 0.013 0.013 ↑ 1.0 1 1

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

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

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