# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.006 | 914.070 | ↑ 200.0 | 1 | 1 |
→
HashAggregate (cost=1,798,027.24..1,798,029.24 rows=200 width=318) (actual time=914.070..914.070 rows=1 loops=1)
|
2. | 0.321 | 914.064 | ↑ 91,920,435.0 | 1 | 1 |
→
Merge Join (cost=188,445.30..1,568,226.15 rows=91,920,435 width=318) (actual time=913.901..914.064 rows=1 loops=1)
|
3. | 1.759 | 176.774 | ↑ 19.2 | 4,199 | 1 |
→
Sort (cost=32,199.57..32,400.90 rows=80,531 width=322) (actual time=176.618..176.774 rows=4,199 loops=1)
|
4. | 175.015 | 175.015 | ↑ 19.2 | 4,201 | 1 |
→
Seq Scan on movie m (cost=0.00..13,523.90 rows=80,531 width=322) (actual time=0.128..175.015 rows=4,201 loops=1)
|
5. | 0.047 | 736.969 | ↑ 425.9 | 536 | 1 |
→
Materialize (cost=156,245.72..157,387.15 rows=228,286 width=4) (actual time=736.899..736.969 rows=536 loops=1) |
6. | 0.000 | 736.922 | ↑ 425.9 | 536 | 1 |
→
Sort (cost=156,245.72..156,816.44 rows=228,286 width=4) (actual time=736.895..736.922 rows=536 loops=1)
|
7. | 3.315 | 738.328 | ↑ 425.9 | 536 | 1 |
→
Gather (cost=15,994.66..132,805.72 rows=228,286 width=4) (actual time=224.883..738.328 rows=536 loops=1)
|
8. | 260.629 | 735.013 | ↑ 531.4 | 179 | 3 |
→
Parallel Hash Join (cost=14,994.66..108,977.12 rows=95,119 width=4) (actual time=223.177..735.013 rows=179 loops=3)
|
9. | 414.813 | 414.813 | ↓ 2.4 | 3,815,282 | 3 |
→
Parallel Seq Scan on casts c (cost=0.00..87,641.18 rows=1,585,318 width=8) (actual time=0.037..414.813 rows=3,815,282 loops=3) |
10. | 0.025 | 59.571 | ↓ 0.0 | 0 | 3 |
→
Parallel Hash (cost=14,994.60..14,994.60 rows=5 width=4) (actual time=59.571..59.571 rows=0 loops=3)
|
11. | 59.546 | 59.546 | ↓ 0.0 | 0 | 3 |
→
Parallel Seq Scan on actor a (cost=0.00..14,994.60 rows=5 width=4) (actual time=44.181..59.546 rows=0 loops=3)
|
Planning time | : | 0.519 ms |
---|---|---|
Execution time | : | 915.769 ms |