explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d05w

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 11,923.193 11,976.587 ↑ 1.8 125,699 1

Bitmap Heap Scan on email_history e (cost=2,890.15..205,067.46 rows=224,299 width=4) (actual time=58.226..11,976.587 rows=125,699 loops=1)

  • Recheck Cond: ((hub_id = 39) AND (email_id = ANY ('{HubNowManualMessage,HubScheduledManualMessage,HubFutureManualMessage}'::text[])))
  • Heap Blocks: exact=27030
2. 53.394 53.394 ↑ 1.8 125,699 1

Bitmap Index Scan on email_history_hub_email_ix (cost=0.00..2,878.93 rows=224,299 width=0) (actual time=53.394..53.394 rows=125,699 loops=1)

  • Index Cond: ((hub_id = 39) AND (email_id = ANY ('{HubNowManualMessage,HubScheduledManualMessage,HubFutureManualMessage}'::text[])))