`github.punch_card`

pass

Get the hourly commit count for each day

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 07:47:26Zmedian 37872 ms

Verdict: TRUE

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

rendering…

Summary

Variant	Trials	Min	Median	Max	Row counts
minimal	2	32798 ms	33048 ms	33298 ms	[1, 1]
realistic	2	36170 ms	37872 ms	39574 ms	[25, 25]
edge	2	27589 ms	33880 ms	40171 ms	[168, 168]

Latency per trial

minimalmedian 33048ms

scale: 0–33298 ms

realisticmedian 37872ms

scale: 0–39574 ms

edgemedian 33880ms

scale: 0–40171 ms

Probe variants — every command + output

minimal2 trials

min 32798ms · median 33048ms · max 33298ms · rows 1,1

smallest valid query

Command

SELECT * FROM github.punch_card WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 1

Trials + output

trial 1·32798ms·rows 1isError=false

First row (click to expand JSON)

{
  "json": "[0,0,75]",
  "owner": "anomalyco",
  "repo": "opencode"
}

columns (3)

jsonownerrepo

trial 2·33298ms·rows 1isError=false

First row (click to expand JSON)

{
  "json": "[0,0,75]",
  "owner": "anomalyco",
  "repo": "opencode"
}

columns (3)

jsonownerrepo

realistic2 trials

min 36170ms · median 37872ms · max 39574ms · rows 25,25

typical user query

Command

SELECT * FROM github.punch_card WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 25

Trials + output

trial 1·36170ms·rows 25isError=false

First row (click to expand JSON)

{
  "json": "[0,0,75]",
  "owner": "anomalyco",
  "repo": "opencode"
}

columns (3)

jsonownerrepo

trial 2·39574ms·rows 25isError=false

First row (click to expand JSON)

{
  "json": "[0,0,75]",
  "owner": "anomalyco",
  "repo": "opencode"
}

columns (3)

jsonownerrepo

edge2 trials

min 27589ms · median 33880ms · max 40171ms · rows 168,168

edge: larger limit

Command

SELECT * FROM github.punch_card WHERE owner = 'anomalyco' AND repo = 'opencode' LIMIT 200

Trials + output

trial 1·40171ms·rows 168isError=false

First row (click to expand JSON)

{
  "json": "[0,0,75]",
  "owner": "anomalyco",
  "repo": "opencode"
}

columns (3)

jsonownerrepo

trial 2·27589ms·rows 168isError=false

First row (click to expand JSON)

{
  "json": "[0,0,75]",
  "owner": "anomalyco",
  "repo": "opencode"
}

columns (3)

jsonownerrepo

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

388 rows stored · 388 returned · page 1/16


1	0	[0,0,75]	anomalyco	opencode
2	1	[0,0,75]	anomalyco	opencode
1	2	[0,0,75]	anomalyco	opencode
1	3	[0,1,73]	anomalyco	opencode
1	4	[0,2,38]	anomalyco	opencode
1	5	[0,3,41]	anomalyco	opencode
1	6	[0,4,29]	anomalyco	opencode
1	7	[0,5,47]	anomalyco	opencode
1	8	[0,6,36]	anomalyco	opencode
1	9	[0,7,25]	anomalyco	opencode
1	10	[0,8,18]	anomalyco	opencode
1	11	[0,9,24]	anomalyco	opencode
1	12	[0,10,36]	anomalyco	opencode
1	13	[0,11,52]	anomalyco	opencode
1	14	[0,12,112]	anomalyco	opencode
1	15	[0,13,80]	anomalyco	opencode
1	16	[0,14,67]	anomalyco	opencode
1	17	[0,15,60]	anomalyco	opencode
1	18	[0,16,43]	anomalyco	opencode
1	19	[0,17,56]	anomalyco	opencode
1	20	[0,18,45]	anomalyco	opencode
1	21	[0,19,93]	anomalyco	opencode
1	22	[0,20,70]	anomalyco	opencode
1	23	[0,21,78]	anomalyco	opencode
1	24	[0,22,52]	anomalyco	opencode

Column profile

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

#	Column	Inferred type	Non-null	Sample value(s)
1	json	string	6	`"[0,0,75]"`
2	owner	string	6	`"anomalyco"`
3	repo	string	6	`"opencode"`

Trial comparison

Variant / combo	Trial #	Latency	Rows	Status	First key returned
minimal	t1	32798ms	1	ok	json, owner, repo
minimal	t2	33298ms	1	ok	json, owner, repo
realistic	t1	36170ms	25	ok	json, owner, repo
realistic	t2	39574ms	25	ok	json, owner, repo
edge	t1	40171ms	168	ok	json, owner, repo
edge	t2	27589ms	168	ok	json, 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 (3)

jsonownerrepo

Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T07:47:26Z

JSON record: reports/github/tables/punch_card.json

first_run_at: 2026-08-31T07:47:26Z

last_retried_at: 2026-08-31T07:47:26Z

retry_count: 0

View version history →