#	exclusive	inclusive	rows x	rows	loops	node
1.	1.150	949.042	↑ 18,384,087.0	5	1	→ Merge Join (cost=188,445.30..1,568,226.15 rows=91,920,435 width=318) (actual time=947.840..949.042 rows=5 loops=1) Merge Cond: (m.id = c.mid)
2.	5.948	191.006	↑ 4.6	17,666	1	→ Sort (cost=32,199.57..32,400.90 rows=80,531 width=322) (actual time=190.373..191.006 rows=17,666 loops=1) Sort Key: m.id Sort Method: quicksort Memory: 1979kB
3.	185.058	185.058	↑ 4.5	17,717	1	→ Seq Scan on movie m (cost=0.00..13,523.90 rows=80,531 width=322) (actual time=0.107..185.058 rows=17,717 loops=1) Filter: (year >= 2010) Rows Removed by Filter: 1519694
4.	0.047	756.886	↑ 425.9	536	1	→ Materialize (cost=156,245.72..157,387.15 rows=228,286 width=4) (actual time=756.818..756.886 rows=536 loops=1)
5.	0.000	756.839	↑ 425.9	536	1	→ Sort (cost=156,245.72..156,816.44 rows=228,286 width=4) (actual time=756.813..756.839 rows=536 loops=1) Sort Key: c.mid Sort Method: quicksort Memory: 50kB
6.	1.987	756.861	↑ 425.9	536	1	→ Gather (cost=15,994.66..132,805.72 rows=228,286 width=4) (actual time=228.745..756.861 rows=536 loops=1) Workers Planned: 2 Workers Launched: 2
7.	262.503	754.874	↑ 531.4	179	3	→ Parallel Hash Join (cost=14,994.66..108,977.12 rows=95,119 width=4) (actual time=227.003..754.874 rows=179 loops=3) Hash Cond: (c.pid = a.id)
8.	433.063	433.063	↓ 2.4	3,815,282	3	→ Parallel Seq Scan on casts c (cost=0.00..87,641.18 rows=1,585,318 width=8) (actual time=0.064..433.063 rows=3,815,282 loops=3)
9.	0.028	59.308	↓ 0.0	0	3	→ Parallel Hash (cost=14,994.60..14,994.60 rows=5 width=4) (actual time=59.308..59.308 rows=0 loops=3) Buckets: 1024 Batches: 1 Memory Usage: 40kB
10.	59.280	59.280	↓ 0.0	0	3	→ Parallel Seq Scan on actor a (cost=0.00..14,994.60 rows=5 width=4) (actual time=44.043..59.280 rows=0 loops=3) Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text)) Rows Removed by Filter: 621678

 Merge Join  (cost=188445.30..1568226.15 rows=91920435 width=318) (actual time=947.840..949.042 rows=5 loops=1)
   Merge Cond: (m.id = c.mid)
   ->  Sort  (cost=32199.57..32400.90 rows=80531 width=322) (actual time=190.373..191.006 rows=17666 loops=1)
         Sort Key: m.id
         Sort Method: quicksort  Memory: 1979kB
         ->  Seq Scan on movie m  (cost=0.00..13523.90 rows=80531 width=322) (actual time=0.107..185.058 rows=17717 loops=1)
               Filter: (year >= 2010)
               Rows Removed by Filter: 1519694
   ->  Materialize  (cost=156245.72..157387.15 rows=228286 width=4) (actual time=756.818..756.886 rows=536 loops=1)
         ->  Sort  (cost=156245.72..156816.44 rows=228286 width=4) (actual time=756.813..756.839 rows=536 loops=1)
               Sort Key: c.mid
               Sort Method: quicksort  Memory: 50kB
               ->  Gather  (cost=15994.66..132805.72 rows=228286 width=4) (actual time=228.745..756.861 rows=536 loops=1)
                     Workers Planned: 2
                     Workers Launched: 2
                     ->  Parallel Hash Join  (cost=14994.66..108977.12 rows=95119 width=4) (actual time=227.003..754.874 rows=179 loops=3)
                           Hash Cond: (c.pid = a.id)
                           ->  Parallel Seq Scan on casts c  (cost=0.00..87641.18 rows=1585318 width=8) (actual time=0.064..433.063 rows=3815282 loops=3)
                           ->  Parallel Hash  (cost=14994.60..14994.60 rows=5 width=4) (actual time=59.308..59.308 rows=0 loops=3)
                                 Buckets: 1024  Batches: 1  Memory Usage: 40kB
                                 ->  Parallel Seq Scan on actor a  (cost=0.00..14994.60 rows=5 width=4) (actual time=44.043..59.280 rows=0 loops=3)
                                       Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
                                       Rows Removed by Filter: 621678

Per node type stats

node type	count	sum of times	% of query
Gather	1	1.987 ms	0.2 %
Materialize	1	0.047 ms	0.0 %
Merge Join	1	1.150 ms	0.1 %
Parallel Hash	1	0.028 ms	0.0 %
Parallel Hash Join	1	262.503 ms	27.7 %
Parallel Seq Scan	2	492.343 ms	51.9 %
Seq Scan	1	185.058 ms	19.5 %
Sort	2	5.948 ms	0.6 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
actor	1	59.280 ms	6.2 %
Parallel Seq Scan	1	59.280 ms	100.0 %
casts	1	433.063 ms	45.6 %
Parallel Seq Scan	1	433.063 ms	100.0 %
movie	1	185.058 ms	19.5 %
Seq Scan	1	185.058 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dQg5

Color mode:

Visible columns:

Per node type stats

Per table stats