explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gju3

Settings
# exclusive inclusive rows x rows loops node
1. 72.493 83.124 ↑ 1.3 102,631 1

Bitmap Heap Scan on email_history e (cost=1,735.73..151,396.11 rows=132,495 width=4) (actual time=14.741..83.124 rows=102,631 loops=1)

  • Recheck Cond: ((hub_id = 39) AND (email_id = 'HubNowManualMessage'::text))
  • Heap Blocks: exact=25399
2. 10.631 10.631 ↑ 1.3 102,631 1

Bitmap Index Scan on email_history_hub_email_ix (cost=0.00..1,729.10 rows=132,495 width=0) (actual time=10.630..10.631 rows=102,631 loops=1)

  • Index Cond: ((hub_id = 39) AND (email_id = 'HubNowManualMessage'::text))
Planning time : 0.896 ms
Execution time : 87.136 ms