Function getTopEventNames

packages/db/src/services/event.service.ts:1188–1201

(projectId: string)

import { resolveDateRange } from './date.service';

export async function getTopEventNames(projectId: string): Promise<string[]> {
  return getCache(`mcp:event-names:${projectId}`, 60 * 10, async () => {
    const rows = await clix(ch)
      .select<IClickhouseEvent>(['name', 'count() as count'])
      .from(TABLE_NAMES.event_names_mv)
      .where('project_id', '=', projectId)
      .groupBy(['name'])
      .orderBy('count', 'DESC')
      .limit(50)
      .execute();

    return rows.map((r) => r.name);
  });
}

export const listEventNamesCore = (projectId: string): Promise<string[]> =>
  getTopEventNames(projectId);