#	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) Workers Planned: 2 Workers Launched: 2
2.	2.685	418.096	↓ 0.0	0	3 / 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) Hash Cond: (casts.mid = movie.id)
3.	345.975	345.975	↓ 2.5	179	3 / 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) Filter: (pid = 429,073) Rows Removed by Filter: 3,815,104
4.	2.435	69.436	↑ 1.3	1,400	3 / 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) Buckets: 8,192 Batches: 1 Memory Usage: 352kB
5.	67.001	67.001	↑ 1.3	1,400	3 / 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) Filter: (year > 2010) Rows Removed by Filter: 511,070

Planning time	:	0.199 ms
Execution time	:	426.700 ms

                                                              QUERY PLAN                                                              
--------------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=19534.15..150934.36 rows=1 width=17) (actual time=422.608..426.648 rows=1 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   ->  Parallel Hash Join  (cost=18534.15..149934.26 rows=1 width=17) (actual time=331.027..418.096 rows=0 loops=3)
         Hash Cond: (casts.mid = movie.id)
         ->  Parallel Seq Scan on casts  (cost=0.00..131399.83 rows=71 width=4) (actual time=84.652..345.975 rows=179 loops=3)
               Filter: (pid = 429073)
               Rows Removed by Filter: 3815104
         ->  Parallel Hash  (cost=18511.35..18511.35 rows=1824 width=21) (actual time=69.434..69.436 rows=1400 loops=3)
               Buckets: 8192  Batches: 1  Memory Usage: 352kB
               ->  Parallel Seq Scan on movie  (cost=0.00..18511.35 rows=1824 width=21) (actual time=0.113..67.001 rows=1400 loops=3)
                     Filter: (year > 2010)
                     Rows Removed by Filter: 511070
 Planning Time: 0.199 ms
 Execution Time: 426.700 ms
(15 rows)

Per node type stats

node type	count	sum of times	% of query
Gather	1	8.552 ms	2.0 %
Parallel Hash	1	2.435 ms	0.6 %
Parallel Hash Join	1	2.685 ms	0.6 %
Parallel Seq Scan	2	412.976 ms	96.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
casts	1	345.975 ms	81.1 %
Parallel Seq Scan	1	345.975 ms	100.0 %
movie	1	67.001 ms	15.7 %
Parallel Seq Scan	1	67.001 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7WMKy

Color mode:

Visible columns:

Per node type stats

Per table stats