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