explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ODQN

Settings
# exclusive inclusive rows x rows loops node
1. 6,231.259 15,317.622 ↑ 1.0 1,420,885 1

Hash Join (cost=56,361.46..156,169.60 rows=1,420,918 width=16) (actual time=5,781.641..15,317.622 rows=1,420,885 loops=1)

  • Hash Cond: (horse_features.horserace_id = previous_horserace.horse_previous_horserace_id)
2. 3,310.692 3,310.692 ↑ 1.0 1,567,013 1

Seq Scan on horse_features (cost=0.00..52,896.13 rows=1,567,013 width=16) (actual time=0.010..3,310.692 rows=1,567,013 loops=1)

3. 2,923.633 5,775.671 ↑ 1.1 1,420,885 1

Hash (cost=29,288.98..29,288.98 rows=1,557,398 width=16) (actual time=5,775.671..5,775.671 rows=1,420,885 loops=1)

  • Buckets: 4096 Batches: 128 Memory Usage: 533kB
4. 2,852.038 2,852.038 ↑ 1.0 1,557,171 1

Seq Scan on previous_horserace (cost=0.00..29,288.98 rows=1,557,398 width=16) (actual time=0.098..2,852.038 rows=1,557,171 loops=1)