explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Iton

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.159 3.446 ↑ 1.0 1 1

Aggregate (cost=941.16..941.17 rows=1 width=8) (actual time=3.446..3.446 rows=1 loops=1)

2. 1.582 3.287 ↓ 13.1 3,932 1

Hash Join (cost=16.41..940.41 rows=300 width=0) (actual time=0.035..3.287 rows=3,932 loops=1)

  • Hash Cond: (r.sportid = s.id)
3. 1.691 1.691 ↑ 1.0 20,000 1

Seq Scan on results r (cost=0.00..846.00 rows=20,000 width=4) (actual time=0.013..1.691 rows=20,000 loops=1)

4. 0.004 0.014 ↑ 3.0 1 1

Hash (cost=16.38..16.38 rows=3 width=4) (actual time=0.013..0.014 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.010 0.010 ↑ 3.0 1 1

Seq Scan on sports s (cost=0.00..16.38 rows=3 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: ((name)::text = 'Long Jump'::text)
  • Rows Removed by Filter: 6