explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4UT7

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

Finalize Aggregate (cost=77,148.03..77,148.04 rows=1 width=8) (actual time=307.868..307.868 rows=1 loops=1)

2. 35.091 323.377 ↓ 1.5 3 1

Gather (cost=77,147.82..77,148.03 rows=2 width=8) (actual time=307.505..323.377 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 6.893 288.286 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=76,147.82..76,147.83 rows=1 width=8) (actual time=288.286..288.286 rows=1 loops=3)

4. 69.610 281.393 ↓ 10.7 133,281 3 / 3

Hash Join (cost=16.41..76,116.57 rows=12,500 width=0) (actual time=0.582..281.393 rows=133,281 loops=3)

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

Parallel Seq Scan on results r (cost=0.00..72,850.20 rows=833,320 width=4) (actual time=0.224..211.540 rows=666,667 loops=3)

6. 0.007 0.243 ↑ 3.0 1 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.236 0.236 ↑ 3.0 1 3 / 3

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

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