• Home
  • Features
  • Pricing
  • Docs
  • Announcements
  • Sign In

lsm / neokai / 25642120700
82%

Build:
DEFAULT BRANCH: dev
Ran 10 May 2026 10:59PM UTC
Jobs 28
Files 522
Run time 2min
Badge
Embed ▾
README BADGES
x

If you need to use a raster PNG badge, change the '.svg' to '.png' in the link

Markdown

Textile

RDoc

HTML

Rst

10 May 2026 10:58PM UTC coverage: 82.426% (-2.3%) from 84.724%
25642120700

push

github

web-flow
perf(daemon): use materialised parent_tool_use_id column in sdk_messages queries (#1853)

* perf(daemon): use materialised parent_tool_use_id column in sdk_messages queries

Replace `json_extract(sdk_message, '$.parent_tool_use_id')` with the
materialised `parent_tool_use_id` column across the `messages.bySession`
LiveQuery and SDKMessageRepository (top-level + subagent fetch, last
message, count). Switch the subagent CTE from a correlated EXISTS to
`parent_tool_use_id IN (SELECT id FROM tool_use_ids)` so the planner
picks `idx_sdk_messages_parent_tool_use_id` with a bloom filter.

Measured against a 167K-row session on the live daemon DB: ~150 ms → ~10 ms
per re-evaluation. Each SDK message arrival re-runs this query, so the
old form pegged the daemon's main thread at 99% CPU under sustained
ingest. Profile showed time concentrated in `sqlite3VdbeExec` →
`vdbeColumnFromOverflow` → `getOverflowPage` (reading the fat JSON blob
out of overflow pages) for every row scanned.

Also drop the now-unused `idx_sdk_messages_parent_tool` function index
in migration 126 — every call site now reads the column directly, so the
function index just amplified write cost.

* fix(daemon): remove legacy parent_tool index from migration 113

Codex review flagged that migration 113 still creates
idx_sdk_messages_parent_tool (the json_extract function index), while
migration 126 drops it on every startup. This causes a create-then-drop
cycle on every daemon boot for databases that have already run migration
113, adding avoidable startup I/O and write amplification proportional
to sdk_messages size.

Remove the CREATE INDEX from migration 113 and add a note explaining
that the column-based idx_sdk_messages_parent_tool_use_id (added by
migration 122) replaces it.

8347 of 11648 branches covered (71.66%)

Branch coverage included in aggregate %.

5 of 5 new or added lines in 3 files covered. (100.0%)

65292 of 77691 relevant lines covered (84.04%)

289.57 hits per line

Jobs
ID Job ID Ran Files Coverage
1 daemon-5-space-other - 25642120700.1 10 May 2026 10:59PM UTC 126
31.06
GitHub Action Run
2 daemon-0-shared - 25642120700.2 10 May 2026 10:59PM UTC 29
84.15
GitHub Action Run
3 daemon-5-space-runtime - 25642120700.3 10 May 2026 10:59PM UTC 148
40.11
GitHub Action Run
4 daemon-5-space-workflow - 25642120700.4 10 May 2026 10:59PM UTC 107
31.33
GitHub Action Run
5 daemon-online-features-1 - 25642120700.5 10 May 2026 10:59PM UTC 287
23.09
GitHub Action Run
6 daemon-online-convo - 25642120700.6 10 May 2026 10:59PM UTC 287
22.21
GitHub Action Run
7 daemon-online-rpc-1 - 25642120700.7 10 May 2026 10:59PM UTC 287
19.27
GitHub Action Run
8 daemon-4-space-storage - 25642120700.8 10 May 2026 11:00PM UTC 132
55.74
GitHub Action Run
9 daemon-2-handlers - 25642120700.9 10 May 2026 10:58PM UTC 129
56.94
GitHub Action Run
10 daemon-online-coordinator - 25642120700.10 10 May 2026 10:59PM UTC 287
7.42
GitHub Action Run
11 daemon-1-core - 25642120700.11 10 May 2026 10:59PM UTC 292
37.84
GitHub Action Run
12 daemon-online-rpc-3 - 25642120700.12 10 May 2026 10:59PM UTC 287
20.01
GitHub Action Run
13 daemon-online-agent-sdk - 25642120700.13 10 May 2026 11:00PM UTC 287
22.34
GitHub Action Run
14 daemon-online-websocket - 25642120700.14 10 May 2026 10:59PM UTC 287
17.9
GitHub Action Run
15 daemon-online-mcp - 25642120700.15 10 May 2026 10:59PM UTC 287
18.22
GitHub Action Run
16 daemon-online-lifecycle - 25642120700.16 10 May 2026 10:59PM UTC 287
22.78
GitHub Action Run
17 daemon-online-components - 25642120700.17 10 May 2026 10:59PM UTC 287
17.77
GitHub Action Run
18 daemon-online-features-2 - 25642120700.18 10 May 2026 10:59PM UTC 287
22.74
GitHub Action Run
19 daemon-online-sdk - 25642120700.19 10 May 2026 10:59PM UTC 287
22.23
GitHub Action Run
20 daemon-online-rewind-1 - 25642120700.20 10 May 2026 11:00PM UTC 287
22.53
GitHub Action Run
21 daemon-online-git - 25642120700.21 10 May 2026 10:59PM UTC 287
18.91
GitHub Action Run
22 daemon-online-rewind-2 - 25642120700.22 10 May 2026 11:00PM UTC 287
23.07
GitHub Action Run
23 daemon-online-space-2 - 25642120700.23 10 May 2026 11:00PM UTC 287
32.15
GitHub Action Run
24 daemon-online-space-1 - 25642120700.24 10 May 2026 11:00PM UTC 287
32.25
GitHub Action Run
25 daemon-online-rpc-2 - 25642120700.25 10 May 2026 11:00PM UTC 287
23.72
GitHub Action Run
26 web - 25642120700.26 10 May 2026 11:00PM UTC 222
76.55
GitHub Action Run
27 daemon-5-space-agent - 25642120700.27 10 May 2026 10:59PM UTC 170
28.17
GitHub Action Run
28 daemon-online-rpc-4 - 25642120700.28 10 May 2026 11:00PM UTC 287
23.63
GitHub Action Run
Source Files on build 25642120700
  • Tree
  • List 522
  • Changed 4
  • Source Changed 4
  • Coverage Changed 3
Coverage ∆ File Lines Relevant Covered Missed Hits/Line Branch Hits Branch Misses
  • Back to Repo
  • Github Actions Build #25642120700
  • 2ed8dfed on github
  • Prev Build on dev (#25641967925)
  • Next Build on dev (#25646115400)
  • Delete
STATUS · Troubleshooting · Open an Issue · Sales · Support · CAREERS · ENTERPRISE · START FREE · SCHEDULE DEMO
ANNOUNCEMENTS · TWITTER · TOS & SLA · Supported CI Services · What's a CI service? · Automated Testing

© 2026 Coveralls, Inc