`opencode.permissions`

pass

Permission rows describing what actions a project grants on a resource (read / write on sessions, projects, etc.).

SELECT project_id, action, resource

no filters captured 2026-09-01 12:18:37Zmedian 7622 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	7067 ms	7622 ms	8589 ms	[0, 0, 0]
by-project	3	6615 ms	7561 ms	8068 ms	[0, 0, 0]
group-by	3	6965 ms	7040 ms	8049 ms	[0, 0, 0]
aggregate	3	6496 ms	6673 ms	6878 ms	[1, 1, 1]
edge	3	6512 ms	6539 ms	6543 ms	[0, 0, 0]

Latency per trial

minimalmedian 7622ms

scale: 0–8589 ms

by-projectmedian 7561ms

scale: 0–8068 ms

group-bymedian 7040ms

scale: 0–8049 ms

aggregatemedian 6673ms

scale: 0–6878 ms

edgemedian 6539ms

scale: 0–6543 ms

Probe variants — every command + output

minimal3 trials

min 7067ms · median 7622ms · max 8589ms · rows 0,0,0

smallest query

Command

SELECT id, project_id, action, resource FROM opencode.permissions LIMIT 1

Trials + output

trial 1·7067ms·rows 0isError=false

trial 2·8589ms·rows 0isError=false

trial 3·7622ms·rows 0isError=false

by-project3 trials

min 6615ms · median 7561ms · max 8068ms · rows 0,0,0

permissions granted on one project

Command

SELECT project_id, action, resource FROM opencode.permissions WHERE project_id = '846982133a6c33303221dbc166c0a89074f184ac' ORDER BY id ASC LIMIT 25

Trials + output

trial 1·8068ms·rows 0isError=false

trial 2·6615ms·rows 0isError=false

trial 3·7561ms·rows 0isError=false

group-by3 trials

min 6965ms · median 7040ms · max 8049ms · rows 0,0,0

permission grants by project + action

Command

SELECT project_id, action, COUNT(*) AS n FROM opencode.permissions GROUP BY project_id, action ORDER BY n DESC LIMIT 25

Trials + output

trial 1·8049ms·rows 0isError=false

trial 2·7040ms·rows 0isError=false

trial 3·6965ms·rows 0isError=false

aggregate3 trials

min 6496ms · median 6673ms · max 6878ms · rows 1,1,1

permission volume

Command

SELECT COUNT(*) AS n, COUNT(DISTINCT project_id) AS projects FROM opencode.permissions

Trials + output

trial 1·6878ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "projects": "0"
}

columns (2)

nprojects

trial 2·6673ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "projects": "0"
}

columns (2)

nprojects

trial 3·6496ms·rows 1isError=false

First row (click to expand JSON)

{
  "n": "0",
  "projects": "0"
}

columns (2)

nprojects

edge3 trials

min 6512ms · median 6539ms · max 6543ms · rows 0,0,0

edge: larger limit

Command

SELECT id, project_id, action, resource FROM opencode.permissions LIMIT 200

Trials + output

trial 1·6539ms·rows 0isError=false

trial 2·6512ms·rows 0isError=false

trial 3·6543ms·rows 0isError=false

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	7067ms	0	ok	—
minimal	t2	8589ms	0	ok	—
minimal	t3	7622ms	0	ok	—
by-project	t1	8068ms	0	ok	—
by-project	t2	6615ms	0	ok	—
by-project	t3	7561ms	0	ok	—
group-by	t1	8049ms	0	ok	—
group-by	t2	7040ms	0	ok	—
group-by	t3	6965ms	0	ok	—
aggregate	t1	6878ms	1	ok	n, projects
aggregate	t2	6673ms	1	ok	n, projects
aggregate	t3	6496ms	1	ok	n, projects
edge	t1	6539ms	0	ok	—
edge	t2	6512ms	0	ok	—
edge	t3	6543ms	0	ok	—

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-09-01T12:18:37Z

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

first_run_at: 2026-09-01T12:18:37Z

last_retried_at: 2026-09-01T12:18:37Z

retry_count: 1

View version history →