explain.depesz.com

PostgreSQL's explain analyze made readable

Result: loqx

Settings
# exclusive inclusive rows x rows loops node
1. 1,610.924 2,886.028 ↑ 1.0 148,293 1

Bitmap Heap Scan on calls c (cost=75,965.05..281,332.13 rows=154,664 width=484) (actual time=1,324.821..2,886.028 rows=148,293 loops=1)

  • Recheck Cond: ((property_id = ANY ('{103618,264930,93367,189068}'::integer[])) OR ((property_id IS NULL) AND (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)))
  • Filter: (((cid = 3049) AND (month_number >= 109) AND (month_number <= 111) AND (call_result_id IS DISTINCT FROM 13) AND (call_type_id <> 31) AND (deleted_on IS NULL) AND (is_test_call = 0) AND (is_auto_detected = 0) AND (call_result_id IS DISTINCT FROM 136) AND (property_id = ANY ('{103618,264930,93367,189068}'::integer[]))) OR ((property_id IS NULL) AND (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)))
  • Rows Removed by Filter: 46053
  • Heap Blocks: exact=192018
2. 54.449 1,275.104 ↓ 0.0 0 1

BitmapOr (cost=75,965.05..75,965.05 rows=207,702 width=0) (actual time=1,275.104..1,275.104 rows=0 loops=1)

3. 28.389 28.389 ↓ 2.0 106,254 1

Bitmap Index Scan on idx_calls_property_id (cost=0.00..560.24 rows=53,063 width=0) (actual time=28.389..28.389 rows=106,254 loops=1)

  • Index Cond: (property_id = ANY ('{103618,264930,93367,189068}'::integer[]))
4. 83.519 1,192.266 ↓ 0.0 0 1

BitmapAnd (cost=75,365.89..75,365.89 rows=154,640 width=0) (actual time=1,192.266..1,192.266 rows=0 loops=1)

5. 547.338 547.338 ↑ 1.1 3,155,547 1

Bitmap Index Scan on idx_calls_property_id (cost=0.00..36,414.15 rows=3,469,545 width=0) (actual time=547.338..547.338 rows=3,155,547 loops=1)

  • Index Cond: (property_id IS NULL)
6. 561.409 561.409 ↓ 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=561.409..561.409 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))
Planning time : 0.934 ms