github source

github.commit_activity

pass

Get the last year of commit activity

Requires owner and repo. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.

owner, repo captured 2026-08-31 05:48:40Zmedian 27100 ms
Verdict: TRUE

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

rendering…

Summary

VariantTrialsMinMedianMaxRow countsErrors
minimal230023 ms31535 ms33047 ms[1, 1]0
realistic226080 ms27100 ms28121 ms[25, 25]0
edge228460 ms28826 ms29193 ms[52, 52]0

Latency per trial

minimalmedian 31535ms
t130023mst233047ms
scale: 0–33047 ms
realisticmedian 27100ms
t126080mst228121ms
scale: 0–28121 ms
edgemedian 28826ms
t128460mst229193ms
scale: 0–29193 ms

Probe variants — every command + output

minimal2 trials
min 30023ms · median 31535ms · max 33047ms · rows 1,1

smallest valid query

Command
SELECT * FROM github.commit_activity WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 1
Trials + output
trial 1·30023ms·rows 1isError=false
First row (click to expand JSON)
{
  "days": "[6,5,11,14,16,21,12]",
  "owner": "anomalyco",
  "repo": "opencode",
  "total": "85",
  "week": "1757203200"
}
columns (5)
daysownerrepototalweek
trial 2·33047ms·rows 1isError=false
First row (click to expand JSON)
{
  "days": "[6,5,11,14,16,21,12]",
  "owner": "anomalyco",
  "repo": "opencode",
  "total": "85",
  "week": "1757203200"
}
columns (5)
daysownerrepototalweek
realistic2 trials
min 26080ms · median 27100ms · max 28121ms · rows 25,25

typical user query

Command
SELECT * FROM github.commit_activity WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 25
Trials + output
trial 1·26080ms·rows 25isError=false
First row (click to expand JSON)
{
  "days": "[6,5,11,14,16,21,12]",
  "owner": "anomalyco",
  "repo": "opencode",
  "total": "85",
  "week": "1757203200"
}
columns (5)
daysownerrepototalweek
trial 2·28121ms·rows 25isError=false
First row (click to expand JSON)
{
  "days": "[6,5,11,14,16,21,12]",
  "owner": "anomalyco",
  "repo": "opencode",
  "total": "85",
  "week": "1757203200"
}
columns (5)
daysownerrepototalweek
edge2 trials
min 28460ms · median 28826ms · max 29193ms · rows 52,52

edge: larger limit

Command
SELECT * FROM github.commit_activity WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 200
Trials + output
trial 1·28460ms·rows 52isError=false
First row (click to expand JSON)
{
  "days": "[6,5,11,14,16,21,12]",
  "owner": "anomalyco",
  "repo": "opencode",
  "total": "85",
  "week": "1757203200"
}
columns (5)
daysownerrepototalweek
trial 2·29193ms·rows 52isError=false
First row (click to expand JSON)
{
  "days": "[6,5,11,14,16,21,12]",
  "owner": "anomalyco",
  "repo": "opencode",
  "total": "85",
  "week": "1757203200"
}
columns (5)
daysownerrepototalweek

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

156 rows stored · 156 returned · page 1/7
10[6,5,11,14,16,21,12]anomalycoopencode851757203200
21[6,5,11,14,16,21,12]anomalycoopencode851757203200
12[6,5,11,14,16,21,12]anomalycoopencode851757203200
13[8,23,24,14,12,25,6]anomalycoopencode1121757808000
14[4,15,20,10,5,18,24]anomalycoopencode961758412800
15[3,12,3,23,45,13,6]anomalycoopencode1051759017600
16[8,12,7,6,14,8,3]anomalycoopencode581759622400
17[12,10,35,16,22,12,7]anomalycoopencode1141760227200
18[4,13,18,21,22,37,9]anomalycoopencode1241760832000
19[11,23,37,24,52,62,24]anomalycoopencode2331761436800
110[24,42,49,38,39,52,21]anomalycoopencode2651762041600
111[26,36,60,23,21,19,11]anomalycoopencode1961762646400
112[22,38,49,39,43,53,58]anomalycoopencode3021763251200
113[44,47,77,44,24,36,21]anomalycoopencode2931763856000
114[9,42,42,32,46,47,41]anomalycoopencode2591764460800
115[49,83,177,96,113,72,33]anomalycoopencode6231765065600
116[45,109,79,60,68,56,47]anomalycoopencode4641765670400
117[38,83,56,51,18,46,16]anomalycoopencode3081766275200
118[36,83,69,62,53,36,29]anomalycoopencode3681766880000
119[67,52,59,80,53,46,26]anomalycoopencode3831767484800
120[20,59,112,54,109,107,45]anomalycoopencode5061768089600
121[45,80,140,110,93,50,122]anomalycoopencode6401768694400
122[63,102,80,43,98,99,38]anomalycoopencode5231769299200
123[52,78,45,43,58,66,23]anomalycoopencode3651769904000
124[18,57,61,52,68,30,26]anomalycoopencode3121770508800

Column profile

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

#ColumnInferred typeNon-nullNullsSample value(s)
1daysstring60"[6,5,11,14,16,21,12]"
2ownerstring60"anomalyco"
3repostring60"opencode"
4totalstring60"85"
5weekstring60"1757203200"

Trial comparison

Variant / comboTrial #LatencyRowsStatusFirst key returned
minimalt130023ms1okdays, owner, repo
minimalt233047ms1okdays, owner, repo
realistict126080ms25okdays, owner, repo
realistict228121ms25okdays, owner, repo
edget128460ms52okdays, owner, repo
edget229193ms52okdays, owner, repo

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)
Requires owner and repo. Keep queries repository-scoped; fan out across repos client-side when you need broader coverage.
Columns coral returned (5)
daysownerrepototalweek
Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T05:48:40Z
JSON record: reports/github/tables/commit_activity.json
first_run_at: 2026-08-31T05:48:40Z
last_retried_at: 2026-08-31T05:48:40Z
retry_count: 0
View version history →