explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ktE

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

Limit (cost=0.99..1.89 rows=1 width=52) (actual time=0.081..0.082 rows=1 loops=1)

2. 0.032 0.080 ↑ 13,213,533.0 1 1

Nested Loop (cost=0.99..11,853,703.36 rows=13,213,533 width=52) (actual time=0.080..0.080 rows=1 loops=1)

3. 0.002 0.028 ↑ 3,209,892.0 1 1

Nested Loop (cost=0.43..1,941,377.10 rows=3,209,892 width=37) (actual time=0.028..0.028 rows=1 loops=1)

4. 0.007 0.007 ↑ 3,210,530.0 1 1

Seq Scan on stg_combined_incidents pt_cad (cost=0.00..172,799.62 rows=3,210,530 width=32) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: (wtrun = 101)
5. 0.019 0.019 ↑ 1.0 1 1

Index Scan using cad_active_calls_idx_zid on cad_active_calls cad (cost=0.43..0.54 rows=1 width=21) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: (cad_active_calls_zid = pt_cad.convertedid)
6. 0.020 0.020 ↑ 86.0 1 1

Index Scan using cad_call_log_idx_call_num on cad_call_log clog (cost=0.56..2.18 rows=86 width=33) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: (call_number = cad.call_number)
  • Filter: (z_unit_cad_units_1 IS NOT NULL)
Planning time : 0.593 ms
Execution time : 0.126 ms