`opencode.session_messages`

pass

Per-session message stream with the `seq` order OpenCode assigns internally, alongside the full payload as JSON. Use this when you need exact session-relative ordering rather than `time_created`.

SELECT id, session_id, type, seq, time_created

no filters captured 2026-09-01 10:13:55Zmedian 6480 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	6466 ms	6480 ms	6481 ms	[1, 1, 1]
by-session	3	6477 ms	6478 ms	6506 ms	[1, 1, 1]
filter-type	3	6468 ms	6485 ms	6487 ms	[25, 25, 25]
aggregate	3	6491 ms	6497 ms	6501 ms	[1, 1, 1]

Latency per trial

minimalmedian 6480ms

scale: 0–6481 ms

by-sessionmedian 6478ms

scale: 0–6506 ms

filter-typemedian 6485ms

scale: 0–6487 ms

aggregatemedian 6497ms

scale: 0–6501 ms

Probe variants — every command + output

minimal3 trials

min 6466ms · median 6480ms · max 6481ms · rows 1,1,1

earliest stream entry

Command

SELECT id, session_id, type, seq FROM opencode.session_messages WHERE session_id = 'ses_0e12f16e3ffeinbgIlSOaMSnFc' ORDER BY seq ASC LIMIT 1

Trials + output

trial 1·6480ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_f1ed12163001puZWnrt7zF2UA4",
  "session_id": "ses_0e12f16e3ffeinbgIlSOaMSnFc",
  "type": "model-switched",
  "seq": "8"
}

columns (4)

idsession_idtypeseq

trial 2·6481ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_f1ed12163001puZWnrt7zF2UA4",
  "session_id": "ses_0e12f16e3ffeinbgIlSOaMSnFc",
  "type": "model-switched",
  "seq": "8"
}

columns (4)

idsession_idtypeseq

trial 3·6466ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_f1ed12163001puZWnrt7zF2UA4",
  "session_id": "ses_0e12f16e3ffeinbgIlSOaMSnFc",
  "type": "model-switched",
  "seq": "8"
}

columns (4)

idsession_idtypeseq

by-session3 trials

min 6477ms · median 6478ms · max 6506ms · rows 1,1,1

full stream order for one session

Command

SELECT id, session_id, type, seq, time_created FROM opencode.session_messages WHERE session_id = 'ses_0ea0e3dc8ffectnX7hbvw2dhgG' ORDER BY seq ASC LIMIT 25

Trials + output

trial 1·6506ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_f15f1c24600154IWf8cYYRl3yQ",
  "session_id": "ses_0ea0e3dc8ffectnX7hbvw2dhgG",
  "type": "model-switched",
  "seq": "1",
  "time_created": "1782779593285"
}

columns (5)

idsession_idtypeseqtime_created

trial 2·6477ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_f15f1c24600154IWf8cYYRl3yQ",
  "session_id": "ses_0ea0e3dc8ffectnX7hbvw2dhgG",
  "type": "model-switched",
  "seq": "1",
  "time_created": "1782779593285"
}

columns (5)

idsession_idtypeseqtime_created

trial 3·6478ms·rows 1isError=false

First row (click to expand JSON)

{
  "id": "msg_f15f1c24600154IWf8cYYRl3yQ",
  "session_id": "ses_0ea0e3dc8ffectnX7hbvw2dhgG",
  "type": "model-switched",
  "seq": "1",
  "time_created": "1782779593285"
}

columns (5)

idsession_idtypeseqtime_created

filter-type3 trials

min 6468ms · median 6485ms · max 6487ms · rows 25,25,25

model-switched entries across sessions

Command

SELECT session_id, type, seq FROM opencode.session_messages WHERE type = 'model-switched' ORDER BY time_created DESC LIMIT 25

Trials + output

trial 1·6485ms·rows 25isError=false

First row (click to expand JSON)

{
  "session_id": "ses_0e12f16e3ffeinbgIlSOaMSnFc",
  "type": "model-switched",
  "seq": "8"
}

columns (3)

session_idtypeseq

trial 2·6487ms·rows 25isError=false

First row (click to expand JSON)

{
  "session_id": "ses_0e12f16e3ffeinbgIlSOaMSnFc",
  "type": "model-switched",
  "seq": "8"
}

columns (3)

session_idtypeseq

trial 3·6468ms·rows 25isError=false

First row (click to expand JSON)

{
  "session_id": "ses_0e12f16e3ffeinbgIlSOaMSnFc",
  "type": "model-switched",
  "seq": "8"
}

columns (3)

session_idtypeseq

aggregate3 trials

min 6491ms · median 6497ms · max 6501ms · rows 1,1,1

stream entry types

Command

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

Trials + output

trial 1·6501ms·rows 1isError=false

First row (click to expand JSON)

{
  "type": "model-switched",
  "n": "34"
}

columns (2)

typen

trial 2·6491ms·rows 1isError=false

First row (click to expand JSON)

{
  "type": "model-switched",
  "n": "34"
}

columns (2)

typen

trial 3·6497ms·rows 1isError=false

First row (click to expand JSON)

{
  "type": "model-switched",
  "n": "34"
}

columns (2)

typen

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

112 rows stored · 112 returned · page 1/5


0	0	msg_f1ed12163001puZWnrt7zF2UA4	ses_0e12f16e3ffeinbgIlSOaMSnFc	model-switched	8	—	—
1	1	msg_f1ed12163001puZWnrt7zF2UA4	ses_0e12f16e3ffeinbgIlSOaMSnFc	model-switched	8	—	—
2	2	msg_f1ed12163001puZWnrt7zF2UA4	ses_0e12f16e3ffeinbgIlSOaMSnFc	model-switched	8	—	—
3	3	msg_f1ed12163001puZWnrt7zF2UA4	ses_0e12f16e3ffeinbgIlSOaMSnFc	model-switched	8	—	—
0	4	msg_f15f1c24600154IWf8cYYRl3yQ	ses_0ea0e3dc8ffectnX7hbvw2dhgG	model-switched	1	1782779593285	—
1	5	msg_f15f1c24600154IWf8cYYRl3yQ	ses_0ea0e3dc8ffectnX7hbvw2dhgG	model-switched	1	1782779593285	—
2	6	msg_f15f1c24600154IWf8cYYRl3yQ	ses_0ea0e3dc8ffectnX7hbvw2dhgG	model-switched	1	1782779593285	—
3	7	msg_f15f1c24600154IWf8cYYRl3yQ	ses_0ea0e3dc8ffectnX7hbvw2dhgG	model-switched	1	1782779593285	—
0	8	—	ses_0e12f16e3ffeinbgIlSOaMSnFc	model-switched	8	—	—
0	9	—	ses_0e766b809ffeshwyTrMZEDcVs1	model-switched	1	—	—
0	10	—	ses_0e76b33bfffecf7eMhdilfI0rt	model-switched	1	—	—
0	11	—	ses_0ea0e3dc8ffectnX7hbvw2dhgG	model-switched	1	—	—
0	12	—	ses_0ea0e52a8ffess7OW0OmIbMYoZ	model-switched	1	—	—
0	13	—	ses_0ea12844fffeOU16eHs2RgAJGg	model-switched	1	—	—
0	14	—	ses_0ea12985cffeVgRTRcIfIos62L	model-switched	1	—	—
0	15	—	ses_0ea12b575ffeU3coZGYoShSlt9	model-switched	1	—	—
0	16	—	ses_0ea12cdd7ffe3vWShdUYyl8rOk	model-switched	1	—	—
0	17	—	ses_0ea12e8acffemVhd6xlfMQ2B1y	model-switched	1	—	—
0	18	—	ses_0ea130477ffeFvppjpvaHLNiXr	model-switched	1	—	—
0	19	—	ses_0ea131ee5ffeYpD3h0MJcujlMZ	model-switched	1	—	—
0	20	—	ses_0ea13398fffeiziWpO5cMAh388	model-switched	1	—	—
0	21	—	ses_0ea1356b4ffejOg6ZH6omwA46s	model-switched	1	—	—
0	22	—	ses_0ea137146ffe39rFmpWDmVQTzS	model-switched	1	—	—
0	23	—	ses_0ea138d62ffeN1nRwkwzt8rSjJ	model-switched	1	—	—
0	24	—	ses_0ea13a890ffeyuzrYqvsuWwLmi	model-switched	1	—	—

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	8	`"msg_f1ed12163001puZWnrt7zF2UA4""msg_f15f1c24600154IWf8cYYRl3yQ"`
2	session_id	string	12	4	`"ses_0e12f16e3ffeinbgIlSOaMSnFc""ses_0ea0e3dc8ffectnX7hbvw2dhgG"`
3	type	string	16	0	`"model-switched"`
4	seq	string	12	4	`"8""1"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	6480ms	1	ok	id, session_id, type
minimal	t2	6481ms	1	ok	id, session_id, type
minimal	t3	6466ms	1	ok	id, session_id, type
by-session	t1	6506ms	1	ok	id, session_id, type
by-session	t2	6477ms	1	ok	id, session_id, type
by-session	t3	6478ms	1	ok	id, session_id, type
filter-type	t1	6485ms	25	ok	session_id, type, seq
filter-type	t2	6487ms	25	ok	session_id, type, seq
filter-type	t3	6468ms	25	ok	session_id, type, seq
aggregate	t1	6501ms	1	ok	type, n
aggregate	t2	6491ms	1	ok	type, n
aggregate	t3	6497ms	1	ok	type, n

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)

SELECT id, session_id, type, seq, time_created

Columns coral returned (4)

idsession_idtypeseq

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T10:13:55Z

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

first_run_at: 2026-09-01T08:53:51Z

last_retried_at: 2026-09-01T10:13:55Z

retry_count: 3

View version history →