explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WIT

Settings
# exclusive inclusive rows x rows loops node
1. 8,860.988 8,860.988 ↑ 1.0 1 1
→

Gather (cost=161,934.94..180,453.24 rows=1 width=17) (actual time=8,857.365..8,860.988 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • -> Parallel Hash Join (cost=160934.94..179453.14 rows=1 width=17) (actual time=8841.923..8853.684 rows=0 loops=3
  • Hash Cond: (m.id = c.mid)
  • -> Parallel Seq Scan on movie m (cost=0.00..18511.35 rows=1824 width=21) (actual time=0.054..54.948 rows=1
  • Filter: (year > 2010)
  • Rows Removed by Filter: 511070
  • -> Parallel Hash (cost=160934.92..160934.92 rows=2 width=4) (actual time=8796.863..8796.864 rows=179 loops
  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
  • -> Parallel Hash Join (cost=23592.48..160934.92 rows=2 width=4) (actual time=2130.910..8796.475 rows
  • Hash Cond: (c.pid = a.id)
  • -> Parallel Seq Scan on casts c (cost=0.00..119463.94 rows=4767594 width=8) (actual time=0.031
  • -> Parallel Hash (cost=23592.46..23592.46 rows=1 width=4) (actual time=81.649..81.650 rows=0 l
  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
  • -> Parallel Seq Scan on actor a (cost=0.00..23592.46 rows=1 width=4) (actual time=60.480
  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
Planning time : 0.180 ms
Execution time : 8,861.046 ms