explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 83m6

Settings
# exclusive inclusive rows x rows loops node
1. 0.191 193.323 ↑ 1.0 1 1

Nested Loop (cost=0.86..39,928.59 rows=1 width=17) (actual time=44.888..193.323 rows=1 loops=1)

2. 0.068 187.236 ↓ 89.3 536 1

Nested Loop (cost=0.43..39,925.81 rows=6 width=4) (actual time=42.337..187.236 rows=536 loops=1)

3. 187.030 187.030 ↑ 1.0 1 1

Seq Scan on actor a (cost=0.00..39,911.51 rows=1 width=4) (actual time=42.318..187.030 rows=1 loops=1)

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 1865033
4. 0.138 0.138 ↓ 3.0 536 1

Index Scan using casts_index on casts c (cost=0.43..12.53 rows=177 width=8) (actual time=0.013..0.138 rows=536 loops=1)

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

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

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