explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Itx8 : Optimization for: Optimization for: plan #LBtk; plan #ZoKZ

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=1.12..20.26 rows=9 width=14) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.84..17.44 rows=9 width=4) (actual rows= loops=)

  • Join Filter: (a.id = castings.movie_id)
3. 0.000 0.000 ↓ 0.0
→

Nested Loop (cost=0.56..16.60 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0
→

Index Scan using movie_title on movies a (cost=0.28..8.29 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((title)::text = 'Casablanca'::text)
5. 0.000 0.000 ↓ 0.0
→

Index Only Scan using movie_pkey on movies b (cost=0.28..8.29 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = a.id)
6. 0.000 0.000 ↓ 0.0
→

Index Only Scan using casting_pkey on castings (cost=0.29..0.72 rows=9 width=8) (actual rows= loops=)

  • Index Cond: (movie_id = b.id)
7. 0.000 0.000 ↓ 0.0
→

Index Scan using actor_pkey on actors (cost=0.28..0.31 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (id = castings.actor_id)