analytics 2026-04-22

This page is the daily netsky observability cut: DuckDB-style SQL over ~/.netsky/meta.db, rendered by netsky analytics daily, with Plotly charts checked into the website. It is both the operator dashboard and the product demo of what the system measures about itself.

generated 2026-04-22T21:27:03Z

summary #

• sessions: 2 (median —)
• crashes: 0 (MTTR —)
• clones dispatched: 6 (0.0 clone-hours)
• tokens: 0 in / 0 out / 0 cached ($0.00)
• tasks closed: 0 (actual 0 min, median drift —)
• task state: 13 open / 83 closed (close rate +86.5%)
• messages: 158
• commits to main: 28
• uptime: agent0 3h15m / any session 3h15m

sessions by agent #

messages by source #

clones by runtime #

tokens by runtime #

token percentiles (input / event) #

tasks closed today #

• count: 0
• total actual minutes: 0
• median drift: —

task metrics #

Historical fix: same-minute closes now floor actual_minutes at 1 when a task closes after creation but before the clock crosses a full minute. That repairs pre-v8 zero-minute rows without inventing a new lifecycle column.

• open: 13
• closed: 83
• close rate: +86.5%
• median estimate: —
• median actual: —
• median drift: —
• dispatch to harvest median: —

open by priority #

closed by priority #

open by source #

closed by source #

cycle time histogram #

dispatch to harvest latency #

top drifted tasks #

• no closed tasks with estimate vs actual pairs

test suite timing #

• tracked tests: 10

suite	test	runs	p50 7d	p90 7d	last
netsky test integration	integration/test-clone-tool-deny-hook.sh	16	8319 ms	9474 ms	9474 ms
netsky test unit	unit/test-iroh-e2e.sh	30	8859 ms	9087 ms	8807 ms
netsky test integration	integration/test-clone-health-json.sh	16	1269 ms	5502 ms	5354 ms
netsky test unit	unit/test-fresh-clone.sh	31	3943 ms	5419 ms	5419 ms
netsky test integration	integration/test-agentd-e2e.sh	2	5015 ms	5015 ms	5015 ms
netsky test unit	unit/test-channel-concurrent-send.sh	31	3692 ms	4542 ms	3612 ms
netsky test unit	unit/test-test-record-to-db.sh	31	3176 ms	3215 ms	3197 ms
netsky test unit	unit/test-status-watch.sh	31	3124 ms	3142 ms	3090 ms
netsky test unit	unit/test-pre-push-guard.sh	22	1809 ms	2629 ms	2629 ms
netsky test integration	integration/test-netsky-ai-status-wait-cat.sh	16	2240 ms	2264 ms	2164 ms

tokens per task #

• no task-attributed token rows

iroh #

• connect: 0, evict: 0, reconnect: 0, handshake_refused: 0

queries #

DuckDB rerun snippets:

task snapshot by priority #

SELECT status, COALESCE(priority, 'unscoped') AS priority, COUNT(*) AS n
FROM tasks
WHERE created_at < '2026-04-23T00:00:00Z'
GROUP BY status, priority
ORDER BY status, n DESC;

closed-task drift #

SELECT id, title, estimate_minutes, actual_minutes,
((actual_minutes - estimate_minutes) * 100.0) / estimate_minutes AS drift_pct
FROM tasks
WHERE status = 'closed'
AND closed_at >= '2026-04-22T00:00:00Z' AND closed_at < '2026-04-23T00:00:00Z'
AND estimate_minutes IS NOT NULL AND actual_minutes IS NOT NULL
ORDER BY ABS(((actual_minutes - estimate_minutes) * 100.0) / estimate_minutes) DESC
LIMIT 10;

task token attribution #

SELECT task_id, model,
SUM(COALESCE(input_tokens, 0)) AS input_tokens,
SUM(COALESCE(output_tokens, 0)) AS output_tokens,
SUM(COALESCE(cached_input_tokens, 0)) AS cached_tokens,
SUM(COALESCE(cost_usd_micros, 0)) AS cost_usd_micros
FROM token_usage
WHERE task_id IS NOT NULL
AND ts_utc >= '2026-04-22T00:00:00Z' AND ts_utc < '2026-04-23T00:00:00Z'
GROUP BY task_id, model
ORDER BY cost_usd_micros DESC;

test timing rollup #

SELECT suite, name, duration_ms
FROM test_runs
WHERE ts_utc >= '2026-04-16T00:00:00Z' AND ts_utc < '2026-04-23T00:00:00Z'
AND name <> ''
ORDER BY suite, name, duration_ms;

dispatch to harvest proxy #

SELECT c.branch, MIN(c.ts_utc_start) AS dispatch_start, h.commit_sha, MIN(h.ts_utc) AS harvest_ts
FROM clone_dispatches c
JOIN harvest_events h ON h.source_branch = c.branch
WHERE c.ts_utc_start < '2026-04-23T00:00:00Z' AND h.ts_utc < '2026-04-23T00:00:00Z' AND h.status = 'applied'
GROUP BY c.branch, h.commit_sha;