explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WvOF : Claim.joins(:bankruptcy_case).to_sql

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 294.856 502.146 ↑ 1.0 1,103,807 1

Hash Join (cost=106.40..38,034.94 rows=1,103,807 width=199) (actual time=1.105..502.146 rows=1,103,807 loops=1)

  • Hash Cond: (claims.bankruptcy_case_id = bankruptcy_cases.id)
2. 206.210 206.210 ↑ 1.0 1,103,807 1

Seq Scan on claims (cost=0.00..35,026.07 rows=1,103,807 width=199) (actual time=0.010..206.210 rows=1,103,807 loops=1)

  • Filter: (deleted_at IS NULL)
3. 0.450 1.080 ↑ 1.0 2,462 1

Hash (cost=75.62..75.62 rows=2,462 width=8) (actual time=1.080..1.080 rows=2,462 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 129kB
4. 0.630 0.630 ↑ 1.0 2,462 1

Seq Scan on bankruptcy_cases (cost=0.00..75.62 rows=2,462 width=8) (actual time=0.005..0.630 rows=2,462 loops=1)

  • Filter: (deleted_at IS NULL)
Planning time : 0.322 ms
Execution time : 564.340 ms