explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gYes

Settings
# exclusive inclusive rows x rows loops node
1. 454.700 600.611 ↓ 1.0 1,104,444 1

Hash Right Join (cost=106.40..38,034.94 rows=1,103,807 width=353) (actual time=0.841..600.611 rows=1,104,444 loops=1)

  • Hash Cond: (claims.bankruptcy_case_id = bankruptcy_cases.id)
2. 145.084 145.084 ↑ 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.005..145.084 rows=1,103,807 loops=1)

3. 0.476 0.827 ↑ 1.0 2,462 1

Hash (cost=75.62..75.62 rows=2,462 width=154) (actual time=0.826..0.827 rows=2,462 loops=1)

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

Seq Scan on bankruptcy_cases (cost=0.00..75.62 rows=2,462 width=154) (actual time=0.007..0.351 rows=2,462 loops=1)

Planning time : 0.341 ms
Execution time : 662.761 ms