explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8RgM

Settings
# exclusive inclusive rows x rows loops node
1. 116.846 785.756 ↑ 1.0 1 1

Nested Loop (cost=25,592.48..182,168.06 rows=1 width=17) (actual time=697.844..785.756 rows=1 loops=1)

  • Join Filter: (casts.mid = movie.id)
  • Rows Removed by Join Filter: 2251735
2. 0.000 0.951 ↓ 1.2 4,201 1

Gather (cost=1,000.00..19,869.25 rows=3,579 width=21) (actual time=0.393..0.951 rows=4,201 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 46.672 46.672 ↑ 1.1 1,400 3

Parallel Seq Scan on movie (cost=0.00..18,511.35 rows=1,491 width=21) (actual time=0.072..46.672 rows=1,400 loops=3)

  • Filter: (year > 2010)
  • Rows Removed by Filter: 511070
4. 73.452 667.959 ↓ 89.3 536 4,201

Materialize (cost=24,592.48..161,976.72 rows=6 width=4) (actual time=0.046..0.159 rows=536 loops=4,201)

5. 4.343 594.507 ↓ 89.3 536 1

Gather (cost=24,592.48..161,976.69 rows=6 width=4) (actual time=194.640..594.507 rows=536 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 259.130 590.164 ↓ 89.5 179 3

Parallel Hash Join (cost=23,592.48..160,976.09 rows=2 width=4) (actual time=190.480..590.164 rows=179 loops=3)

  • Hash Cond: (casts.pid = actor.id)
7. 268.582 268.582 ↑ 1.3 3,815,282 3

Parallel Seq Scan on casts (cost=0.00..119,493.88 rows=4,770,588 width=8) (actual time=0.032..268.582 rows=3,815,282 loops=3)

8. 0.037 62.452 ↓ 0.0 0 3

Parallel Hash (cost=23,592.46..23,592.46 rows=1 width=4) (actual time=62.451..62.452 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
9. 62.415 62.415 ↓ 0.0 0 3

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

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
Planning time : 0.310 ms
Execution time : 786.017 ms