explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n6Lb

Settings
# exclusive inclusive rows x rows loops node
1. 295.716 1,936.671 ↓ 180.6 319,835 1

Bitmap Heap Scan on calls c (cost=131,073.39..463,438.69 rows=1,771 width=484) (actual time=1,652.522..1,936.671 rows=319,835 loops=1)

  • 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: ((month_number >= 109) AND (month_number <= 111))
  • Heap Blocks: exact=18958
2. 46.851 1,640.955 ↓ 0.0 0 1

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

3. 649.096 649.096 ↓ 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=649.096..649.096 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))
4. 945.008 945.008 ↑ 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=945.008..945.008 rows=7,596,400 loops=1)

  • Index Cond: (cid = 3049)