#	exclusive	inclusive	rows x	rows	loops	node
1.	410.937	83858.206	↑ 1.0	1	1	→ Aggregate (cost=1246413.19..1246413.20 rows=1 width=4) (actual time=83858.206..83858.206 rows=1 loops=1)
2.	7368.634	83447.269	↓ 1.0	4872449	1	→ Bitmap Heap Scan on system_emails (cost=88641.53..1234586.11 rows=4730829 width=4) (actual time=76236.081..83447.269 rows=4872449 loops=1) Recheck Cond: (system_email_type_id = ANY ('{6,11,7,12,9,8}'::integer[])) Filter: (is_suspended = 0)
3.	76078.635	76078.635	↓ 1.0	4875590	1	→ Bitmap Index Scan on idx_system_emails_system_email_type_id (cost=0.00..87458.83 rows=4730829 width=0) (actual time=76078.635..76078.635 rows=4875590 loops=1) Index Cond: (system_email_type_id = ANY ('{6,11,7,12,9,8}'::integer[]))

QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Aggregate  (cost=1246413.19..1246413.20 rows=1 width=4) (actual time=83858.206..83858.206 rows=1 loops=1)
   ->  Bitmap Heap Scan on system_emails  (cost=88641.53..1234586.11 rows=4730829 width=4) (actual time=76236.081..83447.269 rows=4872449 loops=1)
         Recheck Cond: (system_email_type_id = ANY ('{6,11,7,12,9,8}'::integer[]))
         Filter: (is_suspended = 0)
         ->  Bitmap Index Scan on idx_system_emails_system_email_type_id  (cost=0.00..87458.83 rows=4730829 width=0) (actual time=76078.635..76078.635 rows=4875590 loops=1)
               Index Cond: (system_email_type_id = ANY ('{6,11,7,12,9,8}'::integer[]))
 Total runtime: 83861.087 ms
(7 rows)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	410.937 ms	0.5 %
Bitmap Heap Scan	1	7368.634 ms	8.8 %
Bitmap Index Scan	1	76078.635 ms	90.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
system_emails	1	7368.634 ms	8.8 %
Bitmap Heap Scan	1	7368.634 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: I5F

Colorize:

Columns visibility:

Per node type stats

Per table stats