explain.depesz.com

A tool for finding a real cause for slow queries.

Result: I5F

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 410.937 83,858.206 ↑ 1.0 1 1

Aggregate (cost=1,246,413.19..1,246,413.20 rows=1 width=4) (actual time=83,858.206..83,858.206 rows=1 loops=1)

2. 7,368.634 83,447.269 ↓ 1.0 4,872,449 1

Bitmap Heap Scan on system_emails (cost=88,641.53..1,234,586.11 rows=4,730,829 width=4) (actual time=76,236.081..83,447.269 rows=4,872,449 loops=1)

  • Recheck Cond: (system_email_type_id = ANY ('{6,11,7,12,9,8}'::integer[]))
  • Filter: (is_suspended = 0)
3. 76,078.635 76,078.635 ↓ 1.0 4,875,590 1

Bitmap Index Scan on idx_system_emails_system_email_type_id (cost=0.00..87,458.83 rows=4,730,829 width=0) (actual time=76,078.635..76,078.635 rows=4,875,590 loops=1)

  • Index Cond: (system_email_type_id = ANY ('{6,11,7,12,9,8}'::integer[]))