[P2.3] `cf stats` loads the entire `token_usage` table into Python (no LIMIT/index, ignores SQL rollup)

[frankbria]

Severity: medium | Category: infra | Phase: P2.3

Problem

get_workspace_token_usage does SELECT * with no LIMIT and aggregates in Python; --period filters timestamp with no index and re-aggregates despite get_costs_summary existing.

Evidence

codeframe/platform_store/repositories/token_repository.py:246

Acceptance criteria

Aggregation pushed into SQL (SUM/GROUP BY, WHERE range); export streams/paginates. (Indexes handled by P0.1.)

Dependencies

blocked by #712 ([P0.1])

---

_{Filed from the SaaS launch-readiness audit. Atomic: one developer, one session. Work order: strictly P0.1 → P3.12 (no forward dependencies).}

[coderabbitai]

🔗 Related PRs

#590 - feat(costs): cost analytics page (#557) [merged]

---

📝 Issue Planner

_{Check the box below or use the @coderabbitai plan command to generate an implementation plan and prompts that you can use with your favorite coding assistant.}

• Create Plan

---

🧪 Issue enrichment is currently in open beta.

To disable automatic issue enrichment, add the following to your .coderabbit.yaml:

issue_enrichment:
  auto_enrich:
    enabled: false

💬 Have feedback or questions? Drop into our discord!