explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5YAf

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 476.679 ↑ 1.0 1 1

Limit (cost=7,727.49..7,727.49 rows=1 width=17) (actual time=476.675..476.679 rows=1 loops=1)

2. 2.183 476.674 ↑ 4,451.0 1 1

Sort (cost=7,727.49..7,738.61 rows=4,451 width=17) (actual time=476.674..476.674 rows=1 loops=1)

  • Sort Key: fresh_phone_commitments.commitment
  • Sort Method: top-N heapsort Memory: 25kB
3. 80.083 474.491 ↓ 1.6 7,133 1

Hash Join (cost=1,659.23..7,705.23 rows=4,451 width=17) (actual time=116.136..474.491 rows=7,133 loops=1)

  • Hash Cond: ((fresh_phone_commitments.phone_number)::text = (all_phone_numbers.phone_number)::text)
4. 379.502 379.502 ↑ 1.0 84,489 1

Index Only Scan using fresh_phone_commitments_testing_idx on fresh_phone_commitments (cost=0.43..5,683.89 rows=84,811 width=17) (actual time=0.046..379.502 rows=84,489 loops=1)

  • Index Cond: (truncated_day = date_trunc('day'::text, timezone('Pacific/Honolulu'::text, CURRENT_TIMESTAMP)))
  • Heap Fetches: 83998
5. 3.554 14.906 ↓ 1.2 7,133 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 378kB
6. 10.624 11.352 ↓ 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.822..11.352 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
7. 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.373 ms
Execution time : 476.764 ms