explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JZr9 : 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

Settings

Optimization path:

Optimization(s) for this plan:

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

Limit (cost=0.86..2.85 rows=1 width=212) (actual time=27.919..27.919 rows=1 loops=1)

2. 27.848 27.917 ↑ 2,040,615.0 1 1

Nested Loop (cost=0.86..4,068,801.40 rows=2,040,615 width=212) (actual time=27.917..27.917 rows=1 loops=1)

3. 0.001 0.024 ↑ 2,015,726.0 1 1

Nested Loop (cost=0.43..1,421,230.02 rows=2,015,726 width=183) (actual time=0.024..0.024 rows=1 loops=1)

4. 0.006 0.006 ↑ 2,015,726.0 1 1

Seq Scan on z_yrk_cad_unit_resp_arrive r (cost=0.00..164,551.38 rows=2,015,726 width=155) (actual time=0.006..0.006 rows=1 loops=1)

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

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

  • Index Cond: (cfsid = r.cfsid)
6. 0.045 0.045 ↑ 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.045..0.045 rows=1 loops=1)

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