explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VERV

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 914.070 ↑ 200.0 1 1

HashAggregate (cost=1,798,027.24..1,798,029.24 rows=200 width=318) (actual time=914.070..914.070 rows=1 loops=1)

  • Group Key: m.name
2. 0.321 914.064 ↑ 91,920,435.0 1 1

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

  • Merge Cond: (m.id = c.mid)
3. 1.759 176.774 ↑ 19.2 4,199 1

Sort (cost=32,199.57..32,400.90 rows=80,531 width=322) (actual time=176.618..176.774 rows=4,199 loops=1)

  • Sort Key: m.id
  • Sort Method: quicksort Memory: 477kB
4. 175.015 175.015 ↑ 19.2 4,201 1

Seq Scan on movie m (cost=0.00..13,523.90 rows=80,531 width=322) (actual time=0.128..175.015 rows=4,201 loops=1)

  • Filter: (year > 2010)
  • Rows Removed by Filter: 1533210
5. 0.047 736.969 ↑ 425.9 536 1

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

6. 0.000 736.922 ↑ 425.9 536 1

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

  • Sort Key: c.mid
  • Sort Method: quicksort Memory: 50kB
7. 3.315 738.328 ↑ 425.9 536 1

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

  • Workers Planned: 2
  • Workers Launched: 2
8. 260.629 735.013 ↑ 531.4 179 3

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

  • Hash Cond: (c.pid = a.id)
9. 414.813 414.813 ↓ 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.037..414.813 rows=3,815,282 loops=3)

10. 0.025 59.571 ↓ 0.0 0 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
11. 59.546 59.546 ↓ 0.0 0 3

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

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