explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dQg5

Settings
# exclusive inclusive rows x rows loops node
1. 1.150 949.042 ↑ 18,384,087.0 5 1

Merge Join (cost=188,445.30..1,568,226.15 rows=91,920,435 width=318) (actual time=947.840..949.042 rows=5 loops=1)

  • Merge Cond: (m.id = c.mid)
2. 5.948 191.006 ↑ 4.6 17,666 1

Sort (cost=32,199.57..32,400.90 rows=80,531 width=322) (actual time=190.373..191.006 rows=17,666 loops=1)

  • Sort Key: m.id
  • Sort Method: quicksort Memory: 1979kB
3. 185.058 185.058 ↑ 4.5 17,717 1

Seq Scan on movie m (cost=0.00..13,523.90 rows=80,531 width=322) (actual time=0.107..185.058 rows=17,717 loops=1)

  • Filter: (year >= 2010)
  • Rows Removed by Filter: 1519694
4. 0.047 756.886 ↑ 425.9 536 1

Materialize (cost=156,245.72..157,387.15 rows=228,286 width=4) (actual time=756.818..756.886 rows=536 loops=1)

5. 0.000 756.839 ↑ 425.9 536 1

Sort (cost=156,245.72..156,816.44 rows=228,286 width=4) (actual time=756.813..756.839 rows=536 loops=1)

  • Sort Key: c.mid
  • Sort Method: quicksort Memory: 50kB
6. 1.987 756.861 ↑ 425.9 536 1

Gather (cost=15,994.66..132,805.72 rows=228,286 width=4) (actual time=228.745..756.861 rows=536 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 262.503 754.874 ↑ 531.4 179 3

Parallel Hash Join (cost=14,994.66..108,977.12 rows=95,119 width=4) (actual time=227.003..754.874 rows=179 loops=3)

  • Hash Cond: (c.pid = a.id)
8. 433.063 433.063 ↓ 2.4 3,815,282 3

Parallel Seq Scan on casts c (cost=0.00..87,641.18 rows=1,585,318 width=8) (actual time=0.064..433.063 rows=3,815,282 loops=3)

9. 0.028 59.308 ↓ 0.0 0 3

Parallel Hash (cost=14,994.60..14,994.60 rows=5 width=4) (actual time=59.308..59.308 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
10. 59.280 59.280 ↓ 0.0 0 3

Parallel Seq Scan on actor a (cost=0.00..14,994.60 rows=5 width=4) (actual time=44.043..59.280 rows=0 loops=3)

  • Filter: (((fname)::text = 'Tom'::text) AND ((lname)::text = 'Hanks'::text))
  • Rows Removed by Filter: 621678