explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EBhK

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 734.745 ↑ 1.0 1 1

Nested Loop (cost=31,728.04..193,116.50 rows=1 width=17) (actual time=303.880..734.745 rows=1 loops=1)

  • Join Filter: (c.pid = a.id)
  • Rows Removed by Join Filter: 5934
2. 0.000 19.435 ↑ 1.0 1 1

Gather (cost=1,000.00..24,592.56 rows=1 width=4) (actual time=19.351..19.435 rows=1 loops=1)

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

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

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678
4. 3.585 716.009 ↓ 1.6 5,935 1

Gather (cost=30,728.04..168,476.30 rows=3,811 width=21) (actual time=157.994..716.009 rows=5,935 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 305.834 712.424 ↓ 1.2 1,978 3

Hash Join (cost=29,728.04..167,095.20 rows=1,588 width=21) (actual time=145.999..712.424 rows=1,978 loops=3)

  • Hash Cond: (c.mid = m.id)
6. 260.962 260.962 ↑ 1.2 3,815,282 3

Parallel Seq Scan on casts c (cost=0.00..119,470.39 rows=4,768,239 width=8) (actual time=0.045..260.962 rows=3,815,282 loops=3)

7. 1.477 145.628 ↓ 8.2 4,201 3

Hash (cost=29,721.64..29,721.64 rows=512 width=21) (actual time=145.628..145.628 rows=4,201 loops=3)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 288kB
8. 144.151 144.151 ↓ 8.2 4,201 3

Seq Scan on movie m (cost=0.00..29,721.64 rows=512 width=21) (actual time=0.034..144.151 rows=4,201 loops=3)

  • Filter: (year > 2010)
  • Rows Removed by Filter: 1533210