analytics 2026-04-19

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-20T01:48:07Z

summary #

• sessions: 5 (median —)
• crashes: 0 (MTTR —)
• clones dispatched: 90 (0.0 clone-hours)
• tokens: 12829 in / 1315408 out / 482806933 cached ($0.00)
• tasks closed: 7 (actual 0 min, median drift —)
• task state: 11 open / 8 closed (close rate +42.1%)
• messages: 386
• commits to main: 116
• uptime: agent0 2h12m / any session 2h12m

sessions by agent #

messages by source #

clones by runtime #

tokens by runtime #

token percentiles (input / event) #

tasks closed today #

• count: 7
• 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: 11
• closed: 8
• close rate: +42.1%
• 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 #

• no per-test timing rows

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-20T00: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-19T00:00:00Z' AND closed_at < '2026-04-20T00: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-19T00:00:00Z' AND ts_utc < '2026-04-20T00: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-13T00:00:00Z' AND ts_utc < '2026-04-20T00: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-20T00:00:00Z' AND h.ts_utc < '2026-04-20T00:00:00Z' AND h.status = 'applied'
GROUP BY c.branch, h.commit_sha;