explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5rSm

Settings
# exclusive inclusive rows x rows loops node
1. 3,035.371 16,183.935 ↑ 1.1 2,019,999 1

GroupAggregate (cost=0.56..2,736,650.73 rows=2,175,862 width=16) (actual time=69.796..16,183.935 rows=2,019,999 loops=1)

  • Output: sum(score), user_id
  • Group Key: us.user_id
  • Functions: 5
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 0.713 ms, Inlining 5.394 ms, Optimization 38.645 ms, Emission 25.527 ms, Total 70.280 ms
2. 13,148.564 13,148.564 ↑ 1.0 42,419,979 1

Index Scan using user_scores_user_id on public.user_scores us (cost=0.56..2,502,791.95 rows=42,420,032 width=12) (actual time=0.021..13,148.564 rows=42,419,979 loops=1)

  • Output: user_id, event_id, score, inserted_at
Execution time : 16,273.182 ms