explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MaFA

Settings

Optimization(s) for this plan:

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

Nested Loop (cost=31,728.33..193,161.84 rows=1 width=17) (actual time=79.835..79.835 rows=0 loops=1)

  • Join Filter: (c.pid = a.id)
2. 23.044 81.315 ↓ 0.0 0 1

Gather (cost=1,000.00..24,592.56 rows=1 width=4) (actual time=79.833..81.315 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 58.271 58.271 ↓ 0.0 0 3

Parallel Seq Scan on actor a (cost=0.00..23,592.46 rows=1 width=4) (actual time=58.271..58.271 rows=0 loops=3)

  • Filter: (((fname)::text = 'TOM'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
4. 0.000 0.000 ↓ 0.0 0

Gather (cost=30,728.33..168,519.48 rows=3,984 width=21) (never executed)

  • Workers Planned: 2
  • Workers Launched: 0
5. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=29,728.33..167,121.08 rows=1,660 width=21) (never executed)

  • Hash Cond: (c.mid = movie.id)
6. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on casts c (cost=0.00..119,488.48 rows=4,770,048 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Hash (cost=29,721.64..29,721.64 rows=535 width=21) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on movie (cost=0.00..29,721.64 rows=535 width=21) (never executed)

  • Filter: (year > 2010)