home

ci-timing

Data source: JuliaCI/julia-ci-timing

Custom SQL query

Queries

  • Jobs waiting for an agent now, per pool
  • When each source last ran
  • Slowest jobs of the latest julia-ci build
  • One job's duration by week
  • Queue wait per julia-ci build over the last :days days
  • Regressions in the latest Nanosoldier daily report
  • One benchmark's minimum time over time
  • A package's PkgEval history
  • Packages that passed the previous PkgEval report and not the latest
  • TTFX of one task per master build over the last :days days
  • One package's downloads per day, user and CI
  • Buildkite agents connected at the latest listing, with their jobs
  • One size metric of master commits over the last :days days
  • Open pull requests by how much their latest build changes the total size

Tables

agent_snapshot_members

time, agent_name

66,048 rows

agent_snapshots

time

622 rows

agents

name, fold_key, agent_id, hostname, queue, os, arch, version, meta_data, state, connected_at, first_seen, last_seen, job_json, change_seq

179 rows

bench_errors

report_id, bench_id, error

0 rows

bench_names

id, grp, name

5,132 rows

bench_report_groups

report_id, grp, stat, geomean_ns, count, gctime_geomean_ns, gctime_count, memory_geomean_bytes, memory_count, allocs_geomean, allocs_count

38,176 rows

bench_reports

id, path, kind, date, commit_sha, baseline_commit_sha, baseline_date, julia_version, llvm, cpu, os, benchmarktools_version, nanosoldier_commit, report_total, report_regressions, report_improvements, change_seq

451 rows

bench_results

report_id, bench_id, stat, time_ns, gctime_ns, memory_bytes, allocs

Many rows

bench_verdicts

report_id, bench_id, time_ratio, time_tolerance, memory_ratio, memory_tolerance, verdict

90,445 rows

builds

id, pipeline, number, commit_prefix, commit_sha, branch, state, source, blocked, pull_request, author, message, created_at, scheduled_at, started_at, finished_at, web_url, change_seq

3,977 rows

commits

sha, author, authored_at, committed_at, subject, pr_number

0 rows

coverage

commit_sha, measured_at, codecov, coveralls, change_seq

2,258 rows

dl_client_types

date, client_type, request_addrs, request_count, successes, cache_misses, body_bytes_sent, request_time_s

948 rows

dl_julia_systems

date, julia_system, client_type, request_addrs, request_count, successes, cache_misses, body_bytes_sent, request_time_s

Many rows

dl_julia_versions

date, julia_version, client_type, request_addrs, request_count, successes, cache_misses, body_bytes_sent, request_time_s

39,038 rows

dl_mix

date, kind, key, total_requests, user_requests, ci_requests

4,859 rows

dl_package_uuids

id, uuid

22,778 rows

dl_packages

date, package_id, status, client_type, request_addrs, request_count, cache_misses, body_bytes_sent

Many rows

dl_resource_types

date, resource_type, status, client_type, request_addrs, request_count, cache_misses, body_bytes_sent, request_time_s

10,211 rows

dl_series

date, total_requests, user_requests, ci_requests, change_seq

317 rows

job_kinds

id, name, kind, os, triplet, flags

0 rows

jobs

id, build_id, name, retry, job_uuid, step_key, kind_id, agent_hostname, agent_name, queue, state, exit_status, soft_failed, retried, retries_count, retry_type, parallel_group_index, duration_s, created_at, scheduled_at, runnable_at, started_at, finished_at, web_url, change_seq

234,522 rows

julia_tags

tag, date, published_at, url, prerelease

43 rows

meta

key, value

10 rows

packages

id, name

15,483 rows

pkgeval_reasons

report_id, status, reason, count

8,268 rows

pkgeval_reports

id, path, kind, date, commit_sha, julia_version, total, ok, fail, crash, skip, kill, change_seq

1,647 rows

pkgeval_results

report_id, package_id, version, status, reason, duration_s

Many rows

pool_jobs

job_uuid, pipeline, build, name, queue, os, arch, state, runnable_at, started_at, finished_at, change_seq

128,712 rows

raw_builds

pipeline, number, fetched_at, json_zst

307 rows

raw_ttfx

job_uuid, fetched_at, results_zst, meta_zst

232 rows

registry_packages

uuid, name, path

14,502 rows

size_builds

id, source, triplet, commit_sha, merged_at, version, build, message, measured_at, change_seq

8,138 rows

size_files

size_build_id, path, bytes

216,720 rows

size_metrics

size_build_id, metric, value

477,607 rows

size_open_prs

pr_number, title, author, draft, base_ref

1,038 rows

size_prs

pr_number, title, author, draft, base_ref, build, build_created_at, web_url, head_commit, merge_base, base_commit, change_seq

133 rows

source_runs

id, source, started_at, finished_at, ok, rows_written, error

3,525 rows

ttfx_arms

job_uuid, arm, commit_sha, version

232 rows

ttfx_failures

job_uuid, task, error

378 rows

ttfx_jobs

job_uuid, pipeline, build, triplet, state, build_created_at, commit_sha, version, message, agent, cpu, snippets, blocks, n_tasks, n_metrics, selected_arm, started_at, finished_at, web_url, has_samples, change_seq, kind

339 rows

ttfx_prs

pr_number, title, author, draft, pr_head_sha, build, job_uuid, job_state, build_created_at, finished_at, web_url, head_commit, head_version, base_commit, base_version, blocks, n_tasks, verdict, n_improvements, n_regressions, suite, tasks, change_seq, ci_commit, ci_build, ci_state, ci_url, head_ref, base_ref

94 rows

ttfx_results

job_uuid, task, precompile, load, run, warm, load_gcoff, run_gcoff, warm_gcoff

12,292 rows

ttfx_samples

job_uuid, seq, task, arm, block, status, error, error_gcoff, precompile_s, load_s, run_s, total_s, load_gcoff_s, run_gcoff_s, total_gcoff_s

17,151 rows

sqlite_stat1 (hidden)

tbl, idx, stat

28 rows

Powered by Datasette · Queries took 232.503ms · Data source: JuliaCI/julia-ci-timing