explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v5Ey

Settings
# exclusive inclusive rows x rows loops node
1. 33.399 1,117.625 ↑ 2.9 68,316 1

Nested Loop (cost=187,543.72..429,131.36 rows=198,328 width=8) (actual time=702.263..1,117.625 rows=68,316 loops=1)

2. 19.656 947.594 ↑ 2.9 68,316 1

Nested Loop (cost=187,543.29..329,694.78 rows=198,328 width=8) (actual time=702.251..947.594 rows=68,316 loops=1)

3. 38.120 722.990 ↑ 2.9 68,316 1

HashAggregate (cost=187,542.86..189,526.14 rows=198,328 width=4) (actual time=702.236..722.990 rows=68,316 loops=1)

  • Group Key: ae.apprequest_id
4. 399.763 684.870 ↑ 2.9 68,316 1

Hash Semi Join (cost=83,899.50..187,047.04 rows=198,328 width=4) (actual time=125.300..684.870 rows=68,316 loops=1)

  • Hash Cond: (ae.event_id = e.id)
5. 162.483 162.483 ↑ 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.009..162.483 rows=2,947,415 loops=1)

6. 12.933 122.624 ↑ 2.9 68,316 1

Hash (cost=81,420.40..81,420.40 rows=198,328 width=4) (actual time=122.624..122.624 rows=68,316 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 4450kB
7. 75.198 109.691 ↑ 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=41.677..109.691 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. 34.493 34.493 ↓ 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=34.493..34.493 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