explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7rjC

Settings
# exclusive inclusive rows x rows loops node
1. 109.667 2,076.578 ↓ 147.9 184,851 1

Gather (cost=132,073.13..461,758.71 rows=1,250 width=484) (actual time=1,845.675..2,076.578 rows=184,851 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 136.598 1,966.911 ↓ 118.3 61,617 3

Parallel Bitmap Heap Scan on calls c (cost=131,073.13..460,633.71 rows=521 width=484) (actual time=1,836.820..1,966.911 rows=61,617 loops=3)

  • Recheck Cond: ((call_datetime >= '2018-01-01 00:00:00-07'::timestamp with time zone) AND (call_datetime <= '2018-03-10 23:59:59-07'::timestamp with time zone) AND (cid = 3049))
  • Filter: ((deleted_on IS NULL) AND (month_number >= 109) AND (month_number <= 111) AND (call_result_id IS DISTINCT FROM 13) AND (call_type_id <> 31) AND (call_result_id IS DISTINCT FROM 136) AND (is_test_call = 0) AND (is_auto_detected = 0))
  • Rows Removed by Filter: 44995
  • Heap Blocks: exact=5359
3. 46.485 1,830.313 ↓ 0.0 0 1

BitmapAnd (cost=131,073.13..131,073.13 rows=354,280 width=0) (actual time=1,830.313..1,830.313 rows=0 loops=1)

4. 926.855 926.855 ↓ 1.2 3,362,603 1

Bitmap Index Scan on calls_call_datetime_idx (cost=0.00..38,874.15 rows=2,778,959 width=0) (actual time=926.854..926.855 rows=3,362,603 loops=1)

  • Index Cond: ((call_datetime >= '2018-01-01 00:00:00-07'::timestamp with time zone) AND (call_datetime <= '2018-03-10 23:59:59-07'::timestamp with time zone))
5. 856.973 856.973 ↑ 1.0 7,596,400 1

Bitmap Index Scan on idx_calls_ivr_menu_action_id (cost=0.00..92,198.10 rows=7,948,738 width=0) (actual time=856.972..856.973 rows=7,596,400 loops=1)

  • Index Cond: (cid = 3049)