Analytics endpoint loads the entire approved-proof table into memory to sum rewards

[cybermax4200]

Why this matters now: Platform analytics is an admin endpoint that will OOM / latency-spike as proof volume grows into the millions.

Problem / What: getPlatformAnalytics (analyticsController.ts:11-15) calls prisma.proof.findMany({ where: { status: 'APPROVED' } }) with no limit and sums rewardAmountMicros in JS. This fetches every approved proof row (including the joined task) on each call.

Key Challenges: Rewriting as a SQL aggregation (SUM(reward_amount_micros) with a WHERE status = 'APPROVED') via Prisma aggregate/groupBy or $queryRaw; keeping the same response shape.

Acceptance Criteria:

• The endpoint issues a single aggregate query and its memory footprint is independent of proof count.
• Response values match the previous implementation on a seeded dataset (test).

Relevant files/functions: src/controllers/analyticsController.ts:4-34, prisma/schema.prisma (Proof/Task).

Out of scope: Caching layer (can be a follow-up).

Labels: advanced, performance

[Prz-droid]

GM Maintainer, I’d like to take on this performance issue. I’ll replace the unbounded findMany and JavaScript-side summation with a single database-level aggregate query for approved proofs, keeping memory usage independent of proof volume. I’ll preserve the existing response shape, verify the aggregate matches the current implementation on seeded data, and add focused tests to cover correctness and edge cases. I’ll keep the implementation minimal, efficient, and within the stated scope without introducing caching.
ETA: 48 hours

[Devadakene]

I am experienced enough to implement this issue having worked on similar issues in the past. Please assign

[Salauayo]

Hello Maintainer! I’d like to take this issue on. I’ve reviewed the current getPlatformAnalytics implementation and understand the need to replace the unbounded proof fetch with a single database-level aggregation while preserving the existing response shape. I’m confident I can implement this cleanly and add tests confirming both performance behavior and matching results. I’d appreciate the opportunity to contribute.

[grantfox-oss]

🦊 GrantFox — @Prz-droid has been assigned to this issue as part of the Third Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #61)
2. Your PR will be reviewed by the ecotask-network maintainers

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox as part of the Third Campaign campaign!

@Prz-droid's PR #92 was approved and merged by @cybermax4200.

🏆 @Prz-droid: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (319 total points). Track your full progress on GrantFox.

👏 Great work, @Prz-droid! Keep contributing to ecotask-network.