explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iMuc

Settings
# exclusive inclusive rows x rows loops node
1. 0.131 3.149 ↑ 1.0 1 1

Aggregate (cost=907.21..907.22 rows=1 width=8) (actual time=3.149..3.149 rows=1 loops=1)

2. 1.433 3.018 ↓ 100.8 3,932 1

Hash Join (cost=8.18..907.11 rows=39 width=0) (actual time=0.033..3.018 rows=3,932 loops=1)

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

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

4. 0.003 0.017 ↑ 1.0 1 1

Hash (cost=8.17..8.17 rows=1 width=4) (actual time=0.017..0.017 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.014 0.014 ↑ 1.0 1 1

Index Scan using sports_name_key on sports s (cost=0.15..8.17 rows=1 width=4) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: ((name)::text = 'Long Jump'::text)