explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6B5

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.028 ↑ 523.3 3 1

Hash Join (cost=37.00..66.83 rows=1,570 width=64) (actual time=0.026..0.028 rows=3 loops=1)

  • Hash Cond: (actor_film.actorid = actor.id)
2. 0.010 0.010 ↑ 523.3 3 1

Seq Scan on actor_film (cost=0.00..25.70 rows=1,570 width=24) (actual time=0.010..0.010 rows=3 loops=1)

3. 0.004 0.008 ↑ 400.0 3 1

Hash (cost=22.00..22.00 rows=1,200 width=40) (actual time=0.007..0.008 rows=3 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
4. 0.004 0.004 ↑ 400.0 3 1

Seq Scan on actor (cost=0.00..22.00 rows=1,200 width=40) (actual time=0.003..0.004 rows=3 loops=1)