explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n5GT

Settings
# exclusive inclusive rows x rows loops node
1. 0.413 3.492 ↓ 5.0 5 1

Nested Loop (cost=1.29..129.81 rows=1 width=17) (actual time=0.548..3.492 rows=5 loops=1)

2. 0.097 0.399 ↓ 89.3 536 1

Nested Loop (cost=0.86..127.04 rows=6 width=4) (actual time=0.108..0.399 rows=536 loops=1)

3. 0.110 0.110 ↑ 1.0 1 1

Index Scan using index_actor_lname on actor a (cost=0.43..112.76 rows=1 width=4) (actual time=0.089..0.110 rows=1 loops=1)

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

Index Scan using index_casts_pid on casts c (cost=0.43..12.52 rows=176 width=8) (actual time=0.016..0.192 rows=536 loops=1)

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

Index Scan using index_movie_id 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