# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 9.955 | 9,110.966 | ↑ 1.0 | 1 | 1 |
→
Gather (cost=161,937.89..180,456.19 rows=1 width=17) (actual time=9,066.694..9,110.966 rows=1 loops=1)
|
2. | 3.576 | 9,101.011 | ↓ 0.0 | 0 | 3 |
→
Parallel Hash Join (cost=160,937.89..179,456.09 rows=1 width=17) (actual time=9,087.709..9,101.011 rows=0 loops=3)
|
3. | 64.562 | 64.562 | ↑ 1.3 | 1,400 | 3 |
→
Parallel Seq Scan on movie m (cost=0.00..18,511.35 rows=1,824 width=21) (actual time=0.390..64.562 rows=1,400 loops=3)
|
4. | 1.214 | 9,032.873 | ↓ 89.5 | 179 | 3 |
→
Parallel Hash (cost=160,937.86..160,937.86 rows=2 width=4) (actual time=9,032.872..9,032.873 rows=179 loops=3)
|
5. | 4,441.690 | 9,031.659 | ↓ 89.5 | 179 | 3 |
→
Parallel Hash Join (cost=23,592.48..160,937.86 rows=2 width=4) (actual time=2,194.410..9,031.659 rows=179 loops=3)
|
6. | 4,505.336 | 4,505.336 | ↑ 1.2 | 3,815,282 | 3 |
→
Parallel Seq Scan on casts c (cost=0.00..119,466.08 rows=4,767,808 width=8) (actual time=0.047..4,505.336 rows=3,815,282 loops=3) |
7. | 0.229 | 84.633 | ↓ 0.0 | 0 | 3 |
→
Parallel Hash (cost=23,592.46..23,592.46 rows=1 width=4) (actual time=84.631..84.633 rows=0 loops=3)
|
8. | 84.404 | 84.404 | ↓ 0.0 | 0 | 3 |
→
Parallel Seq Scan on actor a (cost=0.00..23,592.46 rows=1 width=4) (actual time=62.403..84.404 rows=0 loops=3)
|