#	exclusive	inclusive	rows x	rows	loops	node
1.	0.006	914.070	↑ 200.0	1	1	→ HashAggregate (cost=1,798,027.24..1,798,029.24 rows=200 width=318) (actual time=914.070..914.070 rows=1 loops=1) Group Key: m.name
2.	0.321	914.064	↑ 91,920,435.0	1	1	→ Merge Join (cost=188,445.30..1,568,226.15 rows=91,920,435 width=318) (actual time=913.901..914.064 rows=1 loops=1) Merge Cond: (m.id = c.mid)
3.	1.759	176.774	↑ 19.2	4,199	1	→ Sort (cost=32,199.57..32,400.90 rows=80,531 width=322) (actual time=176.618..176.774 rows=4,199 loops=1) Sort Key: m.id Sort Method: quicksort Memory: 477kB
4.	175.015	175.015	↑ 19.2	4,201	1	→ Seq Scan on movie m (cost=0.00..13,523.90 rows=80,531 width=322) (actual time=0.128..175.015 rows=4,201 loops=1) Filter: (year > 2010) Rows Removed by Filter: 1533210
5.	0.047	736.969	↑ 425.9	536	1	→ Materialize (cost=156,245.72..157,387.15 rows=228,286 width=4) (actual time=736.899..736.969 rows=536 loops=1)
6.	0.000	736.922	↑ 425.9	536	1	→ Sort (cost=156,245.72..156,816.44 rows=228,286 width=4) (actual time=736.895..736.922 rows=536 loops=1) Sort Key: c.mid Sort Method: quicksort Memory: 50kB
7.	3.315	738.328	↑ 425.9	536	1	→ Gather (cost=15,994.66..132,805.72 rows=228,286 width=4) (actual time=224.883..738.328 rows=536 loops=1) Workers Planned: 2 Workers Launched: 2
8.	260.629	735.013	↑ 531.4	179	3	→ Parallel Hash Join (cost=14,994.66..108,977.12 rows=95,119 width=4) (actual time=223.177..735.013 rows=179 loops=3) Hash Cond: (c.pid = a.id)
9.	414.813	414.813	↓ 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.037..414.813 rows=3,815,282 loops=3)
10.	0.025	59.571	↓ 0.0	0	3	→ Parallel Hash (cost=14,994.60..14,994.60 rows=5 width=4) (actual time=59.571..59.571 rows=0 loops=3) Buckets: 1024 Batches: 1 Memory Usage: 40kB
11.	59.546	59.546	↓ 0.0	0	3	→ Parallel Seq Scan on actor a (cost=0.00..14,994.60 rows=5 width=4) (actual time=44.181..59.546 rows=0 loops=3) Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text)) Rows Removed by Filter: 621678

Planning time	:	0.519 ms
Execution time	:	915.769 ms

 HashAggregate  (cost=1798027.24..1798029.24 rows=200 width=318) (actual time=914.070..914.070 rows=1 loops=1)
   Group Key: m.name
   ->  Merge Join  (cost=188445.30..1568226.15 rows=91920435 width=318) (actual time=913.901..914.064 rows=1 loops=1)
         Merge Cond: (m.id = c.mid)
         ->  Sort  (cost=32199.57..32400.90 rows=80531 width=322) (actual time=176.618..176.774 rows=4199 loops=1)
               Sort Key: m.id
               Sort Method: quicksort  Memory: 477kB
               ->  Seq Scan on movie m  (cost=0.00..13523.90 rows=80531 width=322) (actual time=0.128..175.015 rows=4201 loops=1)
                     Filter: (year > 2010)
                     Rows Removed by Filter: 1533210
         ->  Materialize  (cost=156245.72..157387.15 rows=228286 width=4) (actual time=736.899..736.969 rows=536 loops=1)
               ->  Sort  (cost=156245.72..156816.44 rows=228286 width=4) (actual time=736.895..736.922 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=224.883..738.328 rows=536 loops=1)
                           Workers Planned: 2
                           Workers Launched: 2
                           ->  Parallel Hash Join  (cost=14994.66..108977.12 rows=95119 width=4) (actual time=223.177..735.013 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.037..414.813 rows=3815282 loops=3)
                                 ->  Parallel Hash  (cost=14994.60..14994.60 rows=5 width=4) (actual time=59.571..59.571 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.181..59.546 rows=0 loops=3)
                                             Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
                                             Rows Removed by Filter: 621678
 Planning Time: 0.519 ms
 Execution Time: 915.769 ms
(27 rows)

Per node type stats

node type	count	sum of times	% of query
Gather	1	3.315 ms	0.4 %
HashAggregate	1	0.006 ms	0.0 %
Materialize	1	0.047 ms	0.0 %
Merge Join	1	0.321 ms	0.0 %
Parallel Hash	1	0.025 ms	0.0 %
Parallel Hash Join	1	260.629 ms	28.5 %
Parallel Seq Scan	2	474.359 ms	51.9 %
Seq Scan	1	175.015 ms	19.1 %
Sort	2	1.759 ms	0.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
actor	1	59.546 ms	6.5 %
Parallel Seq Scan	1	59.546 ms	100.0 %
casts	1	414.813 ms	45.4 %
Parallel Seq Scan	1	414.813 ms	100.0 %
movie	1	175.015 ms	19.1 %
Seq Scan	1	175.015 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VERV

Color mode:

Visible columns:

Per node type stats

Per table stats