# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1.150 | 949.042 | ↑ 18,384,087.0 | 5 | 1 |
→
Merge Join (cost=188,445.30..1,568,226.15 rows=91,920,435 width=318) (actual time=947.840..949.042 rows=5 loops=1)
|
2. | 5.948 | 191.006 | ↑ 4.6 | 17,666 | 1 |
→
Sort (cost=32,199.57..32,400.90 rows=80,531 width=322) (actual time=190.373..191.006 rows=17,666 loops=1)
|
3. | 185.058 | 185.058 | ↑ 4.5 | 17,717 | 1 |
→
Seq Scan on movie m (cost=0.00..13,523.90 rows=80,531 width=322) (actual time=0.107..185.058 rows=17,717 loops=1)
|
4. | 0.047 | 756.886 | ↑ 425.9 | 536 | 1 |
→
Materialize (cost=156,245.72..157,387.15 rows=228,286 width=4) (actual time=756.818..756.886 rows=536 loops=1) |
5. | 0.000 | 756.839 | ↑ 425.9 | 536 | 1 |
→
Sort (cost=156,245.72..156,816.44 rows=228,286 width=4) (actual time=756.813..756.839 rows=536 loops=1)
|
6. | 1.987 | 756.861 | ↑ 425.9 | 536 | 1 |
→
Gather (cost=15,994.66..132,805.72 rows=228,286 width=4) (actual time=228.745..756.861 rows=536 loops=1)
|
7. | 262.503 | 754.874 | ↑ 531.4 | 179 | 3 |
→
Parallel Hash Join (cost=14,994.66..108,977.12 rows=95,119 width=4) (actual time=227.003..754.874 rows=179 loops=3)
|
8. | 433.063 | 433.063 | ↓ 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.064..433.063 rows=3,815,282 loops=3) |
9. | 0.028 | 59.308 | ↓ 0.0 | 0 | 3 |
→
Parallel Hash (cost=14,994.60..14,994.60 rows=5 width=4) (actual time=59.308..59.308 rows=0 loops=3)
|
10. | 59.280 | 59.280 | ↓ 0.0 | 0 | 3 |
→
Parallel Seq Scan on actor a (cost=0.00..14,994.60 rows=5 width=4) (actual time=44.043..59.280 rows=0 loops=3)
|