explain.depesz.com

PostgreSQL's explain analyze made readable

Result: A2nr

Settings
# exclusive inclusive rows x rows loops node
1. 99.059 531.061 ↓ 0.0 0 1

Bitmap Heap Scan on all_phone_numbers (cost=8,844.90..10,197.08 rows=2,879 width=17) (actual time=531.061..531.061 rows=0 loops=1)

  • Recheck Cond: ((sending_location_id = ANY ('{39cd1fe8-408d-11ea-b4e6-0bfb129c5e83}'::uuid[])) AND (released_at IS NULL))
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 7133
  • Heap Blocks: exact=613
2. 0.753 0.753 ↓ 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.753..0.753 rows=7,133 loops=1)

  • Index Cond: (sending_location_id = ANY ('{39cd1fe8-408d-11ea-b4e6-0bfb129c5e83}'::uuid[]))
3.          

SubPlan (for Bitmap Heap Scan)

4. 431.249 431.249 ↑ 1.0 83,506 1

Index Only Scan using fresh_phone_commitments_pkey on fresh_phone_commitments (cost=0.43..8,385.89 rows=84,277 width=13) (actual time=0.037..431.249 rows=83,506 loops=1)

  • Index Cond: (truncated_day = date_trunc('day'::text, timezone('Pacific/Honolulu'::text, CURRENT_TIMESTAMP)))
  • Heap Fetches: 83356
Planning time : 0.191 ms
Execution time : 531.130 ms