explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZiCAs : Claim.with_showable_bankruptcy_case

Settings
# exclusive inclusive rows x rows loops node
1. 207.157 421.610 ↑ 1.2 595,719 1

Hash Join (cost=102.11..38,030.66 rows=729,445 width=199) (actual time=1.136..421.610 rows=595,719 loops=1)

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

  • Filter: (deleted_at IS NULL)
3. 0.305 1.095 ↓ 1.0 1,647 1

Hash (cost=81.78..81.78 rows=1,627 width=8) (actual time=1.095..1.095 rows=1,647 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 81kB
4. 0.790 0.790 ↓ 1.0 1,647 1

Seq Scan on bankruptcy_cases (cost=0.00..81.78 rows=1,627 width=8) (actual time=0.025..0.790 rows=1,647 loops=1)

  • Filter: ((deleted_at IS NULL) AND (deleted_at IS NULL) AND show_in_marketplace AND (date_filed >= '2018-09-15 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 815
Planning time : 1.649 ms
Execution time : 455.686 ms