explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NpUU

Settings
# exclusive inclusive rows x rows loops node
1. 0.154 3.152 ↓ 5.0 5 1

Nested Loop (cost=1.29..129.59 rows=1 width=17) (actual time=0.572..3.152 rows=5 loops=1)

2. 0.084 0.318 ↓ 89.3 536 1

Nested Loop (cost=0.86..126.81 rows=6 width=4) (actual time=0.070..0.318 rows=536 loops=1)

3. 0.053 0.053 ↑ 1.0 1 1

Index Scan using actor_lname_idx on actor a (cost=0.43..112.59 rows=1 width=4) (actual time=0.047..0.053 rows=1 loops=1)

  • Index Cond: ((lname)::text = 'Hanks'::text)
  • Filter: ((fname)::text = 'Tom'::text)
  • Rows Removed by Filter: 60
4. 0.181 0.181 ↓ 3.1 536 1

Index Scan using casts_pid_idx on casts c (cost=0.43..12.48 rows=174 width=8) (actual time=0.019..0.181 rows=536 loops=1)

  • Index Cond: (pid = a.id)
5. 2.680 2.680 ↓ 0.0 0 536

Index Scan using movie_id_idx on movie m (cost=0.43..0.45 rows=1 width=21) (actual time=0.005..0.005 rows=0 loops=536)

  • Index Cond: (id = c.mid)
  • Filter: (year >= 2010)
  • Rows Removed by Filter: 1