# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 8.552 | 426.648 | ↑ 1.0 | 1 | 1 |
→
Gather (cost=19,534.15..150,934.36 rows=1 width=17) (actual time=422.608..426.648 rows=1 loops=1)
|
2. | 2.685 | 418.096 | ↓ 0.0 | 0 | 3 |
→
Parallel Hash Join (cost=18,534.15..149,934.26 rows=1 width=17) (actual time=331.027..418.096 rows=0 loops=3)
|
3. | 345.975 | 345.975 | ↓ 2.5 | 179 | 3 |
→
Parallel Seq Scan on casts (cost=0.00..131,399.83 rows=71 width=4) (actual time=84.652..345.975 rows=179 loops=3)
|
4. | 2.435 | 69.436 | ↑ 1.3 | 1,400 | 3 |
→
Parallel Hash (cost=18,511.35..18,511.35 rows=1,824 width=21) (actual time=69.434..69.436 rows=1,400 loops=3)
|
5. | 67.001 | 67.001 | ↑ 1.3 | 1,400 | 3 |
→
Parallel Seq Scan on movie (cost=0.00..18,511.35 rows=1,824 width=21) (actual time=0.113..67.001 rows=1,400 loops=3)
|
Planning time | : | 0.199 ms |
---|---|---|
Execution time | : | 426.700 ms |