explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DC23

Settings
# exclusive inclusive rows x rows loops node
1. 43.442 161.035 ↓ 1.8 7,133 1

Hash Join (cost=7,027.52..20,668.45 rows=4,021 width=17) (actual time=17.058..161.035 rows=7,133 loops=1)

  • Hash Cond: ((fresh_phone_commitments.phone_number)::text = (all_phone_numbers.phone_number)::text)
2. 100.841 108.649 ↓ 1.1 83,945 1

Bitmap Heap Scan on fresh_phone_commitments (cost=5,368.73..18,682.14 rows=76,614 width=17) (actual time=8.040..108.649 rows=83,945 loops=1)

  • Recheck Cond: (truncated_day = date_trunc('day'::text, timezone('Pacific/Honolulu'::text, CURRENT_TIMESTAMP)))
  • Filter: (commitment <= 200)
  • Rows Removed by Filter: 29
  • Heap Blocks: exact=1380
3. 7.808 7.808 ↓ 1.0 84,053 1

Bitmap Index Scan on fresh_phone_commitments_pkey (cost=0.00..5,349.57 rows=83,885 width=0) (actual time=7.808..7.808 rows=84,053 loops=1)

  • Index Cond: (truncated_day = date_trunc('day'::text, timezone('Pacific/Honolulu'::text, CURRENT_TIMESTAMP)))
4. 4.319 8.944 ↓ 1.2 7,133 1

Hash (cost=1,586.82..1,586.82 rows=5,758 width=13) (actual time=8.943..8.944 rows=7,133 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 378kB
5. 3.897 4.625 ↓ 1.2 7,133 1

Bitmap Heap Scan on all_phone_numbers (cost=249.04..1,586.82 rows=5,758 width=13) (actual time=0.825..4.625 rows=7,133 loops=1)

  • Recheck Cond: ((sending_location_id = ANY ('{39cd1fe8-408d-11ea-b4e6-0bfb129c5e83}'::uuid[])) AND (released_at IS NULL))
  • Heap Blocks: exact=613
6. 0.728 0.728 ↓ 1.2 7,133 1

Bitmap Index Scan on active_phone_number_sending_location_idx (cost=0.00..247.60 rows=5,758 width=0) (actual time=0.728..0.728 rows=7,133 loops=1)

  • Index Cond: (sending_location_id = ANY ('{39cd1fe8-408d-11ea-b4e6-0bfb129c5e83}'::uuid[]))
Planning time : 0.539 ms
Execution time : 161.551 ms