`opencode.event_sequences`

pass

Per-aggregate event sequencing counters opencode uses to keep events ordered. Useful for understanding which aggregate owns an event stream and how far it has advanced.

SELECT aggregate_id, seq, owner_id

no filters captured 2026-09-01 11:31:47Zmedian 12532 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	11758 ms	12532 ms	12617 ms	[10, 10, 10]
order	3	11022 ms	12254 ms	13319 ms	[25, 25, 25]
aggregate	3	12522 ms	18151 ms	22069 ms	[1, 1, 1]

Latency per trial

minimalmedian 12532ms

scale: 0–12617 ms

ordermedian 12254ms

scale: 0–13319 ms

aggregatemedian 18151ms

scale: 0–22069 ms

Probe variants — every command + output

minimal3 trials

min 11758ms · median 12532ms · max 12617ms · rows 10,10,10

highest-seq aggregates

Command

SELECT aggregate_id, seq, owner_id FROM opencode.event_sequences ORDER BY seq DESC LIMIT 10

Trials + output

trial 1·12532ms·rows 10isError=false

First row (click to expand JSON)

{
  "aggregate_id": "ses_048e8fca1ffeEzXkR2H7LmiSMN",
  "seq": "56951",
  "owner_id": ""
}

columns (3)

aggregate_idseqowner_id

trial 2·11758ms·rows 10isError=false

First row (click to expand JSON)

{
  "aggregate_id": "ses_048e8fca1ffeEzXkR2H7LmiSMN",
  "seq": "56951",
  "owner_id": ""
}

columns (3)

aggregate_idseqowner_id

trial 3·12617ms·rows 10isError=false

First row (click to expand JSON)

{
  "aggregate_id": "ses_048e8fca1ffeEzXkR2H7LmiSMN",
  "seq": "56951",
  "owner_id": ""
}

columns (3)

aggregate_idseqowner_id

order3 trials

min 11022ms · median 12254ms · max 13319ms · rows 25,25,25

event sequences, highest first

Command

SELECT aggregate_id, seq, owner_id FROM opencode.event_sequences ORDER BY seq DESC LIMIT 25

Trials + output

trial 1·13319ms·rows 25isError=false

First row (click to expand JSON)

{
  "aggregate_id": "ses_048e8fca1ffeEzXkR2H7LmiSMN",
  "seq": "56951",
  "owner_id": ""
}

columns (3)

aggregate_idseqowner_id

trial 2·11022ms·rows 25isError=false

First row (click to expand JSON)

{
  "aggregate_id": "ses_048e8fca1ffeEzXkR2H7LmiSMN",
  "seq": "56951",
  "owner_id": ""
}

columns (3)

aggregate_idseqowner_id

trial 3·12254ms·rows 25isError=false

First row (click to expand JSON)

{
  "aggregate_id": "ses_048e8fca1ffeEzXkR2H7LmiSMN",
  "seq": "56951",
  "owner_id": ""
}

columns (3)

aggregate_idseqowner_id

aggregate3 trials

min 12522ms · median 18151ms · max 22069ms · rows 1,1,1

event sequence totals

Command

SELECT COUNT(*) AS n, MAX(seq) AS max_seq, COUNT(DISTINCT aggregate_id) AS aggregates FROM opencode.event_sequences

Trials + output

trial 1·18151ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "417",
  "max_seq": "56951",
  "aggregates": "417"
}

columns (3)

nmax_seqaggregates

trial 2·22069ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "417",
  "max_seq": "56951",
  "aggregates": "417"
}

columns (3)

nmax_seqaggregates

trial 3·12522ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "417",
  "max_seq": "56951",
  "aggregates": "417"
}

columns (3)

nmax_seqaggregates

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

144 rows stored · 144 returned · page 1/6


0	0	ses_048e8fca1ffeEzXkR2H7LmiSMN	56951	—	—	—	—
0	1	ses_0150f217cffeGq9tAm4scX8k63	51810	—	—	—	—
0	2	ses_0532d4c47ffex94jChvMXE3Oxk	47593	—	—	—	—
0	3	ses_fc12f4de2ffeJ4Zybxy6XVKMoK	41023	—	—	—	—
0	4	ses_05fa74231ffeMxWgi5d477wajN	37418	—	—	—	—
0	5	ses_fec5ef42ffferj6H8FtIdwoTCP	36746	—	—	—	—
0	6	ses_024dea563ffeoya2OMhQMy52gC	35980	—	—	—	—
0	7	ses_01e72f9a3ffehpYAhuXGNJmfwO	33866	—	—	—	—
0	8	ses_fdb904842ffeap7VvTgnigLiFK	29806	—	—	—	—
0	9	ses_01b0dde08ffeFqEVKS56TiDuFF	27925	—	—	—	—
1	10	ses_048e8fca1ffeEzXkR2H7LmiSMN	56951	—	—	—	—
1	11	ses_0150f217cffeGq9tAm4scX8k63	51810	—	—	—	—
1	12	ses_0532d4c47ffex94jChvMXE3Oxk	47593	—	—	—	—
1	13	ses_fc12f4de2ffeJ4Zybxy6XVKMoK	41023	—	—	—	—
1	14	ses_05fa74231ffeMxWgi5d477wajN	37418	—	—	—	—
1	15	ses_fec5ef42ffferj6H8FtIdwoTCP	36746	—	—	—	—
1	16	ses_024dea563ffeoya2OMhQMy52gC	35980	—	—	—	—
1	17	ses_01e72f9a3ffehpYAhuXGNJmfwO	33866	—	—	—	—
1	18	ses_fdb904842ffeap7VvTgnigLiFK	29806	—	—	—	—
1	19	ses_01b0dde08ffeFqEVKS56TiDuFF	27925	—	—	—	—
2	20	ses_048e8fca1ffeEzXkR2H7LmiSMN	56951	—	—	—	—
2	21	ses_0150f217cffeGq9tAm4scX8k63	51810	—	—	—	—
2	22	ses_0532d4c47ffex94jChvMXE3Oxk	47593	—	—	—	—
2	23	ses_fc12f4de2ffeJ4Zybxy6XVKMoK	41023	—	—	—	—
2	24	ses_05fa74231ffeMxWgi5d477wajN	37418	—	—	—	—

Column profile

3 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	aggregate_id	string	8	4	`"ses_048e8fca1ffeEzXkR2H7LmiSMN"`
2	seq	string	8	4	`"56951"`
3	owner_id	—	0	12	empty

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	12532ms	10	ok	aggregate_id, seq, owner_id
minimal	t2	11758ms	10	ok	aggregate_id, seq, owner_id
minimal	t3	12617ms	10	ok	aggregate_id, seq, owner_id
order	t1	13319ms	25	ok	aggregate_id, seq, owner_id
order	t2	11022ms	25	ok	aggregate_id, seq, owner_id
order	t3	12254ms	25	ok	aggregate_id, seq, owner_id
aggregate	t1	18151ms	1	ok	n, max_seq, aggregates
aggregate	t2	22069ms	1	ok	n, max_seq, aggregates
aggregate	t3	12522ms	1	ok	n, max_seq, aggregates

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

SELECT aggregate_id, seq, owner_id

Columns coral returned (3)

aggregate_idseqowner_id

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T11:31:47Z

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

first_run_at: 2026-09-01T11:31:47Z

last_retried_at: 2026-09-01T11:31:47Z

retry_count: 1

View version history →