explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bcoX

Settings
# exclusive inclusive rows x rows loops node
1. 3.645 34.804 ↓ 0.0 0 1

Nested Loop Anti Join (cost=40.62..2,814.92 rows=248 width=13) (actual time=34.804..34.804 rows=0 loops=1)

2. 3.168 3.355 ↓ 4.7 1,324 1

Bitmap Heap Scan on all_phone_numbers (cost=40.20..1,502.00 rows=280 width=13) (actual time=0.444..3.355 rows=1,324 loops=1)

  • Recheck Cond: ((sending_location_id = ANY ('{622aac12-e63c-11ea-82c3-0ff4e0d1db9e}'::uuid[])) AND (released_at IS NULL))
  • Filter: (cordoned_at IS NULL)
  • Heap Blocks: exact=610
3. 0.187 0.187 ↓ 2.7 1,324 1

Bitmap Index Scan on active_phone_number_sending_location_idx (cost=0.00..40.12 rows=494 width=0) (actual time=0.187..0.187 rows=1,324 loops=1)

  • Index Cond: (sending_location_id = ANY ('{622aac12-e63c-11ea-82c3-0ff4e0d1db9e}'::uuid[]))
4. 27.804 27.804 ↑ 1.0 1 1,324

Index Only Scan using fresh_phone_commitments_pkey on fresh_phone_commitments (cost=0.42..4.69 rows=1 width=13) (actual time=0.021..0.021 rows=1 loops=1,324)

  • Index Cond: ((truncated_day = date_trunc('day'::text, timezone('Pacific/Honolulu'::text, CURRENT_TIMESTAMP))) AND (phone_number = (all_phone_numbers.phone_number)::text))
  • Heap Fetches: 1,099
Planning time : 1.499 ms
Execution time : 34.854 ms