explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8AS9

Settings
# exclusive inclusive rows x rows loops node
1. 0.397 2,538.655 ↓ 74.8 449 1

HashAggregate (cost=300,769.40..300,769.46 rows=6 width=17) (actual time=2,538.610..2,538.655 rows=449 loops=1)

2. 116.295 2,538.258 ↓ 89.3 536 1

Hash Join (cost=269,125.92..300,769.39 rows=6 width=17) (actual time=2,260.598..2,538.258 rows=536 loops=1)

  • Hash Cond: (m.id = c.mid)
3. 161.683 161.683 ↑ 1.0 1,537,411 1

Seq Scan on movie m (cost=0.00..25,878.11 rows=1,537,411 width=21) (actual time=0.066..161.683 rows=1,537,411 loops=1)

4. 748.307 2,260.280 ↓ 89.3 536 1

Hash (cost=269,125.85..269,125.85 rows=6 width=4) (actual time=2,260.280..2,260.280 rows=536 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
  • -> Hash Join (cost=39911.52..269125.85 rows=6 width=4) (actual time=742.626..2260.219 rows=536 loops=1) Hash Cond: (c.pid = a.id)
5. 1,256.754 1,256.754 ↑ 1.0 11,445,847 1

Seq Scan on casts c (cost=0.00..186,279.83 rows=11,449,183 width=8) (actual time=0.036..1,256.754 rows=11,445,847 loops=1)

6. 0.003 255.219 ↑ 1.0 1 1

Hash (cost=39,911.51..39,911.51 rows=1 width=4) (actual time=255.219..255.219 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
7. 255.216 255.216 ↑ 1.0 1 1

Seq Scan on actor a (cost=0.00..39,911.51 rows=1 width=4) (actual time=64.286..255.216 rows=1 loops=1)

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