#	exclusive	inclusive	rows x	rows	loops	node
1.	4.592	109.532	↓ 0.0	0	1	→ Gather (cost=24,592.48..43,109.53 rows=1 width=17) (actual time=108.217..109.532 rows=0 loops=1) Workers Planned: 2 Workers Launched: 2
2.	0.450	104.940	↓ 0.0	0	3	→ Parallel Hash Join (cost=23,592.48..42,109.43 rows=1 width=17) (actual time=104.939..104.940 rows=0 loops=3) Hash Cond: (m.id = a.id)
3.	43.741	43.741	↑ 1.1	1,400	3	→ Parallel Seq Scan on movie m (cost=0.00..18,511.35 rows=1,491 width=21) (actual time=0.105..43.741 rows=1,400 loops=3) Filter: (year > 2010) Rows Removed by Filter: 511070
4.	0.046	60.749	↓ 0.0	0	3	→ Parallel Hash (cost=23,592.46..23,592.46 rows=1 width=4) (actual time=60.749..60.749 rows=0 loops=3) Buckets: 1024 Batches: 1 Memory Usage: 40kB
5.	60.703	60.703	↓ 0.0	0	3	→ Parallel Seq Scan on actor a (cost=0.00..23,592.46 rows=1 width=4) (actual time=46.048..60.703 rows=0 loops=3) Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text)) Rows Removed by Filter: 621678

Planning time	:	0.227 ms
Execution time	:	109.569 ms

                                                            QUERY PLAN                                                            
----------------------------------------------------------------------------------------------------------------------------------
 Gather  (cost=24592.48..43109.53 rows=1 width=17) (actual time=108.217..109.532 rows=0 loops=1)
   Workers Planned: 2
   Workers Launched: 2
   ->  Parallel Hash Join  (cost=23592.48..42109.43 rows=1 width=17) (actual time=104.939..104.940 rows=0 loops=3)
         Hash Cond: (m.id = a.id)
         ->  Parallel Seq Scan on movie m  (cost=0.00..18511.35 rows=1491 width=21) (actual time=0.105..43.741 rows=1400 loops=3)
               Filter: (year > 2010)
               Rows Removed by Filter: 511070
         ->  Parallel Hash  (cost=23592.46..23592.46 rows=1 width=4) (actual time=60.749..60.749 rows=0 loops=3)
               Buckets: 1024  Batches: 1  Memory Usage: 40kB
               ->  Parallel Seq Scan on actor a  (cost=0.00..23592.46 rows=1 width=4) (actual time=46.048..60.703 rows=0 loops=3)
                     Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
                     Rows Removed by Filter: 621678
 Planning Time: 0.227 ms
 Execution Time: 109.569 ms
(15 rows)

Per node type stats

node type	count	sum of times	% of query
Gather	1	4.592 ms	4.2 %
Parallel Hash	1	0.046 ms	0.0 %
Parallel Hash Join	1	0.450 ms	0.4 %
Parallel Seq Scan	2	104.444 ms	95.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
actor	1	60.703 ms	55.4 %
Parallel Seq Scan	1	60.703 ms	100.0 %
movie	1	43.741 ms	39.9 %
Parallel Seq Scan	1	43.741 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RbRg

Color mode:

Visible columns:

Per node type stats

Per table stats