→
Gather
(cost=161,934.94..180,453.24
rows=1
width=17)
(actual
time=8,857.365..8,860.988
rows=1
loops=1)
- Workers Planned: 2
- Workers Launched: 2
- -> Parallel Hash Join (cost=160934.94..179453.14 rows=1 width=17) (actual time=8841.923..8853.684 rows=0 loops=3
- Hash Cond: (m.id = c.mid)
- -> Parallel Seq Scan on movie m (cost=0.00..18511.35 rows=1824 width=21) (actual time=0.054..54.948 rows=1
- Filter: (year > 2010)
- Rows Removed by Filter: 511070
- -> Parallel Hash (cost=160934.92..160934.92 rows=2 width=4) (actual time=8796.863..8796.864 rows=179 loops
- Buckets: 1024 Batches: 1 Memory Usage: 104kB
- -> Parallel Hash Join (cost=23592.48..160934.92 rows=2 width=4) (actual time=2130.910..8796.475 rows
- Hash Cond: (c.pid = a.id)
- -> Parallel Seq Scan on casts c (cost=0.00..119463.94 rows=4767594 width=8) (actual time=0.031
- -> Parallel Hash (cost=23592.46..23592.46 rows=1 width=4) (actual time=81.649..81.650 rows=0 l
- Buckets: 1024 Batches: 1 Memory Usage: 40kB
- -> Parallel Seq Scan on actor a (cost=0.00..23592.46 rows=1 width=4) (actual time=60.480
- Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
- Rows Removed by Filter: 621678