C
github source

github.caches

pass

List GitHub Actions caches for a repository

Requires owner and repo. Most useful optional filters: ref, sort, key. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

owner, repo captured 2026-08-31 05:40:32Zmedian 26694 ms
Verdict: TRUE

All variants returned rows on ≥2 trials, 0 errors.

rendering…

Summary

VariantTrialsMinMedianMaxRow countsErrors
minimal223514 ms27495 ms31477 ms[1, 1]0
realistic225451 ms26694 ms27937 ms[12, 12]0
edge224858 ms25371 ms25885 ms[12, 12]0

Latency per trial

minimalmedian 27495ms
t131477mst223514ms
scale: 0–31477 ms
realisticmedian 26694ms
t125451mst227937ms
scale: 0–27937 ms
edgemedian 25371ms
t125885mst224858ms
scale: 0–25885 ms

Probe variants — every command + output

minimal2 trials
min 23514ms · median 27495ms · max 31477ms · rows 1,1

smallest valid query

Command
SELECT * FROM github.caches WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 1
Trials + output
trial 1·31477ms·rows 1isError=false
First row (click to expand JSON)
{
  "created_at": "2026-08-31T01:33:40.290493000Z",
  "direction": "",
  "id": "7146616401",
  "key": "macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b0",
  "last_accessed_at": "2026-08-31T05:23:58.974345000Z",
  "owner": "anomalyco",
  "ref": "refs/heads/v2",
  "repo": "opencode",
  "size_in_bytes": "979294580",
  "sort": "",
  "version": "fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e"
}
columns (11)
created_atdirectionidkeylast_accessed_atownerrefreposize_in_bytessortversion
trial 2·23514ms·rows 1isError=false
First row (click to expand JSON)
{
  "created_at": "2026-08-31T01:33:40.290493000Z",
  "direction": "",
  "id": "7146616401",
  "key": "macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b0",
  "last_accessed_at": "2026-08-31T05:23:58.974345000Z",
  "owner": "anomalyco",
  "ref": "refs/heads/v2",
  "repo": "opencode",
  "size_in_bytes": "979294580",
  "sort": "",
  "version": "fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e"
}
columns (11)
created_atdirectionidkeylast_accessed_atownerrefreposize_in_bytessortversion
realistic2 trials
min 25451ms · median 26694ms · max 27937ms · rows 12,12

typical user query

Command
SELECT * FROM github.caches WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 25
Trials + output
trial 1·25451ms·rows 12isError=false
First row (click to expand JSON)
{
  "created_at": "2026-08-31T01:33:40.290493000Z",
  "direction": "",
  "id": "7146616401",
  "key": "macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b0",
  "last_accessed_at": "2026-08-31T05:23:58.974345000Z",
  "owner": "anomalyco",
  "ref": "refs/heads/v2",
  "repo": "opencode",
  "size_in_bytes": "979294580",
  "sort": "",
  "version": "fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e"
}
columns (11)
created_atdirectionidkeylast_accessed_atownerrefreposize_in_bytessortversion
trial 2·27937ms·rows 12isError=false
First row (click to expand JSON)
{
  "created_at": "2026-08-31T01:33:40.290493000Z",
  "direction": "",
  "id": "7146616401",
  "key": "macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b0",
  "last_accessed_at": "2026-08-31T05:23:58.974345000Z",
  "owner": "anomalyco",
  "ref": "refs/heads/v2",
  "repo": "opencode",
  "size_in_bytes": "979294580",
  "sort": "",
  "version": "fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e"
}
columns (11)
created_atdirectionidkeylast_accessed_atownerrefreposize_in_bytessortversion
edge2 trials
min 24858ms · median 25371ms · max 25885ms · rows 12,12

edge: larger limit

Command
SELECT * FROM github.caches WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 200
Trials + output
trial 1·25885ms·rows 12isError=false
First row (click to expand JSON)
{
  "created_at": "2026-08-31T01:33:40.290493000Z",
  "direction": "",
  "id": "7146616401",
  "key": "macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b0",
  "last_accessed_at": "2026-08-31T05:23:58.974345000Z",
  "owner": "anomalyco",
  "ref": "refs/heads/v2",
  "repo": "opencode",
  "size_in_bytes": "979294580",
  "sort": "",
  "version": "fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e"
}
columns (11)
created_atdirectionidkeylast_accessed_atownerrefreposize_in_bytessortversion
trial 2·24858ms·rows 12isError=false
First row (click to expand JSON)
{
  "created_at": "2026-08-31T01:33:40.290493000Z",
  "direction": "",
  "id": "7146616401",
  "key": "macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b0",
  "last_accessed_at": "2026-08-31T05:23:58.974345000Z",
  "owner": "anomalyco",
  "ref": "refs/heads/v2",
  "repo": "opencode",
  "size_in_bytes": "979294580",
  "sort": "",
  "version": "fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e"
}
columns (11)
created_atdirectionidkeylast_accessed_atownerrefreposize_in_bytessortversion

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

50 rows stored · 50 returned · page 1/2
102026-08-31T01:33:40.290493000Z—7146616401macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b02026-08-31T05:23:58.974345000Zanomalycorefs/heads/v2opencode979294580—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
212026-08-31T01:33:40.290493000Z—7146616401macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b02026-08-31T05:23:58.974345000Zanomalycorefs/heads/v2opencode979294580—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
122026-08-31T01:33:40.290493000Z—7146616401macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b02026-08-31T05:23:58.974345000Zanomalycorefs/heads/v2opencode979294580—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
132026-07-06T20:26:37.147964000Z—5531616325bun-kSmiCOujAb+jFWQqTDn70+CxniQ=2026-08-31T05:23:55.906072000Zanomalycorefs/heads/devopencode21289718—0c867ee6264758fbca938e6c6d38a3160cb478f2770da2f831e22e4c9e3720d8
142026-08-31T05:23:36.242085000Z—7150644796macOS-bun-384af55829cc4c4736c6a516c9a8b19b3e37841bd929bb6492c23caaa80abeb52026-08-31T05:23:36.242085000Zanomalycorefs/heads/devopencode667284520—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
152026-08-29T02:29:22.812693000Z—7109842868Windows-bun-ed5853cbd4205e6a9881639f496be9b6d7791a52878243a89365b6db2da1a2212026-08-31T05:21:29.579067000Zanomalycorefs/heads/devopencode654193947—c1934ffe7fbec7525f9a36023230d0959f240a6057761100bf8119177a92cadb
162026-08-29T02:23:26.573469000Z—7109768195Linux-bun-384af55829cc4c4736c6a516c9a8b19b3e37841bd929bb6492c23caaa80abeb52026-08-31T05:20:08.642152000Zanomalycorefs/heads/devopencode701057284—dead6d71ab58481c5c3265498d091fe6e206ac57e80acc2352ca0c9c2b13b353
172026-08-31T01:29:49.176178000Z—7146555540Linux-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b02026-08-31T05:08:44.543563000Zanomalycorefs/heads/v2opencode1622058631—dead6d71ab58481c5c3265498d091fe6e206ac57e80acc2352ca0c9c2b13b353
182026-08-30T03:37:36.516808000Z—7128858424macOS-bun-22e32bd7ebb598de4793fb0003e7f848485f85ae9cc94549fd7107ee07a1b4bd2026-08-31T01:31:04.396219000Zanomalycorefs/heads/v2opencode978681305—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
192026-08-30T03:30:57.404046000Z—7128790871Linux-bun-22e32bd7ebb598de4793fb0003e7f848485f85ae9cc94549fd7107ee07a1b4bd2026-08-31T01:28:34.182138000Zanomalycorefs/heads/v2opencode1622081623—dead6d71ab58481c5c3265498d091fe6e206ac57e80acc2352ca0c9c2b13b353
1102026-08-31T01:02:13.176772000Z—7146095603Windows-bun-5803b6fc9a98971b1650da9952353140637411ffb367982a1fa029d461e86bed2026-08-31T01:02:13.176772000Zanomalycorefs/heads/betaopencode932434722—c1934ffe7fbec7525f9a36023230d0959f240a6057761100bf8119177a92cadb
1112026-08-31T00:48:48.267911000Z—7145894681macOS-bun-22e32bd7ebb598de4793fb0003e7f848485f85ae9cc94549fd7107ee07a1b4bd2026-08-31T00:50:45.823984000Zanomalycorefs/heads/betaopencode950669821—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
1122026-08-28T17:38:57.372313000Z—7099071416macOS-bun-33735842b08ebbdb933ca3434420b981a36d3dc76c20d3a915e8ecf32151169e2026-08-31T00:46:30.008135000Zanomalycorefs/heads/betaopencode950993870—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
1132026-08-31T00:45:09.688528000Z—7145839355Linux-bun-22e32bd7ebb598de4793fb0003e7f848485f85ae9cc94549fd7107ee07a1b4bd2026-08-31T00:45:09.688528000Zanomalycorefs/heads/betaopencode1061169366—dead6d71ab58481c5c3265498d091fe6e206ac57e80acc2352ca0c9c2b13b353
2142026-08-31T01:33:40.290493000Z—7146616401macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b02026-08-31T05:23:58.974345000Zanomalycorefs/heads/v2opencode979294580—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
2152026-07-06T20:26:37.147964000Z—5531616325bun-kSmiCOujAb+jFWQqTDn70+CxniQ=2026-08-31T05:23:55.906072000Zanomalycorefs/heads/devopencode21289718—0c867ee6264758fbca938e6c6d38a3160cb478f2770da2f831e22e4c9e3720d8
2162026-08-31T05:23:36.242085000Z—7150644796macOS-bun-384af55829cc4c4736c6a516c9a8b19b3e37841bd929bb6492c23caaa80abeb52026-08-31T05:23:36.242085000Zanomalycorefs/heads/devopencode667284520—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
2172026-08-29T02:29:22.812693000Z—7109842868Windows-bun-ed5853cbd4205e6a9881639f496be9b6d7791a52878243a89365b6db2da1a2212026-08-31T05:21:29.579067000Zanomalycorefs/heads/devopencode654193947—c1934ffe7fbec7525f9a36023230d0959f240a6057761100bf8119177a92cadb
2182026-08-29T02:23:26.573469000Z—7109768195Linux-bun-384af55829cc4c4736c6a516c9a8b19b3e37841bd929bb6492c23caaa80abeb52026-08-31T05:20:08.642152000Zanomalycorefs/heads/devopencode701057284—dead6d71ab58481c5c3265498d091fe6e206ac57e80acc2352ca0c9c2b13b353
2192026-08-31T01:29:49.176178000Z—7146555540Linux-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb08b4808ec5072b02026-08-31T05:08:44.543563000Zanomalycorefs/heads/v2opencode1622058631—dead6d71ab58481c5c3265498d091fe6e206ac57e80acc2352ca0c9c2b13b353
2202026-08-30T03:37:36.516808000Z—7128858424macOS-bun-22e32bd7ebb598de4793fb0003e7f848485f85ae9cc94549fd7107ee07a1b4bd2026-08-31T01:31:04.396219000Zanomalycorefs/heads/v2opencode978681305—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
2212026-08-30T03:30:57.404046000Z—7128790871Linux-bun-22e32bd7ebb598de4793fb0003e7f848485f85ae9cc94549fd7107ee07a1b4bd2026-08-31T01:28:34.182138000Zanomalycorefs/heads/v2opencode1622081623—dead6d71ab58481c5c3265498d091fe6e206ac57e80acc2352ca0c9c2b13b353
2222026-08-31T01:02:13.176772000Z—7146095603Windows-bun-5803b6fc9a98971b1650da9952353140637411ffb367982a1fa029d461e86bed2026-08-31T01:02:13.176772000Zanomalycorefs/heads/betaopencode932434722—c1934ffe7fbec7525f9a36023230d0959f240a6057761100bf8119177a92cadb
2232026-08-31T00:48:48.267911000Z—7145894681macOS-bun-22e32bd7ebb598de4793fb0003e7f848485f85ae9cc94549fd7107ee07a1b4bd2026-08-31T00:50:45.823984000Zanomalycorefs/heads/betaopencode950669821—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e
2242026-08-28T17:38:57.372313000Z—7099071416macOS-bun-33735842b08ebbdb933ca3434420b981a36d3dc76c20d3a915e8ecf32151169e2026-08-31T00:46:30.008135000Zanomalycorefs/heads/betaopencode950993870—fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef015824b1e

Column profile

11 columns actually returned by coral. Catalog claims "2 required filter(s)": "owner, repo". Click a column to drill in.

#ColumnInferred typeNon-nullNullsSample value(s)
1created_atstring60"2026-08-31T01:33:40.290493000Z"
2direction—06empty
3idstring60"7146616401"
4keystring60"macOS-bun-b1b00664bb7fa51f9152600cb3d834c65780f3327efe714fb0"
5last_accessed_atstring60"2026-08-31T05:23:58.974345000Z"
6ownerstring60"anomalyco"
7refstring60"refs/heads/v2"
8repostring60"opencode"
9size_in_bytesstring60"979294580"
10sort—06empty
11versionstring60"fc272f43d53fe7b88198e8c3d9a1de73cf2a31da81e768581faddef01582"

Trial comparison

Variant / comboTrial #LatencyRowsStatusFirst key returned
minimalt131477ms1okcreated_at, direction, id
minimalt223514ms1okcreated_at, direction, id
realistict125451ms12okcreated_at, direction, id
realistict227937ms12okcreated_at, direction, id
edget125885ms12okcreated_at, direction, id
edget224858ms12okcreated_at, direction, id

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)
Requires owner and repo. Most useful optional filters: ref, sort, key. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.
Columns coral returned (11)
created_atdirectionidkeylast_accessed_atownerrefreposize_in_bytessortversion
Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T05:40:32Z
JSON record: reports/github/tables/caches.json
first_run_at: 2026-08-31T05:40:32Z
last_retried_at: 2026-08-31T05:40:32Z
retry_count: 0
View version history →