explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yI4n

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 297.613 ↑ 1.0 1 1

Finalize Aggregate (cost=76,068.63..76,068.64 rows=1 width=8) (actual time=297.613..297.613 rows=1 loops=1)

2. 26.686 305.319 ↓ 1.5 3 1

Gather (cost=76,068.42..76,068.63 rows=2 width=8) (actual time=297.295..305.319 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 6.886 278.633 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=75,068.42..75,068.43 rows=1 width=8) (actual time=278.632..278.633 rows=1 loops=3)

4. 68.825 271.747 ↓ 81.6 133,281 3 / 3

Hash Join (cost=8.18..75,064.33 rows=1,634 width=0) (actual time=0.362..271.747 rows=133,281 loops=3)

  • Hash Cond: (r.sportid = s.id)
5. 202.878 202.878 ↑ 1.3 666,667 3 / 3

Parallel Seq Scan on results r (cost=0.00..72,850.45 rows=833,345 width=4) (actual time=0.237..202.878 rows=666,667 loops=3)

6. 0.007 0.044 ↑ 1.0 1 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.037 0.037 ↑ 1.0 1 3 / 3

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

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