#	exclusive	inclusive	rows x	rows	loops	node
1.	36.976	1,168.537	↑ 2.9	68,316	1	→ Nested Loop (cost=187,543.72..429,131.36 rows=198,328 width=8) (actual time=747.841..1,168.537 rows=68,316 loops=1)
2.	21.363	994.929	↑ 2.9	68,316	1	→ Nested Loop (cost=187,543.29..329,694.78 rows=198,328 width=8) (actual time=747.828..994.929 rows=68,316 loops=1)
3.	38.936	768.618	↑ 2.9	68,316	1	→ HashAggregate (cost=187,542.86..189,526.14 rows=198,328 width=4) (actual time=747.814..768.618 rows=68,316 loops=1) Group Key: ae.apprequest_id
4.	427.800	729.682	↑ 2.9	68,316	1	→ Hash Semi Join (cost=83,899.50..187,047.04 rows=198,328 width=4) (actual time=135.072..729.682 rows=68,316 loops=1) Hash Cond: (ae.event_id = e.id)
5.	171.056	171.056	↑ 1.0	2,947,415	1	→ Seq Scan on omaha_apprequest_events ae (cost=0.00..93,203.75 rows=2,947,575 width=8) (actual time=0.008..171.056 rows=2,947,415 loops=1)
6.	12.862	130.826	↑ 2.9	68,316	1	→ Hash (cost=81,420.40..81,420.40 rows=198,328 width=4) (actual time=130.826..130.826 rows=68,316 loops=1) Buckets: 262144 Batches: 1 Memory Usage: 4450kB
7.	77.685	117.964	↑ 2.9	68,316	1	→ Bitmap Heap Scan on omaha_event e (cost=3,900.14..81,420.40 rows=198,328 width=4) (actual time=48.894..117.964 rows=68,316 loops=1) Recheck Cond: (eventresult = 1) Filter: (eventtype = ANY ('{2,3}'::integer[])) Rows Removed by Filter: 143116 Heap Blocks: exact=44814
8.	40.279	40.279	↓ 1.0	211,432	1	→ Bitmap Index Scan on omaha_event_eventresult (cost=0.00..3,850.56 rows=208,284 width=0) (actual time=40.279..40.279 rows=211,432 loops=1) Index Cond: (eventresult = 1)
9.	204.948	204.948	↑ 1.0	1	68,316	→ Index Scan using omaha_apprequest_pkey on omaha_apprequest ar (cost=0.43..0.70 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=68,316) Index Cond: (id = ae.apprequest_id)
10.	136.632	136.632	↑ 1.0	1	68,316	→ Index Only Scan using omaha_request_pkey on omaha_request r (cost=0.43..0.49 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=68,316) Index Cond: (id = ar.request_id) Heap Fetches: 0

QUERY PLAN                                                                                  
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=187543.72..429131.36 rows=198328 width=8) (actual time=747.841..1168.537 rows=68316 loops=1)
   ->  Nested Loop  (cost=187543.29..329694.78 rows=198328 width=8) (actual time=747.828..994.929 rows=68316 loops=1)
         ->  HashAggregate  (cost=187542.86..189526.14 rows=198328 width=4) (actual time=747.814..768.618 rows=68316 loops=1)
               Group Key: ae.apprequest_id
               ->  Hash Semi Join  (cost=83899.50..187047.04 rows=198328 width=4) (actual time=135.072..729.682 rows=68316 loops=1)
                     Hash Cond: (ae.event_id = e.id)
                     ->  Seq Scan on omaha_apprequest_events ae  (cost=0.00..93203.75 rows=2947575 width=8) (actual time=0.008..171.056 rows=2947415 loops=1)
                     ->  Hash  (cost=81420.40..81420.40 rows=198328 width=4) (actual time=130.826..130.826 rows=68316 loops=1)
                           Buckets: 262144  Batches: 1  Memory Usage: 4450kB
                           ->  Bitmap Heap Scan on omaha_event e  (cost=3900.14..81420.40 rows=198328 width=4) (actual time=48.894..117.964 rows=68316 loops=1)
                                 Recheck Cond: (eventresult = 1)
                                 Filter: (eventtype = ANY ('{2,3}'::integer[]))
                                 Rows Removed by Filter: 143116
                                 Heap Blocks: exact=44814
                                 ->  Bitmap Index Scan on omaha_event_eventresult  (cost=0.00..3850.56 rows=208284 width=0) (actual time=40.279..40.279 rows=211432 loops=1)
                                       Index Cond: (eventresult = 1)
         ->  Index Scan using omaha_apprequest_pkey on omaha_apprequest ar  (cost=0.43..0.70 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=68316)
               Index Cond: (id = ae.apprequest_id)
   ->  Index Only Scan using omaha_request_pkey on omaha_request r  (cost=0.43..0.49 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=68316)
         Index Cond: (id = ar.request_id)
         Heap Fetches: 0
 Planning time: 26.458 ms
 Execution time: 1172.783 ms
(23 rows)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	77.685 ms	6.6 %
Bitmap Index Scan	1	40.279 ms	3.4 %
Hash	1	12.862 ms	1.1 %
Hash Semi Join	1	427.800 ms	36.6 %
HashAggregate	1	38.936 ms	3.3 %
Index Only Scan	1	136.632 ms	11.7 %
Index Scan	1	204.948 ms	17.5 %
Nested Loop	2	58.339 ms	5.0 %
Seq Scan	1	171.056 ms	14.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
omaha_apprequest	1	204.948 ms	17.5 %
Index Scan	1	204.948 ms	100.0 %
omaha_apprequest_events	1	171.056 ms	14.6 %
Seq Scan	1	171.056 ms	100.0 %
omaha_event	1	77.685 ms	6.6 %
Bitmap Heap Scan	1	77.685 ms	100.0 %
omaha_request	1	136.632 ms	11.7 %
Index Only Scan	1	136.632 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2o1B

Color mode:

Visible columns:

Per node type stats

Per table stats