#	exclusive	inclusive	rows x	rows	loops	node
1.	0.310	2.794	↓ 5.0	5	1	→ Nested Loop (cost=1.29..25.61 rows=1 width=17) (actual time=0.429..2.794 rows=5 loops=1)
2.	0.112	0.340	↓ 89.3	536	1	→ Nested Loop (cost=0.86..22.83 rows=6 width=4) (actual time=0.038..0.340 rows=536 loops=1)
3.	0.026	0.026	↑ 1.0	1	1	→ Index Scan using idx_name on actor a (cost=0.43..8.45 rows=1 width=4) (actual time=0.025..0.026 rows=1 loops=1) Index Cond: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
4.	0.202	0.202	↓ 3.0	536	1	→ Index Scan using index_actor on casts c (cost=0.43..12.59 rows=180 width=8) (actual time=0.009..0.202 rows=536 loops=1) Index Cond: (pid = a.id)
5.	2.144	2.144	↓ 0.0	0	536	→ Index Scan using idx_mid on movie m (cost=0.43..0.45 rows=1 width=21) (actual time=0.004..0.004 rows=0 loops=536) Index Cond: (id = c.mid) Filter: (year >= 2010) Rows Removed by Filter: 1

QUERY PLAN                                                              
--------------------------------------------------------------------------------------------------------------------------------------
 Nested Loop  (cost=1.29..25.61 rows=1 width=17) (actual time=0.429..2.794 rows=5 loops=1)
   ->  Nested Loop  (cost=0.86..22.83 rows=6 width=4) (actual time=0.038..0.340 rows=536 loops=1)
         ->  Index Scan using idx_name on actor a  (cost=0.43..8.45 rows=1 width=4) (actual time=0.025..0.026 rows=1 loops=1)
               Index Cond: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
         ->  Index Scan using index_actor on casts c  (cost=0.43..12.59 rows=180 width=8) (actual time=0.009..0.202 rows=536 loops=1)
               Index Cond: (pid = a.id)
   ->  Index Scan using idx_mid on movie m  (cost=0.43..0.45 rows=1 width=21) (actual time=0.004..0.004 rows=0 loops=536)
         Index Cond: (id = c.mid)
         Filter: (year >= 2010)
         Rows Removed by Filter: 1
 Planning time: 0.875 ms
 Execution time: 2.836 ms
(12 rows)

Per node type stats

node type	count	sum of times	% of query
Index Scan	3	2.372 ms	84.9 %
Nested Loop	2	0.422 ms	15.1 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
actor	1	0.026 ms	0.9 %
Index Scan	1	0.026 ms	100.0 %
casts	1	0.202 ms	7.2 %
Index Scan	1	0.202 ms	100.0 %
movie	1	2.144 ms	76.7 %
Index Scan	1	2.144 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MXEv

Color mode:

Visible columns:

Per node type stats

Per table stats