`opencode.session_context_epochs`

pass

Per-session context-epoch rows opencode uses to track context compaction / baseline snapshots. Useful for auditing compaction history.

SELECT session_id, baseline, baseline_seq

no filters captured 2026-09-01 12:21:04Zmedian 6578 ms

Verdict: TRUE

Reachable and queryable: 0 errors across all trials, but the table is currently empty in the source (no data rows on scan variants). See analysis.json → data.empty_table.

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	3	6558 ms	6578 ms	6593 ms	[0, 0, 0]
by-session	3	6524 ms	6549 ms	6628 ms	[0, 0, 0]
order	3	6492 ms	6497 ms	6690 ms	[0, 0, 0]
aggregate	3	6504 ms	6519 ms	6532 ms	[1, 1, 1]

Latency per trial

minimalmedian 6578ms

scale: 0–6593 ms

by-sessionmedian 6549ms

scale: 0–6628 ms

ordermedian 6497ms

scale: 0–6690 ms

aggregatemedian 6519ms

scale: 0–6532 ms

Probe variants — every command + output

minimal3 trials

min 6558ms · median 6578ms · max 6593ms · rows 0,0,0

smallest query

Command

SELECT session_id, baseline, baseline_seq FROM opencode.session_context_epochs LIMIT 1

Trials + output

trial 1·6593ms·rows 0isError=false

trial 2·6558ms·rows 0isError=false

trial 3·6578ms·rows 0isError=false

by-session3 trials

min 6524ms · median 6549ms · max 6628ms · rows 0,0,0

compaction epochs for one session

Command

SELECT session_id, baseline, baseline_seq FROM opencode.session_context_epochs WHERE session_id = 'ses_faedde194ffe3SEEUk03dXfiu3' ORDER BY baseline_seq ASC LIMIT 25

Trials + output

trial 1·6524ms·rows 0isError=false

trial 2·6628ms·rows 0isError=false

trial 3·6549ms·rows 0isError=false

order3 trials

min 6492ms · median 6497ms · max 6690ms · rows 0,0,0

epochs with the highest baselines

Command

SELECT session_id, baseline, baseline_seq FROM opencode.session_context_epochs ORDER BY baseline_seq DESC LIMIT 25

Trials + output

trial 1·6497ms·rows 0isError=false

trial 2·6492ms·rows 0isError=false

trial 3·6690ms·rows 0isError=false

aggregate3 trials

min 6504ms · median 6519ms · max 6532ms · rows 1,1,1

compaction epoch volume

Command

SELECT COUNT(*) AS n, COUNT(DISTINCT session_id) AS sessions FROM opencode.session_context_epochs

Trials + output

trial 1·6519ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "sessions": "0"
}

columns (2)

nsessions

trial 2·6532ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "sessions": "0"
}

columns (2)

nsessions

trial 3·6504ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "sessions": "0"
}

columns (2)

nsessions

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

4 rows stored · 4 returned · page 1/1


0	0	0	0
1	1	0	0
2	2	0	0
3	3	0	0

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	6593ms	0	ok	—
minimal	t2	6558ms	0	ok	—
minimal	t3	6578ms	0	ok	—
by-session	t1	6524ms	0	ok	—
by-session	t2	6628ms	0	ok	—
by-session	t3	6549ms	0	ok	—
order	t1	6497ms	0	ok	—
order	t2	6492ms	0	ok	—
order	t3	6690ms	0	ok	—
aggregate	t1	6519ms	1	ok	n, sessions
aggregate	t2	6532ms	1	ok	n, sessions
aggregate	t3	6504ms	1	ok	n, sessions

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

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

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

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

retry_count: 1

View version history →