explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R7Pc

Settings
# exclusive inclusive rows x rows loops node
1. 15.922 18.577 ↓ 1.1 12,329 1

HashAggregate (cost=2,974.41..3,087.93 rows=11,352 width=20) (actual time=16.126..18.577 rows=12,329 loops=1)

  • Output: max(id), insurer_id, insurance_number
  • Group Key: rapidfire_attempts.insurer_id, rapidfire_attempts.insurance_number
2. 2.655 2.655 ↑ 1.0 17,738 1

Seq Scan on public.rapidfire_attempts (cost=0.00..2,841.38 rows=17,738 width=20) (actual time=0.010..2.655 rows=17,738 loops=1)