`opencode.events`

pass

The full OpenCode domain event log. This is OpenCode's largest and most granular table: every state change (session created, message appended, todo updated, ...) is recorded here with an aggregate id and per-aggregate sequence number. The `data` blob is typed by `type`.

Count events by type:

no filters captured 2026-09-01 12:04:32Zmedian 8795 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	7072 ms	8795 ms	9222 ms	[1, 1, 1]
group-by	3	21332 ms	21342 ms	22348 ms	[5, 5, 5]
by-aggregate	3	20120 ms	20200 ms	21854 ms	[25, 25, 25]
json-extract	3	70819 ms	81830 ms	103900 ms	[5, 5, 5]
aggregate	3	24161 ms	26551 ms	31779 ms	[1, 1, 1]
edge	3	10045 ms	11394 ms	15152 ms	[200, 200, 200]

Latency per trial

minimalmedian 8795ms

scale: 0–9222 ms

group-bymedian 21342ms

scale: 0–22348 ms

by-aggregatemedian 20200ms

scale: 0–21854 ms

json-extractmedian 81830ms

scale: 0–103900 ms

aggregatemedian 26551ms

scale: 0–31779 ms

edgemedian 11394ms

scale: 0–15152 ms

Probe variants — every command + output

minimal3 trials

min 7072ms · median 8795ms · max 9222ms · rows 1,1,1

smallest query

Command

SELECT id, aggregate_id, seq, type FROM opencode.events LIMIT 1

Trials + output

trial 1·8795ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "evt_0284bb3e0001jQUn5dK8eJxnsV",
  "aggregate_id": "ses_fdb904842ffeap7VvTgnigLiFK",
  "seq": "4575",
  "type": "message.part.updated.1"
}

columns (4)

idaggregate_idseqtype

trial 2·9222ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "evt_0284bb3e0001jQUn5dK8eJxnsV",
  "aggregate_id": "ses_fdb904842ffeap7VvTgnigLiFK",
  "seq": "4575",
  "type": "message.part.updated.1"
}

columns (4)

idaggregate_idseqtype

trial 3·7072ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "evt_0284bb3e0001jQUn5dK8eJxnsV",
  "aggregate_id": "ses_fdb904842ffeap7VvTgnigLiFK",
  "seq": "4575",
  "type": "message.part.updated.1"
}

columns (4)

idaggregate_idseqtype

group-by3 trials

min 21332ms · median 21342ms · max 22348ms · rows 5,5,5

events by type

Command

SELECT type, COUNT(*) AS n FROM opencode.events GROUP BY type ORDER BY n DESC LIMIT 10

Trials + output

trial 1·21342ms·rows 5isError=false

First row (click to expand JSON)

{
  "type": "message.part.updated.1",
  "n": "637947"
}

columns (2)

typen

trial 2·22348ms·rows 5isError=false

First row (click to expand JSON)

{
  "type": "message.part.updated.1",
  "n": "637947"
}

columns (2)

typen

trial 3·21332ms·rows 5isError=false

First row (click to expand JSON)

{
  "type": "message.part.updated.1",
  "n": "637947"
}

columns (2)

typen

by-aggregate3 trials

min 20120ms · median 20200ms · max 21854ms · rows 25,25,25

event stream for one session

Command

SELECT seq, type FROM opencode.events WHERE aggregate_id = 'ses_faedde194ffe3SEEUk03dXfiu3' ORDER BY seq ASC LIMIT 25

Trials + output

trial 1·21854ms·rows 25isError=false

First row (click to expand JSON)

{
  "seq": "0",
  "type": "session.created.1"
}

columns (2)

seqtype

trial 2·20120ms·rows 25isError=false

First row (click to expand JSON)

{
  "seq": "0",
  "type": "session.created.1"
}

columns (2)

seqtype

trial 3·20200ms·rows 25isError=false

First row (click to expand JSON)

{
  "seq": "0",
  "type": "session.created.1"
}

columns (2)

seqtype

json-extract3 trials

min 70819ms · median 81830ms · max 103900ms · rows 5,5,5

typed JSON blob alongside event

Command

SELECT seq, type, json_as_text(data, 'tokens') AS tokens FROM opencode.events WHERE aggregate_id = 'ses_faedde194ffe3SEEUk03dXfiu3' ORDER BY seq ASC LIMIT 5

Trials + output

trial 1·70819ms·rows 5isError=false

First row (click to expand JSON)

{
  "seq": "0",
  "type": "session.created.1",
  "tokens": ""
}

columns (3)

seqtypetokens

trial 2·81830ms·rows 5isError=false

First row (click to expand JSON)

{
  "seq": "0",
  "type": "session.created.1",
  "tokens": ""
}

columns (3)

seqtypetokens

trial 3·103900ms·rows 5isError=false

First row (click to expand JSON)

{
  "seq": "0",
  "type": "session.created.1",
  "tokens": ""
}

columns (3)

seqtypetokens

aggregate3 trials

min 24161ms · median 26551ms · max 31779ms · rows 1,1,1

total event volume

Command

SELECT COUNT(*) AS n, COUNT(DISTINCT aggregate_id) AS aggregates FROM opencode.events

Trials + output

trial 1·24161ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "947385",
  "aggregates": "417"
}

columns (2)

naggregates

trial 2·31779ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "947385",
  "aggregates": "417"
}

columns (2)

naggregates

trial 3·26551ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "947385",
  "aggregates": "417"
}

columns (2)

naggregates

edge3 trials

min 10045ms · median 11394ms · max 15152ms · rows 200,200,200

edge: larger limit

Command

SELECT id, aggregate_id, type FROM opencode.events LIMIT 200

Trials + output

trial 1·11394ms·rows 200isError=false

First row (click to expand JSON)

{
  "id": "evt_0284bb3e0001jQUn5dK8eJxnsV",
  "aggregate_id": "ses_fdb904842ffeap7VvTgnigLiFK",
  "type": "message.part.updated.1"
}

columns (3)

idaggregate_idtype

trial 2·15152ms·rows 200isError=false

First row (click to expand JSON)

{
  "id": "evt_fe4ce6503001D1ofu2QY0grt8R",
  "aggregate_id": "ses_01b4f408dffemFRhrBIJXD6O9b",
  "type": "message.part.updated.1"
}

columns (3)

idaggregate_idtype

trial 3·10045ms·rows 200isError=false

First row (click to expand JSON)

{
  "id": "evt_fe4ce6503001D1ofu2QY0grt8R",
  "aggregate_id": "ses_01b4f408dffemFRhrBIJXD6O9b",
  "type": "message.part.updated.1"
}

columns (3)

idaggregate_idtype

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

348 rows stored · 948 returned · 4 truncated · page 1/14


0	0	evt_fe4ce6503001D1ofu2QY0grt8R	ses_01b4f408dffemFRhrBIJXD6O9b	3916	message.part.updated.1	—	—	—
1	1	evt_0284bb3e0001jQUn5dK8eJxnsV	ses_fdb904842ffeap7VvTgnigLiFK	4575	message.part.updated.1	—	—	—
2	2	evt_0284bb3e0001jQUn5dK8eJxnsV	ses_fdb904842ffeap7VvTgnigLiFK	4575	message.part.updated.1	—	—	—
3	3	evt_0284bb3e0001jQUn5dK8eJxnsV	ses_fdb904842ffeap7VvTgnigLiFK	4575	message.part.updated.1	—	—	—
0	4	—	—	—	message.part.updated.1	637947	—	—
0	5	—	—	—	message.updated.1	242895	—	—
0	6	—	—	—	session.updated.1	66094	—	—
0	7	—	—	—	session.created.1	415	—	—
0	8	—	—	—	session.next.model.switched.1	34	—	—
1	9	—	—	—	message.part.updated.1	637947	—	—
1	10	—	—	—	message.updated.1	242895	—	—
1	11	—	—	—	session.updated.1	66094	—	—
1	12	—	—	—	session.created.1	415	—	—
1	13	—	—	—	session.next.model.switched.1	34	—	—
2	14	—	—	—	message.part.updated.1	637947	—	—
2	15	—	—	—	message.updated.1	242895	—	—
2	16	—	—	—	session.updated.1	66094	—	—
2	17	—	—	—	session.created.1	415	—	—
2	18	—	—	—	session.next.model.switched.1	34	—	—
3	19	—	—	—	message.part.updated.1	637947	—	—
3	20	—	—	—	message.updated.1	242895	—	—
3	21	—	—	—	session.updated.1	66094	—	—
3	22	—	—	—	session.created.1	415	—	—
3	23	—	—	—	session.next.model.switched.1	34	—	—
0	24	—	—	0	session.created.1	—	—	—

Truncated. 4 trials returned more rows than we stored (safety cap = 200/trial). Increase theMAX_ROWS_RETURNED inscripts/probe_table.py and re-probe to capture more.

Column profile

4 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	8	16	`"evt_fe4ce6503001D1ofu2QY0grt8R""evt_0284bb3e0001jQUn5dK8eJxnsV""evt_fcf0919f3001wGE767DlcMZ29X"`
2	aggregate_id	string	8	16	`"ses_01b4f408dffemFRhrBIJXD6O9b""ses_fdb904842ffeap7VvTgnigLiFK""ses_048e8fca1ffeEzXkR2H7LmiSMN"`
3	seq	string	12	12	`"3916""4575""0"`
4	type	string	20	4	`"message.part.updated.1""session.created.1"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	8795ms	1	ok	id, aggregate_id, seq
minimal	t2	9222ms	1	ok	id, aggregate_id, seq
minimal	t3	7072ms	1	ok	id, aggregate_id, seq
group-by	t1	21342ms	5	ok	type, n
group-by	t2	22348ms	5	ok	type, n
group-by	t3	21332ms	5	ok	type, n
by-aggregate	t1	21854ms	25	ok	seq, type
by-aggregate	t2	20120ms	25	ok	seq, type
by-aggregate	t3	20200ms	25	ok	seq, type
json-extract	t1	70819ms	5	ok	seq, type, tokens
json-extract	t2	81830ms	5	ok	seq, type, tokens
json-extract	t3	103900ms	5	ok	seq, type, tokens
aggregate	t1	24161ms	1	ok	n, aggregates
aggregate	t2	31779ms	1	ok	n, aggregates
aggregate	t3	26551ms	1	ok	n, aggregates
edge	t1	11394ms	200	ok	id, aggregate_id, type
edge	t2	15152ms	200	ok	id, aggregate_id, type
edge	t3	10045ms	200	ok	id, aggregate_id, type

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

Count events by type:

Columns coral returned (4)

idaggregate_idseqtype

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T12:04:32Z

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

first_run_at: 2026-09-01T12:04:32Z

last_retried_at: 2026-09-01T12:04:32Z

retry_count: 1

View version history →