explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 28bt

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 1,385.066 ↑ 1.0 10 1

Limit (cost=71,842.72..71,842.75 rows=10 width=292) (actual time=1,385.056..1,385.066 rows=10 loops=1)

  • Planning time: 1.118 ms
  • Execution time: 1389.075 ms
2. 0.075 1,385.055 ↑ 29.5 10 1

Sort (cost=71,842.72..71,843.46 rows=295 width=292) (actual time=1,385.054..1,385.055 rows=10 loops=1)

  • Sort Key: c.id DESC
  • Sort Method: top-N heapsort Memory: 27kB
3. 0.114 1,384.980 ↑ 6.1 48 1

Nested Loop Left Join (cost=40,686.54..71,836.35 rows=295 width=292) (actual time=1,370.169..1,384.980 rows=48 loops=1)

4. 17.718 1,384.722 ↑ 6.1 48 1

Bitmap Heap Scan on calls c (cost=40,686.25..69,880.16 rows=295 width=300) (actual time=1,370.097..1,384.722 rows=48 loops=1)

  • Recheck Cond: ((call_datetime >= '02/01/2019 00:00:00 MST'::timestamp with time zone) AND (call_datetime <= '02/10/2019 23:59:59 MST'::timestamp with time zone) AND (cid = 12859))
  • Filter: ((deleted_on IS NULL) AND (call_result_id IS DISTINCT FROM 13) AND (call_type_id <> 31) AND (call_result_id IS DISTINCT FROM 136) AND ((property_id = 218099) OR (property_id IS NULL)) AND (is_test_call = 0) AND (is_auto_detected = 0) AND (call_result_id = ANY ('{2,3,6,7,8,9,10,11,12,29,141}'::integer[])))
  • Rows Removed by Filter: 10198
  • Heap Blocks: exact=6190
5. 13.047 1,367.004 ↓ 0.0 0 1

BitmapAnd (cost=40,686.25..40,686.25 rows=7,615 width=0) (actual time=1,367.004..1,367.004 rows=0 loops=1)

6. 27.776 27.776 ↑ 1.0 260,504 1

Bitmap Index Scan on calls_call_datetime_idx (cost=0.00..5,717.44 rows=272,488 width=0) (actual time=27.776..27.776 rows=260,504 loops=1)

  • Index Cond: ((call_datetime >= '02/01/2019 00:00:00 MST'::timestamp with time zone) AND (call_datetime <= '02/10/2019 23:59:59 MST'::timestamp with time zone))
7. 1,326.181 1,326.181 ↓ 1.0 1,566,599 1

Bitmap Index Scan on idx_calls_ivr_menu_action_id (cost=0.00..34,968.40 rows=1,548,245 width=0) (actual time=1,326.181..1,326.181 rows=1,566,599 loops=1)

  • Index Cond: (cid = 12859)
8. 0.144 0.144 ↑ 1.0 1 48

Index Scan using pk_call_phone_numbers on call_phone_numbers cpn (cost=0.29..6.63 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=48)

  • Index Cond: (id = c.call_phone_number_id)