Skip to content

gitflarePublicPartly agent-ready50

cf-d1-queues-pulse

Event analytics on Cloudflare D1 and Queues: ingestion API, batched consumer, rollups, live dashboard, load generator, dead-letter view.

Build the full D1 + Queues pulse app: dashboard, load generator, dead letters, percentiles, docs8a65841
TypeScript37 lines1.6 KB
import * as Q from "./lib/sql";import { fillMinutes } from "./lib/series";import { percentile } from "./lib/percentile";import type { Env } from "./env"; export async function stats(url: URL, env: Env) {  const w = Math.min(Math.max(parseInt(url.searchParams.get("window") ?? "60", 10) || 60, 1), 1440);  const now = Date.now();  const end = Math.floor(now / 60000);  const from = end - w + 1;  type Row = { minute: number; count: number };  const [series, types, paths, countries, samples, batches, newest, h24s] = await Promise.all([    env.DB.prepare(Q.STATS_SERIES).bind(from).all<Row>(),    env.DB.prepare(Q.STATS_TYPES).bind(from).all(),    env.DB.prepare(Q.STATS_PATHS).bind(from).all(),    env.DB.prepare(Q.STATS_COUNTRIES).bind(from).all(),    env.DB.prepare(Q.STATS_SAMPLES).bind(from).all<{ value: number }>(),    env.DB.prepare(Q.STATS_BATCHES).first<{ n: number }>(),    env.DB.prepare(Q.STATS_NEWEST).first<{ m: number | null }>(),    env.DB.prepare(Q.STATS_SERIES).bind(end - 1439).all<Row>(),  ]);  const filled = fillMinutes(series.results, end, w);  const sum = (n: number) => filled.slice(-n).reduce((a, r) => a + r.count, 0);  const vals = samples.results.map((r) => r.value);  const m = newest?.m ?? null;  return {    totals: { m5: sum(5), h1: sum(60), h24: h24s.results.reduce((a, r) => a + r.count, 0), window: sum(w) },    series: filled,    types: types.results,    paths: paths.results,    countries: countries.results,    percentiles: { p50: percentile(vals, 50), p95: percentile(vals, 95), samples: vals.length },    consumerLag: m === null ? null : Math.max(0, now - m * 60000),    batches: batches?.n ?? 0,  };}