Method getEventTimeRange

backend/src/trace/trace.repository.ts:151–168

* Get the first and last event timestamps for a run to calculate accurate duration

(
    runId: string,
    organizationId?: string | null,
  )

   * Get the first and last event timestamps for a run to calculate accurate duration
   */
  async getEventTimeRange(
    runId: string,
    organizationId?: string | null,
  ): Promise<{ firstTimestamp: Date | null; lastTimestamp: Date | null }> {
    const runFilter = this.buildRunFilter(runId, organizationId);
    const [result] = await this.db
      .select({
        firstTimestamp: sql<Date>`min(${workflowTracesTable.timestamp})`,
        lastTimestamp: sql<Date>`max(${workflowTracesTable.timestamp})`,
      })
      .from(workflowTracesTable)
      .where(runFilter);

    return {
      firstTimestamp: result?.firstTimestamp ?? null,
      lastTimestamp: result?.lastTimestamp ?? null,
    };
  }

  async getLastSequence(runId: string, organizationId?: string | null): Promise<number> {
    const runFilter = this.buildRunFilter(runId, organizationId);