explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 82yS

Settings
# exclusive inclusive rows x rows loops node
1. 21.432 3,553.044 ↑ 2.9 68,316 1

Nested Loop (cost=187,543.84..415,135.17 rows=198,328 width=8) (actual time=752.616..3,553.044 rows=68,316 loops=1)

2. 36.654 3,190.032 ↑ 2.9 68,316 1

Nested Loop (cost=187,543.41..315,698.59 rows=198,328 width=8) (actual time=727.743..3,190.032 rows=68,316 loops=1)

3. 52.674 762.318 ↑ 2.9 68,316 1

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

  • Group Key: ae.apprequest_id
4. 398.744 709.644 ↑ 2.9 68,316 1

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

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

6. 12.786 146.172 ↑ 2.9 68,316 1

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

  • Buckets: 262144 Batches: 1 Memory Usage: 4450kB
7. 77.813 133.386 ↑ 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=65.143..133.386 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. 55.573 55.573 ↓ 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=55.573..55.573 rows=211,432 loops=1)

  • Index Cond: (eventresult = 1)
9. 2,391.060 2,391.060 ↑ 1.0 1 68,316

Index Only Scan using omaha_apprequest_1 on omaha_apprequest ar (cost=0.56..0.63 rows=1 width=8) (actual time=0.035..0.035 rows=1 loops=68,316)

  • Index Cond: (id = ae.apprequest_id)
  • Heap Fetches: 0
10. 341.580 341.580 ↑ 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.005..0.005 rows=1 loops=68,316)

  • Index Cond: (id = ar.request_id)
  • Heap Fetches: 0