explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2o1B

Settings
# 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