explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tFQv

Settings
# exclusive inclusive rows x rows loops node
1. 1,238.270 3,793.861 ↓ 184.4 140,859 1

Bitmap Heap Scan on calls c (cost=99,089.83..248,814.69 rows=764 width=484) (actual time=2,651.946..3,793.861 rows=140,859 loops=1)

  • Recheck Cond: ((call_datetime >= '2018-01-01 00:00:00-07'::timestamp with time zone) AND (call_datetime <= '2018-02-01 23:59:59-07'::timestamp with time zone) AND (cid = 3049))
  • Filter: ((month_number >= 109) AND (month_number <= 111))
  • Heap Blocks: exact=105928
2. 53.951 2,555.591 ↓ 0.0 0 1

BitmapAnd (cost=99,089.83..99,089.83 rows=152,794 width=0) (actual time=2,555.591..2,555.591 rows=0 loops=1)

3. 295.601 295.601 ↓ 1.1 1,286,638 1

Bitmap Index Scan on calls_call_datetime_idx (cost=0.00..15,562.65 rows=1,198,508 width=0) (actual time=295.601..295.601 rows=1,286,638 loops=1)

  • Index Cond: ((call_datetime >= '2018-01-01 00:00:00-07'::timestamp with time zone) AND (call_datetime <= '2018-02-01 23:59:59-07'::timestamp with time zone))
4. 2,206.039 2,206.039 ↓ 1.0 7,415,058 1

Bitmap Index Scan on idx_calls_ivr_menu_action_id (cost=0.00..83,526.55 rows=7,386,665 width=0) (actual time=2,206.039..2,206.039 rows=7,415,058 loops=1)

  • Index Cond: (cid = 3049)