explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 154.125 ↑ 1.0 1 1

Limit (cost=0.86..2.16 rows=1 width=58) (actual time=154.125..154.125 rows=1 loops=1)

2. 16.964 154.124 ↑ 2,852,199.0 1 1

Nested Loop (cost=0.86..3,707,323.49 rows=2,852,199 width=58) (actual time=154.124..154.124 rows=1 loops=1)

3. 0.021 137.024 ↑ 649,130.5 4 1

Nested Loop (cost=0.43..1,650,488.91 rows=2,596,522 width=36) (actual time=135.659..137.024 rows=4 loops=1)

4. 1.963 1.963 ↑ 641,213.2 4 1

Seq Scan on yrk_callforservice cfs (cost=0.00..345,897.53 rows=2,564,853 width=12) (actual time=0.760..1.963 rows=4 loops=1)

5. 135.040 135.040 ↑ 1.0 1 4

Index Scan using stg_combined_incidents_wtrun_convertedid_idx on stg_combined_incidents ci (cost=0.43..0.50 rows=1 width=40) (actual time=33.760..33.760 rows=1 loops=4)

  • Index Cond: ((wtrun = 101) AND (convertedid = cfs.yrk_callforservice_zid))
6. 0.136 0.136 ↓ 0.0 0 4

Index Scan using distinct_unit_index on z_distinct_unit u (cost=0.43..0.49 rows=2 width=30) (actual time=0.034..0.034 rows=0 loops=4)

  • Index Cond: ((cfsid = cfs.cfsid) AND (cad_unitsid IS NOT NULL))
Planning time : 0.630 ms
Execution time : 154.188 ms