C
github source

github.gist_commits

pass

List gist commits

Requires gist_id. Use LIMIT for spot checks; large result sets paginate quickly.

gist_id captured 2026-08-31 06:10:50Zmedian 30504 ms
Verdict: TRUE

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

rendering…

Summary

VariantTrialsMinMedianMaxRow countsErrors
minimal225263 ms25958 ms26653 ms[1, 1]0
realistic228577 ms30504 ms32432 ms[4, 4]0
edge227633 ms28253 ms28874 ms[4, 4]0

Latency per trial

minimalmedian 25958ms
t126653mst225263ms
scale: 0–26653 ms
realisticmedian 30504ms
t128577mst232432ms
scale: 0–32432 ms
edgemedian 28253ms
t128874mst227633ms
scale: 0–28874 ms

Probe variants — every command + output

minimal2 trials
min 25263ms · median 25958ms · max 26653ms · rows 1,1

smallest valid query

Command
SELECT * FROM github.gist_commits WHERE gist_id = '1' LIMIT 1
Trials + output
trial 1·26653ms·rows 1isError=false
First row (click to expand JSON)
{
  "change_status": "{\"total\":7,\"additions\":6,\"deletions\":1}",
  "change_status__additions": "6",
  "change_status__deletions": "1",
  "change_status__total": "7",
  "committed_at": "2011-02-22T02:58:22Z",
  "gist_id": "1",
  "url": "https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9",
  "user": "{\"login\":\"schacon\",\"id\":70,\"node_id\":\"MDQ6VXNlcjcw\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/70?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/schacon\",\"html_url\":\"https://github.com/schacon\",\"followers_url\":\"https://api.github.com/users/schacon/followers\",\"following_url\":\"https://api.github.com/users/schacon/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/schacon/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/schacon/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/schacon/subscriptions\",\"organizations_url\":\"https://api.github.com/users/schacon/orgs\",\"repos_url\":\"https://api.github.com/users/schacon/repos\",\"events_url\":\"https://api.github.com/users/schacon/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/schacon/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "user__avatar_url": "https://avatars.githubusercontent.com/u/70?v=4",
  "user__email": "",
  "user__events_url": "https://api.github.com/users/schacon/events{/privacy}",
  "user__followers_url": "https://api.github.com/users/schacon/followers",
  "user__following_url": "https://api.github.com/users/schacon/following{/other_user}",
  "user__gists_url": "https://api.github.com/users/schacon/gists{/gist_id}",
  "user__gravatar_id": "",
  "user__html_url": "https://github.com/schacon",
  "user__id": "70",
  "user__login": "schacon",
  "user__name": "",
  "user__node_id": "MDQ6VXNlcjcw",
  "user__organizations_url": "https://api.github.com/users/schacon/orgs",
  "user__received_events_url": "https://api.github.com/users/schacon/received_events",
  "user__repos_url": "https://api.github.com/users/schacon/repos",
  "user__site_admin": "false",
  "user__starred_at": "",
  "user__starred_url": "https://api.github.com/users/schacon/starred{/owner}{/repo}",
  "user__subscriptions_url": "https://api.github.com/users/schacon/subscriptions",
  "user__type": "User",
  "user__url": "https://api.github.com/users/schacon",
  "user__user_view_type": "public",
  "version": "3a641566d0a49014cea6f395e8be68c42b9e46d9"
}
columns (31)
change_statuschange_status__additionschange_status__deletionschange_status__totalcommitted_atgist_idurluseruser__avatar_urluser__emailuser__events_urluser__followers_urluser__following_urluser__gists_urluser__gravatar_iduser__html_urluser__iduser__loginuser__nameuser__node_iduser__organizations_urluser__received_events_urluser__repos_urluser__site_adminuser__starred_atuser__starred_urluser__subscriptions_urluser__typeuser__urluser__user_view_typeversion
trial 2·25263ms·rows 1isError=false
First row (click to expand JSON)
{
  "change_status": "{\"total\":7,\"additions\":6,\"deletions\":1}",
  "change_status__additions": "6",
  "change_status__deletions": "1",
  "change_status__total": "7",
  "committed_at": "2011-02-22T02:58:22Z",
  "gist_id": "1",
  "url": "https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9",
  "user": "{\"login\":\"schacon\",\"id\":70,\"node_id\":\"MDQ6VXNlcjcw\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/70?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/schacon\",\"html_url\":\"https://github.com/schacon\",\"followers_url\":\"https://api.github.com/users/schacon/followers\",\"following_url\":\"https://api.github.com/users/schacon/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/schacon/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/schacon/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/schacon/subscriptions\",\"organizations_url\":\"https://api.github.com/users/schacon/orgs\",\"repos_url\":\"https://api.github.com/users/schacon/repos\",\"events_url\":\"https://api.github.com/users/schacon/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/schacon/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "user__avatar_url": "https://avatars.githubusercontent.com/u/70?v=4",
  "user__email": "",
  "user__events_url": "https://api.github.com/users/schacon/events{/privacy}",
  "user__followers_url": "https://api.github.com/users/schacon/followers",
  "user__following_url": "https://api.github.com/users/schacon/following{/other_user}",
  "user__gists_url": "https://api.github.com/users/schacon/gists{/gist_id}",
  "user__gravatar_id": "",
  "user__html_url": "https://github.com/schacon",
  "user__id": "70",
  "user__login": "schacon",
  "user__name": "",
  "user__node_id": "MDQ6VXNlcjcw",
  "user__organizations_url": "https://api.github.com/users/schacon/orgs",
  "user__received_events_url": "https://api.github.com/users/schacon/received_events",
  "user__repos_url": "https://api.github.com/users/schacon/repos",
  "user__site_admin": "false",
  "user__starred_at": "",
  "user__starred_url": "https://api.github.com/users/schacon/starred{/owner}{/repo}",
  "user__subscriptions_url": "https://api.github.com/users/schacon/subscriptions",
  "user__type": "User",
  "user__url": "https://api.github.com/users/schacon",
  "user__user_view_type": "public",
  "version": "3a641566d0a49014cea6f395e8be68c42b9e46d9"
}
columns (31)
change_statuschange_status__additionschange_status__deletionschange_status__totalcommitted_atgist_idurluseruser__avatar_urluser__emailuser__events_urluser__followers_urluser__following_urluser__gists_urluser__gravatar_iduser__html_urluser__iduser__loginuser__nameuser__node_iduser__organizations_urluser__received_events_urluser__repos_urluser__site_adminuser__starred_atuser__starred_urluser__subscriptions_urluser__typeuser__urluser__user_view_typeversion
realistic2 trials
min 28577ms · median 30504ms · max 32432ms · rows 4,4

typical user query

Command
SELECT * FROM github.gist_commits WHERE gist_id = '1' LIMIT 25
Trials + output
trial 1·28577ms·rows 4isError=false
First row (click to expand JSON)
{
  "change_status": "{\"total\":7,\"additions\":6,\"deletions\":1}",
  "change_status__additions": "6",
  "change_status__deletions": "1",
  "change_status__total": "7",
  "committed_at": "2011-02-22T02:58:22Z",
  "gist_id": "1",
  "url": "https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9",
  "user": "{\"login\":\"schacon\",\"id\":70,\"node_id\":\"MDQ6VXNlcjcw\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/70?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/schacon\",\"html_url\":\"https://github.com/schacon\",\"followers_url\":\"https://api.github.com/users/schacon/followers\",\"following_url\":\"https://api.github.com/users/schacon/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/schacon/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/schacon/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/schacon/subscriptions\",\"organizations_url\":\"https://api.github.com/users/schacon/orgs\",\"repos_url\":\"https://api.github.com/users/schacon/repos\",\"events_url\":\"https://api.github.com/users/schacon/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/schacon/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "user__avatar_url": "https://avatars.githubusercontent.com/u/70?v=4",
  "user__email": "",
  "user__events_url": "https://api.github.com/users/schacon/events{/privacy}",
  "user__followers_url": "https://api.github.com/users/schacon/followers",
  "user__following_url": "https://api.github.com/users/schacon/following{/other_user}",
  "user__gists_url": "https://api.github.com/users/schacon/gists{/gist_id}",
  "user__gravatar_id": "",
  "user__html_url": "https://github.com/schacon",
  "user__id": "70",
  "user__login": "schacon",
  "user__name": "",
  "user__node_id": "MDQ6VXNlcjcw",
  "user__organizations_url": "https://api.github.com/users/schacon/orgs",
  "user__received_events_url": "https://api.github.com/users/schacon/received_events",
  "user__repos_url": "https://api.github.com/users/schacon/repos",
  "user__site_admin": "false",
  "user__starred_at": "",
  "user__starred_url": "https://api.github.com/users/schacon/starred{/owner}{/repo}",
  "user__subscriptions_url": "https://api.github.com/users/schacon/subscriptions",
  "user__type": "User",
  "user__url": "https://api.github.com/users/schacon",
  "user__user_view_type": "public",
  "version": "3a641566d0a49014cea6f395e8be68c42b9e46d9"
}
columns (31)
change_statuschange_status__additionschange_status__deletionschange_status__totalcommitted_atgist_idurluseruser__avatar_urluser__emailuser__events_urluser__followers_urluser__following_urluser__gists_urluser__gravatar_iduser__html_urluser__iduser__loginuser__nameuser__node_iduser__organizations_urluser__received_events_urluser__repos_urluser__site_adminuser__starred_atuser__starred_urluser__subscriptions_urluser__typeuser__urluser__user_view_typeversion
trial 2·32432ms·rows 4isError=false
First row (click to expand JSON)
{
  "change_status": "{\"total\":7,\"additions\":6,\"deletions\":1}",
  "change_status__additions": "6",
  "change_status__deletions": "1",
  "change_status__total": "7",
  "committed_at": "2011-02-22T02:58:22Z",
  "gist_id": "1",
  "url": "https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9",
  "user": "{\"login\":\"schacon\",\"id\":70,\"node_id\":\"MDQ6VXNlcjcw\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/70?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/schacon\",\"html_url\":\"https://github.com/schacon\",\"followers_url\":\"https://api.github.com/users/schacon/followers\",\"following_url\":\"https://api.github.com/users/schacon/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/schacon/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/schacon/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/schacon/subscriptions\",\"organizations_url\":\"https://api.github.com/users/schacon/orgs\",\"repos_url\":\"https://api.github.com/users/schacon/repos\",\"events_url\":\"https://api.github.com/users/schacon/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/schacon/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "user__avatar_url": "https://avatars.githubusercontent.com/u/70?v=4",
  "user__email": "",
  "user__events_url": "https://api.github.com/users/schacon/events{/privacy}",
  "user__followers_url": "https://api.github.com/users/schacon/followers",
  "user__following_url": "https://api.github.com/users/schacon/following{/other_user}",
  "user__gists_url": "https://api.github.com/users/schacon/gists{/gist_id}",
  "user__gravatar_id": "",
  "user__html_url": "https://github.com/schacon",
  "user__id": "70",
  "user__login": "schacon",
  "user__name": "",
  "user__node_id": "MDQ6VXNlcjcw",
  "user__organizations_url": "https://api.github.com/users/schacon/orgs",
  "user__received_events_url": "https://api.github.com/users/schacon/received_events",
  "user__repos_url": "https://api.github.com/users/schacon/repos",
  "user__site_admin": "false",
  "user__starred_at": "",
  "user__starred_url": "https://api.github.com/users/schacon/starred{/owner}{/repo}",
  "user__subscriptions_url": "https://api.github.com/users/schacon/subscriptions",
  "user__type": "User",
  "user__url": "https://api.github.com/users/schacon",
  "user__user_view_type": "public",
  "version": "3a641566d0a49014cea6f395e8be68c42b9e46d9"
}
columns (31)
change_statuschange_status__additionschange_status__deletionschange_status__totalcommitted_atgist_idurluseruser__avatar_urluser__emailuser__events_urluser__followers_urluser__following_urluser__gists_urluser__gravatar_iduser__html_urluser__iduser__loginuser__nameuser__node_iduser__organizations_urluser__received_events_urluser__repos_urluser__site_adminuser__starred_atuser__starred_urluser__subscriptions_urluser__typeuser__urluser__user_view_typeversion
edge2 trials
min 27633ms · median 28253ms · max 28874ms · rows 4,4

edge: larger limit

Command
SELECT * FROM github.gist_commits WHERE gist_id = '1' LIMIT 200
Trials + output
trial 1·28874ms·rows 4isError=false
First row (click to expand JSON)
{
  "change_status": "{\"total\":7,\"additions\":6,\"deletions\":1}",
  "change_status__additions": "6",
  "change_status__deletions": "1",
  "change_status__total": "7",
  "committed_at": "2011-02-22T02:58:22Z",
  "gist_id": "1",
  "url": "https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9",
  "user": "{\"login\":\"schacon\",\"id\":70,\"node_id\":\"MDQ6VXNlcjcw\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/70?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/schacon\",\"html_url\":\"https://github.com/schacon\",\"followers_url\":\"https://api.github.com/users/schacon/followers\",\"following_url\":\"https://api.github.com/users/schacon/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/schacon/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/schacon/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/schacon/subscriptions\",\"organizations_url\":\"https://api.github.com/users/schacon/orgs\",\"repos_url\":\"https://api.github.com/users/schacon/repos\",\"events_url\":\"https://api.github.com/users/schacon/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/schacon/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "user__avatar_url": "https://avatars.githubusercontent.com/u/70?v=4",
  "user__email": "",
  "user__events_url": "https://api.github.com/users/schacon/events{/privacy}",
  "user__followers_url": "https://api.github.com/users/schacon/followers",
  "user__following_url": "https://api.github.com/users/schacon/following{/other_user}",
  "user__gists_url": "https://api.github.com/users/schacon/gists{/gist_id}",
  "user__gravatar_id": "",
  "user__html_url": "https://github.com/schacon",
  "user__id": "70",
  "user__login": "schacon",
  "user__name": "",
  "user__node_id": "MDQ6VXNlcjcw",
  "user__organizations_url": "https://api.github.com/users/schacon/orgs",
  "user__received_events_url": "https://api.github.com/users/schacon/received_events",
  "user__repos_url": "https://api.github.com/users/schacon/repos",
  "user__site_admin": "false",
  "user__starred_at": "",
  "user__starred_url": "https://api.github.com/users/schacon/starred{/owner}{/repo}",
  "user__subscriptions_url": "https://api.github.com/users/schacon/subscriptions",
  "user__type": "User",
  "user__url": "https://api.github.com/users/schacon",
  "user__user_view_type": "public",
  "version": "3a641566d0a49014cea6f395e8be68c42b9e46d9"
}
columns (31)
change_statuschange_status__additionschange_status__deletionschange_status__totalcommitted_atgist_idurluseruser__avatar_urluser__emailuser__events_urluser__followers_urluser__following_urluser__gists_urluser__gravatar_iduser__html_urluser__iduser__loginuser__nameuser__node_iduser__organizations_urluser__received_events_urluser__repos_urluser__site_adminuser__starred_atuser__starred_urluser__subscriptions_urluser__typeuser__urluser__user_view_typeversion
trial 2·27633ms·rows 4isError=false
First row (click to expand JSON)
{
  "change_status": "{\"total\":7,\"additions\":6,\"deletions\":1}",
  "change_status__additions": "6",
  "change_status__deletions": "1",
  "change_status__total": "7",
  "committed_at": "2011-02-22T02:58:22Z",
  "gist_id": "1",
  "url": "https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9",
  "user": "{\"login\":\"schacon\",\"id\":70,\"node_id\":\"MDQ6VXNlcjcw\",\"avatar_url\":\"https://avatars.githubusercontent.com/u/70?v=4\",\"gravatar_id\":\"\",\"url\":\"https://api.github.com/users/schacon\",\"html_url\":\"https://github.com/schacon\",\"followers_url\":\"https://api.github.com/users/schacon/followers\",\"following_url\":\"https://api.github.com/users/schacon/following{/other_user}\",\"gists_url\":\"https://api.github.com/users/schacon/gists{/gist_id}\",\"starred_url\":\"https://api.github.com/users/schacon/starred{/owner}{/repo}\",\"subscriptions_url\":\"https://api.github.com/users/schacon/subscriptions\",\"organizations_url\":\"https://api.github.com/users/schacon/orgs\",\"repos_url\":\"https://api.github.com/users/schacon/repos\",\"events_url\":\"https://api.github.com/users/schacon/events{/privacy}\",\"received_events_url\":\"https://api.github.com/users/schacon/received_events\",\"type\":\"User\",\"user_view_type\":\"public\",\"site_admin\":false}",
  "user__avatar_url": "https://avatars.githubusercontent.com/u/70?v=4",
  "user__email": "",
  "user__events_url": "https://api.github.com/users/schacon/events{/privacy}",
  "user__followers_url": "https://api.github.com/users/schacon/followers",
  "user__following_url": "https://api.github.com/users/schacon/following{/other_user}",
  "user__gists_url": "https://api.github.com/users/schacon/gists{/gist_id}",
  "user__gravatar_id": "",
  "user__html_url": "https://github.com/schacon",
  "user__id": "70",
  "user__login": "schacon",
  "user__name": "",
  "user__node_id": "MDQ6VXNlcjcw",
  "user__organizations_url": "https://api.github.com/users/schacon/orgs",
  "user__received_events_url": "https://api.github.com/users/schacon/received_events",
  "user__repos_url": "https://api.github.com/users/schacon/repos",
  "user__site_admin": "false",
  "user__starred_at": "",
  "user__starred_url": "https://api.github.com/users/schacon/starred{/owner}{/repo}",
  "user__subscriptions_url": "https://api.github.com/users/schacon/subscriptions",
  "user__type": "User",
  "user__url": "https://api.github.com/users/schacon",
  "user__user_view_type": "public",
  "version": "3a641566d0a49014cea6f395e8be68c42b9e46d9"
}
columns (31)
change_statuschange_status__additionschange_status__deletionschange_status__totalcommitted_atgist_idurluseruser__avatar_urluser__emailuser__events_urluser__followers_urluser__following_urluser__gists_urluser__gravatar_iduser__html_urluser__iduser__loginuser__nameuser__node_iduser__organizations_urluser__received_events_urluser__repos_urluser__site_adminuser__starred_atuser__starred_urluser__subscriptions_urluser__typeuser__urluser__user_view_typeversion

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

18 rows stored · 18 returned · page 1/1
10{"total":7,"additions":6,"deletions":1}6172011-02-22T02:58:22Z1https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic3a641566d0a49014cea6f395e8be68c42b9e46d9
21{"total":7,"additions":6,"deletions":1}6172011-02-22T02:58:22Z1https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic3a641566d0a49014cea6f395e8be68c42b9e46d9
12{"total":7,"additions":6,"deletions":1}6172011-02-22T02:58:22Z1https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic3a641566d0a49014cea6f395e8be68c42b9e46d9
13{"total":7,"additions":1,"deletions":6}1672011-02-22T02:53:32Z1https://api.github.com/gists/1/24c894e1ca5cefd36b3b6e914beb93a7068f6efb{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic24c894e1ca5cefd36b3b6e914beb93a7068f6efb
14{"total":7,"additions":6,"deletions":1}6172008-07-15T18:17:27Z1https://api.github.com/gists/1/0864db9cbe551088b2269128c5b5d145141f57ef{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic0864db9cbe551088b2269128c5b5d145141f57ef
15{"total":1,"additions":1,"deletions":0}1012008-07-15T18:17:14Z1https://api.github.com/gists/1/8afc134bf14f8f56ed2e7234128490d9946e8c16{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic8afc134bf14f8f56ed2e7234128490d9946e8c16
26{"total":7,"additions":6,"deletions":1}6172011-02-22T02:58:22Z1https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic3a641566d0a49014cea6f395e8be68c42b9e46d9
27{"total":7,"additions":1,"deletions":6}1672011-02-22T02:53:32Z1https://api.github.com/gists/1/24c894e1ca5cefd36b3b6e914beb93a7068f6efb{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic24c894e1ca5cefd36b3b6e914beb93a7068f6efb
28{"total":7,"additions":6,"deletions":1}6172008-07-15T18:17:27Z1https://api.github.com/gists/1/0864db9cbe551088b2269128c5b5d145141f57ef{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic0864db9cbe551088b2269128c5b5d145141f57ef
29{"total":1,"additions":1,"deletions":0}1012008-07-15T18:17:14Z1https://api.github.com/gists/1/8afc134bf14f8f56ed2e7234128490d9946e8c16{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic8afc134bf14f8f56ed2e7234128490d9946e8c16
110{"total":7,"additions":6,"deletions":1}6172011-02-22T02:58:22Z1https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic3a641566d0a49014cea6f395e8be68c42b9e46d9
111{"total":7,"additions":1,"deletions":6}1672011-02-22T02:53:32Z1https://api.github.com/gists/1/24c894e1ca5cefd36b3b6e914beb93a7068f6efb{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic24c894e1ca5cefd36b3b6e914beb93a7068f6efb
112{"total":7,"additions":6,"deletions":1}6172008-07-15T18:17:27Z1https://api.github.com/gists/1/0864db9cbe551088b2269128c5b5d145141f57ef{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic0864db9cbe551088b2269128c5b5d145141f57ef
113{"total":1,"additions":1,"deletions":0}1012008-07-15T18:17:14Z1https://api.github.com/gists/1/8afc134bf14f8f56ed2e7234128490d9946e8c16{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic8afc134bf14f8f56ed2e7234128490d9946e8c16
214{"total":7,"additions":6,"deletions":1}6172011-02-22T02:58:22Z1https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be68c42b9e46d9{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic3a641566d0a49014cea6f395e8be68c42b9e46d9
215{"total":7,"additions":1,"deletions":6}1672011-02-22T02:53:32Z1https://api.github.com/gists/1/24c894e1ca5cefd36b3b6e914beb93a7068f6efb{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic24c894e1ca5cefd36b3b6e914beb93a7068f6efb
216{"total":7,"additions":6,"deletions":1}6172008-07-15T18:17:27Z1https://api.github.com/gists/1/0864db9cbe551088b2269128c5b5d145141f57ef{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic0864db9cbe551088b2269128c5b5d145141f57ef
217{"total":1,"additions":1,"deletions":0}1012008-07-15T18:17:14Z1https://api.github.com/gists/1/8afc134bf14f8f56ed2e7234128490d9946e8c16{"login":"schacon","id":70,"node_id":"MDQ6VXNlcjcw","avatar_url":"https://avata…https://avatars.githubusercontent.com/u/70?v=4—https://api.github.com/users/schacon/events{/privacy}https://api.github.com/users/schacon/followershttps://api.github.com/users/schacon/following{/other_user}https://api.github.com/users/schacon/gists{/gist_id}—https://github.com/schacon70schacon—MDQ6VXNlcjcwhttps://api.github.com/users/schacon/orgshttps://api.github.com/users/schacon/received_eventshttps://api.github.com/users/schacon/reposfalse—https://api.github.com/users/schacon/starred{/owner}{/repo}https://api.github.com/users/schacon/subscriptionsUserhttps://api.github.com/users/schaconpublic8afc134bf14f8f56ed2e7234128490d9946e8c16

Column profile

31 columns actually returned by coral. Catalog claims "1 required filter(s)": "gist_id". Click a column to drill in.

#ColumnInferred typeNon-nullNullsSample value(s)
1change_statusstring60"{\"total\":7,\"additions\":6,\"deletions\":1}"
2change_status__additionsstring60"6"
3change_status__deletionsstring60"1"
4change_status__totalstring60"7"
5committed_atstring60"2011-02-22T02:58:22Z"
6gist_idstring60"1"
7urlstring60"https://api.github.com/gists/1/3a641566d0a49014cea6f395e8be6"
8userstring60"{\"login\":\"schacon\",\"id\":70,\"node_id\":\"MDQ6VXNlcjcw\",\"avatar_"
9user__avatar_urlstring60"https://avatars.githubusercontent.com/u/70?v=4"
10user__email—06empty
11user__events_urlstring60"https://api.github.com/users/schacon/events{/privacy}"
12user__followers_urlstring60"https://api.github.com/users/schacon/followers"
13user__following_urlstring60"https://api.github.com/users/schacon/following{/other_user}"
14user__gists_urlstring60"https://api.github.com/users/schacon/gists{/gist_id}"
15user__gravatar_id—06empty
16user__html_urlstring60"https://github.com/schacon"
17user__idstring60"70"
18user__loginstring60"schacon"
19user__name—06empty
20user__node_idstring60"MDQ6VXNlcjcw"
21user__organizations_urlstring60"https://api.github.com/users/schacon/orgs"
22user__received_events_urlstring60"https://api.github.com/users/schacon/received_events"
23user__repos_urlstring60"https://api.github.com/users/schacon/repos"
24user__site_adminstring60"false"
25user__starred_at—06empty
26user__starred_urlstring60"https://api.github.com/users/schacon/starred{/owner}{/repo}"
27user__subscriptions_urlstring60"https://api.github.com/users/schacon/subscriptions"
28user__typestring60"User"
29user__urlstring60"https://api.github.com/users/schacon"
30user__user_view_typestring60"public"
31versionstring60"3a641566d0a49014cea6f395e8be68c42b9e46d9"

Trial comparison

Variant / comboTrial #LatencyRowsStatusFirst key returned
minimalt126653ms1okchange_status, change_status__additions, change_status__deletions
minimalt225263ms1okchange_status, change_status__additions, change_status__deletions
realistict128577ms4okchange_status, change_status__additions, change_status__deletions
realistict232432ms4okchange_status, change_status__additions, change_status__deletions
edget128874ms4okchange_status, change_status__additions, change_status__deletions
edget227633ms4okchange_status, change_status__additions, change_status__deletions

Catalog vs. response schemaclaimed guide vs columns coral actually returned

Catalog guide (verbatim)
Requires gist_id. Use LIMIT for spot checks; large result sets paginate quickly.
Columns coral returned (31)
change_statuschange_status__additionschange_status__deletionschange_status__totalcommitted_atgist_idurluseruser__avatar_urluser__emailuser__events_urluser__followers_urluser__following_urluser__gists_urluser__gravatar_iduser__html_urluser__iduser__loginuser__nameuser__node_iduser__organizations_urluser__received_events_urluser__repos_urluser__site_adminuser__starred_atuser__starred_urluser__subscriptions_urluser__typeuser__urluser__user_view_typeversion
Probed by bld-dabqr1nqj5pc73dgn3h0-676t6 at 2026-08-31T06:10:50Z
JSON record: reports/github/tables/gist_commits.json
first_run_at: 2026-08-31T06:10:50Z
last_retried_at: 2026-08-31T06:10:50Z
retry_count: 0
View version history →