explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7WMKy

Settings
# exclusive inclusive rows x rows loops node
1. 8.552 426.648 ↑ 1.0 1 1

Gather (cost=19,534.15..150,934.36 rows=1 width=17) (actual time=422.608..426.648 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2.685 418.096 ↓ 0.0 0 3

Parallel Hash Join (cost=18,534.15..149,934.26 rows=1 width=17) (actual time=331.027..418.096 rows=0 loops=3)

  • Hash Cond: (casts.mid = movie.id)
3. 345.975 345.975 ↓ 2.5 179 3

Parallel Seq Scan on casts (cost=0.00..131,399.83 rows=71 width=4) (actual time=84.652..345.975 rows=179 loops=3)

  • Filter: (pid = 429073)
  • Rows Removed by Filter: 3815104
4. 2.435 69.436 ↑ 1.3 1,400 3

Parallel Hash (cost=18,511.35..18,511.35 rows=1,824 width=21) (actual time=69.434..69.436 rows=1,400 loops=3)

  • Buckets: 8192 Batches: 1 Memory Usage: 352kB
5. 67.001 67.001 ↑ 1.3 1,400 3

Parallel Seq Scan on movie (cost=0.00..18,511.35 rows=1,824 width=21) (actual time=0.113..67.001 rows=1,400 loops=3)

  • Filter: (year > 2010)
  • Rows Removed by Filter: 511070
Planning time : 0.199 ms
Execution time : 426.700 ms