`opencode.workspaces`

pass

All OpenCode workspaces. Each row carries the workspace id, project, directory, type, name, branch, extra metadata, and the recorded `time_used` counter.

SELECT id, project_id, directory, type, name, branch, time_used

no filters captured 2026-09-01 11:58:21Zmedian 10677 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	10306 ms	10677 ms	12358 ms	[0, 0, 0]
scan	3	11059 ms	11401 ms	11745 ms	[0, 0, 0]
count	3	7872 ms	8484 ms	8991 ms	[1, 1, 1]

Latency per trial

minimalmedian 10677ms

scale: 0–12358 ms

scanmedian 11401ms

scale: 0–11745 ms

countmedian 8484ms

scale: 0–8991 ms

Probe variants — every command + output

minimal3 trials

min 10306ms · median 10677ms · max 12358ms · rows 0,0,0

smallest query (currently empty)

Command

SELECT id, project_id, directory, type, name, branch, time_used FROM opencode.workspaces LIMIT 1

Trials + output

trial 1·10306ms·rows 0isError=false

trial 2·10677ms·rows 0isError=false

trial 3·12358ms·rows 0isError=false

scan3 trials

min 11059ms · median 11401ms · max 11745ms · rows 0,0,0

typical scan (currently empty)

Command

SELECT id, project_id, directory, name FROM opencode.workspaces LIMIT 25

Trials + output

trial 1·11401ms·rows 0isError=false

trial 2·11059ms·rows 0isError=false

trial 3·11745ms·rows 0isError=false

count3 trials

min 7872ms · median 8484ms · max 8991ms · rows 1,1,1

row count (currently 0)

Command

SELECT COUNT(*) AS n FROM opencode.workspaces

Trials + output

trial 1·7872ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0"
}

columns (1)

trial 2·8991ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0"
}

columns (1)

trial 3·8484ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0"
}

columns (1)

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

4 rows stored · 4 returned · page 1/1


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

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	10306ms	0	ok	—
minimal	t2	10677ms	0	ok	—
minimal	t3	12358ms	0	ok	—
scan	t1	11401ms	0	ok	—
scan	t2	11059ms	0	ok	—
scan	t3	11745ms	0	ok	—
count	t1	7872ms	1	ok	n
count	t2	8991ms	1	ok	n
count	t3	8484ms	1	ok	n

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T11:58:21Z

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

first_run_at: 2026-09-01T09:03:59Z

last_retried_at: 2026-09-01T11:58:21Z

retry_count: 3

View version history →