explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I5Im

Settings
# exclusive inclusive rows x rows loops node
1. 1,462,988.721 1,475,471.625 ↑ 1.0 1,557,171 1

Hash Right Join (cost=56,486.08..156,248.88 rows=1,562,137 width=16) (actual time=12,965.857..1,475,471.625 rows=1,557,171 loops=1)

  • Hash Cond: (horse_features.horserace_id = previous_horserace.horse_previous_horserace_id)
2. 2,369.003 2,369.003 ↓ 1.0 1,567,013 1

Seq Scan on horse_features (cost=0.00..52,853.31 rows=1,562,731 width=16) (actual time=0.111..2,369.003 rows=1,567,013 loops=1)

3. 8,130.582 10,113.901 ↑ 1.0 1,557,171 1

Hash (cost=29,331.37..29,331.37 rows=1,562,137 width=16) (actual time=10,113.901..10,113.901 rows=1,557,171 loops=1)

  • Buckets: 4096 Batches: 131072 (originally 128) Memory Usage: 5325kB
4. 1,983.319 1,983.319 ↑ 1.0 1,557,171 1

Seq Scan on previous_horserace (cost=0.00..29,331.37 rows=1,562,137 width=16) (actual time=0.024..1,983.319 rows=1,557,171 loops=1)