explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MXEv

Settings
# 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