Skip to content

🐸 Rybbit - open-source and privacy-friendly alternative to Google Analytics that is 10x more intuitive.

2.5 KB
Raw Blame
import { FastifyReply, FastifyRequest } from "fastify";
import { getTimeStatement } from "../utils/timeWindow.js";
import { PerformanceOverviewMetrics } from "../types.js";
import { FilterParams } from "@rybbit/shared";
import { analyticsRoute, runAnalyticsQuery } from "../utils/analyticsQuery.js";
import { buildSessionAndRowFilterFragments, TARGET_EVENT_ROW_LEVEL_PARAMS } from "../utils/sessionFilters.js";
import { webVitalRatingCounts } from "./webVitalRatings.js";

export const buildPerformanceOverviewQuery = (query: FilterParams, siteId: number) => {
  const timeStatement = getTimeStatement(query);
  const { filteredSessionsCTE, rowFilterStatement } = buildSessionAndRowFilterFragments(
    query.filters,
    siteId,
    timeStatement,
    TARGET_EVENT_ROW_LEVEL_PARAMS
  );
  const sessionJoin = filteredSessionsCTE ? "INNER JOIN FilteredSessions USING (session_id)" : "";

  return `${filteredSessionsCTE ? `WITH ${filteredSessionsCTE}` : ""}
    SELECT
      quantile(0.5)(lcp) AS lcp_p50,
      quantile(0.75)(lcp) AS lcp_p75,
      quantile(0.9)(lcp) AS lcp_p90,
      quantile(0.99)(lcp) AS lcp_p99,
      quantile(0.5)(cls) AS cls_p50,
      quantile(0.75)(cls) AS cls_p75,
      quantile(0.9)(cls) AS cls_p90,
      quantile(0.99)(cls) AS cls_p99,
      quantile(0.5)(inp) AS inp_p50,
      quantile(0.75)(inp) AS inp_p75,
      quantile(0.9)(inp) AS inp_p90,
      quantile(0.99)(inp) AS inp_p99,
      quantile(0.5)(fcp) AS fcp_p50,
      quantile(0.75)(fcp) AS fcp_p75,
      quantile(0.9)(fcp) AS fcp_p90,
      quantile(0.99)(fcp) AS fcp_p99,
      quantile(0.5)(ttfb) AS ttfb_p50,
      quantile(0.75)(ttfb) AS ttfb_p75,
      quantile(0.9)(ttfb) AS ttfb_p90,
      quantile(0.99)(ttfb) AS ttfb_p99,
      ${webVitalRatingCounts()},
      COUNT(*) AS total_performance_events
    FROM events
    ${sessionJoin}
    WHERE
        site_id = {siteId:Int32}
        AND type = 'performance'
        ${rowFilterStatement}
        ${timeStatement}`;
};

export interface PerformanceOverviewRequest {
  Params: {
    siteId: string;
  };
  Querystring: FilterParams;
}

export const getPerformanceOverview = analyticsRoute<PerformanceOverviewRequest>(
  "performance overview",
  async (req: FastifyRequest<PerformanceOverviewRequest>, res: FastifyReply) => {
    const siteId = Number(req.params.siteId);

    const data = await runAnalyticsQuery<PerformanceOverviewMetrics>({
      query: buildPerformanceOverviewQuery(req.query, siteId),
      params: { siteId },
    });

    return res.send({ data: data[0] });
  }
);