Skip to content

feat: add agentId filter to aggregation queries #1029

@jpleva91

Description

@jpleva91

Context

packages/storage/src/aggregation-queries.ts has team-level aggregation but no way to filter by agent. The sessions table now has an indexed agent_id column (migration v5).

Work Items

  1. Add agentId?: string to AggregationTimeFilter interface
  2. Wire it into buildTimeConditions() to join/filter against sessions.agent_id
  3. Refactor agentSummaries() to use indexed sessions.agent_id instead of json_extract() on RunStarted event data — much faster for large datasets
  4. Update tests

Files

  • packages/storage/src/aggregation-queries.ts
  • packages/storage/src/types.ts (AggregationTimeFilter)
  • packages/storage/tests/

Metadata

Metadata

Assignees

No one assigned

    Labels

    agent:copilotAssigned to GitHub Copilot agentenhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions