Analyze live data
The SQL sections below use a small set of application events; run them in a connected SQL client.
From your language
Section titled “From your language”An aggregate over live rows, returned to your application:
db.execute("CREATE TABLE runs (agent TEXT, ms BIGINT)")
db.execute("INSERT INTO runs VALUES ('planner', 120), ('planner', 90), ('critic', 200)")
print(db.query("SELECT agent, COUNT(*) AS runs, SUM(ms)::BIGINT AS total_ms "
"FROM runs GROUP BY agent ORDER BY agent"))Output
[{'agent': 'critic', 'runs': 1, 'total_ms': 200}, {'agent': 'planner', 'runs': 2, 'total_ms': 210}]await db.execute("CREATE TABLE runs (agent TEXT, ms BIGINT)");
await db.execute("INSERT INTO runs VALUES ('planner', 120), ('planner', 90), ('critic', 200)");
console.log((await db.query(`SELECT agent, COUNT(*) AS runs, SUM(ms)::BIGINT AS total_ms
FROM runs GROUP BY agent ORDER BY agent`)).rows);Output
[
{ agent: 'critic', runs: 1, total_ms: 200 },
{ agent: 'planner', runs: 2, total_ms: 210 }
]db.execute("CREATE TABLE runs (agent TEXT, ms BIGINT)");
db.execute("INSERT INTO runs VALUES ('planner', 120), ('planner', 90), ('critic', 200)");
System.out.println(db.query("SELECT agent, COUNT(*) AS runs, SUM(ms)::BIGINT AS total_ms "
+ "FROM runs GROUP BY agent ORDER BY agent").getRows());Output
[Row{agent=critic, runs=1, total_ms=200}, Row{agent=planner, runs=2, total_ms=210}]db.Exec(ctx, "CREATE TABLE runs (agent TEXT, ms BIGINT)")
db.Exec(ctx, "INSERT INTO runs VALUES ('planner', 120), ('planner', 90), ('critic', 200)")
rows, _ := db.Query(ctx, `SELECT agent, COUNT(*) AS runs, SUM(ms)::BIGINT AS total_ms
FROM runs GROUP BY agent ORDER BY agent`)
report, _ := particledb.CollectRows(rows, particledb.RowToMap)
fmt.Println(report)Output
[map[agent:critic runs:1 total_ms:200] map[agent:planner runs:2 total_ms:210]]db.execute("CREATE TABLE runs (agent TEXT, ms BIGINT)", &[])?;
db.execute("INSERT INTO runs VALUES ('planner', 120), ('planner', 90), ('critic', 200)", &[])?;
for row in db.query("SELECT agent, COUNT(*) AS runs, SUM(ms)::BIGINT AS total_ms \
FROM runs GROUP BY agent ORDER BY agent", &[])?.rows {
println!("{:?}", row.values());
}Output
[String("critic"), Int64(1), Int64(200)]
[String("planner"), Int64(2), Int64(210)]CREATE TABLE runs (agent TEXT, ms BIGINT);
INSERT INTO runs VALUES ('planner', 120), ('planner', 90), ('critic', 200);
SELECT agent, COUNT(*) AS runs, SUM(ms)::BIGINT AS total_ms
FROM runs GROUP BY agent ORDER BY agent;Output
critic|1|200
planner|2|210Create sample data
Section titled “Create sample data”CREATE TABLE task_events ( id BIGINT PRIMARY KEY, team TEXT, duration_ms BIGINT);INSERT INTO task_events VALUES (1, 'support', 100), (2, 'support', 300), (3, 'platform', 200);Summarize by team
Section titled “Summarize by team”SELECT team, COUNT(*) AS runs, AVG(duration_ms) AS mean_msFROM task_eventsGROUP BY teamORDER BY team;The platform team has one run; support has two. Both have a mean duration of 200 milliseconds.
Filter before grouping
Section titled “Filter before grouping”SELECT team, COUNT(*) AS slow_runsFROM task_eventsWHERE duration_ms > 150GROUP BY teamORDER BY team;Each team has one matching run. Real workloads need representative data and query measurements. Small examples demonstrate behavior, not benchmark performance.
Next steps
Section titled “Next steps”This site uses Google Analytics cookies to count visits. Privacy · License