explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Hc04

Settings
# exclusive inclusive rows x rows loops node
1. 55.454 69.705 ↑ 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=19.081..69.705 rows=125,699 loops=1)

  • Recheck Cond: ((hub_id = 39) AND (email_id = ANY ('{HubNowManualMessage,HubScheduledManualMessage,HubFutureManualMessage}'::text[])))
  • Heap Blocks: exact=27030
2. 14.251 14.251 ↑ 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=14.251..14.251 rows=125,699 loops=1)

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