`opencode.sessions`

pass

All sessions stored in the local OpenCode database, with flattened model, token, cost, and timestamp columns. Each row includes the raw `metadata`, `summary_diffs`, `revert`, and `permission` blobs in a `metadata` JSON column so nothing is lost.

Run the converter first to populate the JSONL files:

no filters captured 2026-09-01 09:48:49Zmedian 9209 ms

Verdict: TRUE

All variants returned rows on ≥2 of 3 trials, 0 errors.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	3	8837 ms	9209 ms	10463 ms	[3, 3, 3]
order-desc	3	9957 ms	10054 ms	11285 ms	[25, 25, 25]
filter-agent	3	8802 ms	9575 ms	9838 ms	[25, 25, 25]
filter-cost	3	10936 ms	11346 ms	13411 ms	[18, 18, 18]
filter-tokens	3	8654 ms	8714 ms	9903 ms	[5, 5, 5]
aggregate	3	11638 ms	12101 ms	13152 ms	[1, 1, 1]
group-by	3	11659 ms	12197 ms	13068 ms	[15, 15, 15]

Latency per trial

minimalmedian 9209ms

scale: 0–10463 ms

order-descmedian 10054ms

scale: 0–11285 ms

filter-agentmedian 9575ms

scale: 0–9838 ms

filter-costmedian 11346ms

scale: 0–13411 ms

filter-tokensmedian 8714ms

scale: 0–9903 ms

aggregatemedian 12101ms

scale: 0–13152 ms

group-bymedian 12197ms

scale: 0–13068 ms

Probe variants — every command + output

minimal3 trials

min 8837ms · median 9209ms · max 10463ms · rows 3,3,3

top token spenders

Command

SELECT id, title, agent, model_provider, tokens_input, tokens_output, cost FROM opencode.sessions ORDER BY tokens_input DESC LIMIT 3

Trials + output

trial 1·8837ms·rows 3isError=false

First row (click to expand JSON)

{
  "id": "ses_0150f217cffeGq9tAm4scX8k63",
  "title": "Complete remaining tasks from session",
  "agent": "build",
  "model_provider": "samagama",
  "tokens_input": "180068861",
  "tokens_output": "1035057",
  "cost": "0.0"
}

columns (7)

idtitleagentmodel_providertokens_inputtokens_outputcost

trial 2·10463ms·rows 3isError=false

First row (click to expand JSON)

{
  "id": "ses_0150f217cffeGq9tAm4scX8k63",
  "title": "Complete remaining tasks from session",
  "agent": "build",
  "model_provider": "samagama",
  "tokens_input": "180068861",
  "tokens_output": "1035057",
  "cost": "0.0"
}

columns (7)

idtitleagentmodel_providertokens_inputtokens_outputcost

trial 3·9209ms·rows 3isError=false

First row (click to expand JSON)

{
  "id": "ses_0150f217cffeGq9tAm4scX8k63",
  "title": "Complete remaining tasks from session",
  "agent": "build",
  "model_provider": "samagama",
  "tokens_input": "180068861",
  "tokens_output": "1035057",
  "cost": "0.0"
}

columns (7)

idtitleagentmodel_providertokens_inputtokens_outputcost

order-desc3 trials

min 9957ms · median 10054ms · max 11285ms · rows 25,25,25

most recently updated sessions

Command

SELECT id, title, agent, model_provider, cost FROM opencode.sessions ORDER BY time_updated DESC LIMIT 25

Trials + output

trial 1·10054ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "ses_01d64c22bffe7B9Z3shNeMWiPa",
  "title": "PR contribution check",
  "agent": "build",
  "model_provider": "samagama",
  "cost": "0.0"
}

columns (5)

idtitleagentmodel_providercost

trial 2·11285ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "ses_01d64c22bffe7B9Z3shNeMWiPa",
  "title": "PR contribution check",
  "agent": "build",
  "model_provider": "samagama",
  "cost": "0.0"
}

columns (5)

idtitleagentmodel_providercost

trial 3·9957ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "ses_01d64c22bffe7B9Z3shNeMWiPa",
  "title": "PR contribution check",
  "agent": "build",
  "model_provider": "samagama",
  "cost": "0.0"
}

columns (5)

idtitleagentmodel_providercost

filter-agent3 trials

min 8802ms · median 9575ms · max 9838ms · rows 25,25,25

filter by agent

Command

SELECT id, title, agent FROM opencode.sessions WHERE agent = 'build' LIMIT 25

Trials + output

trial 1·9575ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "ses_01d64c22bffe7B9Z3shNeMWiPa",
  "title": "PR contribution check",
  "agent": "build"
}

columns (3)

idtitleagent

trial 2·8802ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "ses_01d64c22bffe7B9Z3shNeMWiPa",
  "title": "PR contribution check",
  "agent": "build"
}

columns (3)

idtitleagent

trial 3·9838ms·rows 25isError=false

First row (click to expand JSON)

{
  "id": "ses_01d64c22bffe7B9Z3shNeMWiPa",
  "title": "PR contribution check",
  "agent": "build"
}

columns (3)

idtitleagent

filter-cost3 trials

min 10936ms · median 11346ms · max 13411ms · rows 18,18,18

sessions with recorded cost

Command

SELECT id, title, cost FROM opencode.sessions WHERE cost > 0 ORDER BY cost DESC LIMIT 25

Trials + output

trial 1·11346ms·rows 18isError=false

First row (click to expand JSON)

{
  "id": "ses_0fb115855ffeHr8Fhp5Ruw76KS",
  "title": "Workflow.html and folder analysis",
  "cost": "388.3905347499996"
}

columns (3)

idtitlecost

trial 2·10936ms·rows 18isError=false

First row (click to expand JSON)

{
  "id": "ses_0fb115855ffeHr8Fhp5Ruw76KS",
  "title": "Workflow.html and folder analysis",
  "cost": "388.3905347499996"
}

columns (3)

idtitlecost

trial 3·13411ms·rows 18isError=false

First row (click to expand JSON)

{
  "id": "ses_0fb115855ffeHr8Fhp5Ruw76KS",
  "title": "Workflow.html and folder analysis",
  "cost": "388.3905347499996"
}

columns (3)

idtitlecost

filter-tokens3 trials

min 8654ms · median 8714ms · max 9903ms · rows 5,5,5

sessions with >1M input tokens

Command

SELECT id, model, model_provider, cost FROM opencode.sessions WHERE tokens_input > 1000000 ORDER BY cost DESC LIMIT 5

Trials + output

trial 1·8654ms·rows 5isError=false

First row (click to expand JSON)

{
  "id": "ses_faedde194ffe3SEEUk03dXfiu3",
  "model": "{\"id\":\"MiniMax-M3\",\"providerID\":\"samagama\"}",
  "model_provider": "samagama",
  "cost": "0.0"
}

columns (4)

idmodelmodel_providercost

trial 2·8714ms·rows 5isError=false

First row (click to expand JSON)

{
  "id": "ses_faedde194ffe3SEEUk03dXfiu3",
  "model": "{\"id\":\"MiniMax-M3\",\"providerID\":\"samagama\"}",
  "model_provider": "samagama",
  "cost": "0.0"
}

columns (4)

idmodelmodel_providercost

trial 3·9903ms·rows 5isError=false

First row (click to expand JSON)

{
  "id": "ses_faedde194ffe3SEEUk03dXfiu3",
  "model": "{\"id\":\"MiniMax-M3\",\"providerID\":\"samagama\"}",
  "model_provider": "samagama",
  "cost": "0.0"
}

columns (4)

idmodelmodel_providercost

aggregate3 trials

min 11638ms · median 12101ms · max 13152ms · rows 1,1,1

source-wide totals

Command

SELECT count(*) AS sessions, sum(cost) AS total_cost, sum(tokens_input) AS total_in_tokens FROM opencode.sessions

Trials + output

trial 1·12101ms·rows 1isError=false

First row (click to expand JSON)

{
  "sessions": "459",
  "total_cost": "623.2679184999996",
  "total_in_tokens": "1440049574"
}

columns (3)

sessionstotal_costtotal_in_tokens

trial 2·13152ms·rows 1isError=false

First row (click to expand JSON)

{
  "sessions": "459",
  "total_cost": "623.2679184999996",
  "total_in_tokens": "1440049574"
}

columns (3)

sessionstotal_costtotal_in_tokens

trial 3·11638ms·rows 1isError=false

First row (click to expand JSON)

{
  "sessions": "459",
  "total_cost": "623.2679184999996",
  "total_in_tokens": "1440049574"
}

columns (3)

sessionstotal_costtotal_in_tokens

group-by3 trials

min 11659ms · median 12197ms · max 13068ms · rows 15,15,15

output tokens per provider

Command

SELECT model_provider, COUNT(*) AS n, SUM(tokens_output) AS out_tokens FROM opencode.sessions GROUP BY model_provider ORDER BY out_tokens DESC LIMIT 15

Trials + output

trial 1·13068ms·rows 15isError=false

First row (click to expand JSON)

{
  "model_provider": "samagama",
  "n": "121",
  "out_tokens": "12539359"
}

columns (3)

model_providernout_tokens

trial 2·11659ms·rows 15isError=false

First row (click to expand JSON)

{
  "model_provider": "samagama",
  "n": "121",
  "out_tokens": "12539359"
}

columns (3)

model_providernout_tokens

trial 3·12197ms·rows 15isError=false

First row (click to expand JSON)

{
  "model_provider": "samagama",
  "n": "121",
  "out_tokens": "12539359"
}

columns (3)

model_providernout_tokens

All returned rowsacross all non-errored trials · filterable · paginated

368 rows stored · 368 returned · page 1/15


0	0	ses_0150f217cffeGq9tAm4scX8k63	Complete remaining tasks from session	build	samagama	180068861	1035057	—	—	—	—	—	—
0	1	ses_048e8fca1ffeEzXkR2H7LmiSMN	MS Graph 733-table battery re-run	build	samagama	67834918	1633900	—	—	—	—	—	—
0	2	ses_000c159f2ffeOoNzxoUMIfpfD3	Undo changes and align to git	build	samagama	62123231	417843	—	—	—	—	—	—
1	3	ses_0150f217cffeGq9tAm4scX8k63	Complete remaining tasks from session	build	samagama	180068861	1035057	—	—	—	—	—	—
1	4	ses_048e8fca1ffeEzXkR2H7LmiSMN	MS Graph 733-table battery re-run	build	samagama	67834918	1633900	—	—	—	—	—	—
1	5	ses_000c159f2ffeOoNzxoUMIfpfD3	Undo changes and align to git	build	samagama	62123231	417843	—	—	—	—	—	—
2	6	ses_0150f217cffeGq9tAm4scX8k63	Complete remaining tasks from session	build	samagama	180068861	1035057	—	—	—	—	—	—
2	7	ses_048e8fca1ffeEzXkR2H7LmiSMN	MS Graph 733-table battery re-run	build	samagama	67834918	1633900	—	—	—	—	—	—
2	8	ses_000c159f2ffeOoNzxoUMIfpfD3	Undo changes and align to git	build	samagama	62123231	417843	—	—	—	—	—	—
3	9	ses_0150f217cffeGq9tAm4scX8k63	Complete remaining tasks from session	build	samagama	180068861	1035057	—	—	—	—	—	—
3	10	ses_048e8fca1ffeEzXkR2H7LmiSMN	MS Graph 733-table battery re-run	build	samagama	67834918	1633900	—	—	—	—	—	—
3	11	ses_000c159f2ffeOoNzxoUMIfpfD3	Undo changes and align to git	build	samagama	62123231	417843	—	—	—	—	—	—
0	12	ses_01d64c22bffe7B9Z3shNeMWiPa	PR contribution check	build	samagama	—	—	—	—	—	—	—	—
0	13	ses_faedde194ffe3SEEUk03dXfiu3	Coral MCP benchmark reporting repo setup	build	samagama	—	—	—	—	—	—	—	—
0	14	ses_fa9319fc2ffeqM2U80iHWd8H9z	Exploring Coral OpenCode MCP capabilities	build	samagama	—	—	—	—	—	—	—	—
0	15	ses_fa92f43b0ffexAb0pUt4hTj2O6	Map coral-engine + coral-spec for sqlite backend (@explore subagent)	explore	samagama	—	—	—	—	—	—	—	—
0	16	ses_000c159f2ffeOoNzxoUMIfpfD3	Undo changes and align to git	build	samagama	—	—	—	—	—	—	—	—
0	17	ses_fb0f25a1bffeewAJ0rQSugN624	Pre-dev-grade repository grading skill	build	samagama	—	—	—	—	—	—	—	—
0	18	ses_fa97a98bcffeopz53rsAqRyg7H	New session - 2026-08-31T06:32:58.435Z	build	samagama	—	—	—	—	—	—	—	—
0	19	ses_fa9928555ffetthUA0mibXC7PT	Verifying agentic_chat dashboard quality score	build	samagama	—	—	—	—	—	—	—	—
0	20	ses_fa989d12effe5jSAyQQzBbTwhh	Blindfold repo score validation	build	samagama	—	—	—	—	—	—	—	—
0	21	ses_facb90534ffe1XtH6F8Gp09ykk	Copy image from Google Docs to clipboard	build	samagama	—	—	—	—	—	—	—	—
0	22	ses_facd5a156ffeHh1mhyClcQPde7	Hindi translation showing raw key on contact page	build	samagama	—	—	—	—	—	—	—	—
0	23	ses_facdb6e35ffeRcne02LufXzDmx	Increasing internal space without affecting development	build	samagama	—	—	—	—	—	—	—	—
0	24	ses_fad14bc6cffeG2SU560c37T6dA	Comparing coral_benchmarks and coral-specs-testing	build	samagama	—	—	—	—	—	—	—	—

Column profile

7 columns actually returned by coral. Catalog claims no required filters. Click a column to drill in.

#	Column	Inferred type	Non-null	Nulls	Sample value(s)
1	id	string	20	8	`"ses_0150f217cffeGq9tAm4scX8k63""ses_01d64c22bffe7B9Z3shNeMWiPa""ses_0fb115855ffeHr8Fhp5Ruw76KS"`
2	title	string	16	12	`"Complete remaining tasks from session""PR contribution check""Workflow.html and folder analysis"`
3	agent	string	12	16	`"build"`
4	model_provider	string	16	12	`"samagama"`
5	tokens_input	string	4	24	`"180068861"`
6	tokens_output	string	4	24	`"1035057"`
7	cost	string	16	12	`"0.0""388.3905347499996"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	8837ms	3	ok	id, title, agent
minimal	t2	10463ms	3	ok	id, title, agent
minimal	t3	9209ms	3	ok	id, title, agent
order-desc	t1	10054ms	25	ok	id, title, agent
order-desc	t2	11285ms	25	ok	id, title, agent
order-desc	t3	9957ms	25	ok	id, title, agent
filter-agent	t1	9575ms	25	ok	id, title, agent
filter-agent	t2	8802ms	25	ok	id, title, agent
filter-agent	t3	9838ms	25	ok	id, title, agent
filter-cost	t1	11346ms	18	ok	id, title, cost
filter-cost	t2	10936ms	18	ok	id, title, cost
filter-cost	t3	13411ms	18	ok	id, title, cost
filter-tokens	t1	8654ms	5	ok	id, model, model_provider
filter-tokens	t2	8714ms	5	ok	id, model, model_provider
filter-tokens	t3	9903ms	5	ok	id, model, model_provider
aggregate	t1	12101ms	1	ok	sessions, total_cost, total_in_tokens
aggregate	t2	13152ms	1	ok	sessions, total_cost, total_in_tokens
aggregate	t3	11638ms	1	ok	sessions, total_cost, total_in_tokens
group-by	t1	13068ms	15	ok	model_provider, n, out_tokens
group-by	t2	11659ms	15	ok	model_provider, n, out_tokens
group-by	t3	12197ms	15	ok	model_provider, n, out_tokens

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Run the converter first to populate the JSONL files:

Columns coral returned (7)

idtitleagentmodel_providertokens_inputtokens_outputcost

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T09:48:49Z

JSON record: reports/opencode/tables/sessions.json

first_run_at: 2026-09-01T08:31:15Z

last_retried_at: 2026-09-01T09:48:49Z

retry_count: 3

View version history →