explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4yqf

Settings
# exclusive inclusive rows x rows loops node
1. 31.091 344.907 ↓ 0.0 0 1

Gather (cost=9,032.34..10,858.20 rows=2,146 width=17) (actual time=330.449..344.907 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 3.916 313.816 ↓ 0.0 0 2 / 2

Parallel Hash Anti Join (cost=8,032.34..9,643.60 rows=1,262 width=17) (actual time=313.814..313.816 rows=0 loops=2)

  • Hash Cond: ((all_phone_numbers.phone_number)::text = (fresh_phone_commitments.phone_number)::text)
3. 6.740 8.122 ↓ 1.1 3,566 2 / 2

Parallel Bitmap Heap Scan on all_phone_numbers (cost=249.04..1,560.15 rows=3,387 width=13) (actual time=6.311..8.122 rows=3,566 loops=2)

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

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

  • Index Cond: (sending_location_id = ANY ('{39cd1fe8-408d-11ea-b4e6-0bfb129c5e83}'::uuid[]))
5. 62.471 301.778 ↓ 1.2 41,822 2 / 2

Parallel Hash (cost=7,347.20..7,347.20 rows=34,888 width=13) (actual time=301.777..301.778 rows=41,822 loops=2)

  • Buckets: 131072 Batches: 1 Memory Usage: 4960kB
6. 239.307 239.307 ↓ 1.2 41,822 2 / 2

Parallel Index Only Scan using fresh_phone_commitments_pkey on fresh_phone_commitments (cost=0.43..7,347.20 rows=34,888 width=13) (actual time=0.069..239.307 rows=41,822 loops=2)

  • Index Cond: (truncated_day = '2020-01-31 00:00:00'::timestamp without time zone)
  • Heap Fetches: 75578
Planning time : 0.708 ms
Execution time : 344.979 ms