CollageMaker — LLM Usage & Value Report

Contents of report provided by AI generated script still in development. Please take these numbers as potentially accurate but not definitely accurate.

Summary Metrics ▾
32.8M
Effective Tokens
474.2M
Raw Tokens
330
Sessions
99.4K
Avg / Session
13
Commits
53.2K
Lines Added
$24.17
Est. Cost (Low, raw)
$241.68
Est. Cost (High, raw)
$6.51
Est. Cost (Low, w/cache)
$43.04
Est. Cost (High, w/cache)
94.0%
Cache Hit Rate

Period: 2026-07-01 to 2026-07-18 · 9 models · 17 agent roles · Generated: 2026-07-18

Cost estimates: cloud-equivalent per-model pricing (actual cost: $0, all models run locally via LM Studio).

$17.66 saved via prompt context caching (73.1% reduction, 94.0% cache hit rate).

32.8M tokens consumed across 13 commits producing 6,304 lines of code. (est. effective)

13
Total Commits
6.3K
Lines Added
2.5M
Avg Tokens / Commit
5.2K
Avg Tokens / Line Added
4.5%
Reasoning %
4.0M
Peak Tok / Commit
47.6%
Sessions w/ File Changes
157/330
Productive Sessions
44.8%
Build Agent Productive
3.8%
Build Tokens w/ Zero Changes

Notes: summary_files is only populated for sessions where opencode recorded file changes. Most sessions are exploratory, research, or cross-session coordination. 7 days had 16.2M tokens with zero commits (e.g., research, debugging, cross-session coordination).

Charts & Visualizations ▾

Token Usage by Model

qwen/qwen3.6-27b
23.3M
agents-a1
4.1M
ornith-1.0-35b
1.5M
qwen-agentworld-35b-a3b
2.9M
qwen/qwen3.6-27b-q4
139.2K
google/gemma-4-31b-qat
321.1K
qwen/qwen3.6-27b-lite
170.6K
big-pickle
397.2K
qwen/qwen3.5-9b
0

Token Usage by Agent

build-tdd
6.1M (33)
build-docs
10.7M (86)
build
5.0M (30)
build-test
2.5M (24)
build-debug
1.9M (8)
planner
1.8M (19)
world-review
2.2M (88)
general
143.4K (2)
plan
351.2K (3)
plan-bdd
623.8K (6)
explore
734.0K (9)
build-quick-work
421.5K (12)
diff-review-g31
165.0K (4)
build-code
120.4K (1)
solid-review
41.8K (1)
planner-g31
51.8K (3)
solid-review-g31
20.7K (1)

Daily Token Trend

2026-07-01 2026-07-03 2026-07-05 2026-07-07 2026-07-09 2026-07-11 2026-07-13 2026-07-15 2026-07-17 5.3M 2.7M
DateInputOutputReasoningTotal
2026-07-01965.9K90.8K31.7K1.1M
2026-07-021.8M231.8K58.1K2.0M
2026-07-033.6M316.2K167.3K4.0M
2026-07-043.0M373.1K144.3K3.5M
2026-07-054.4M608.8K304.5K5.3M
2026-07-06809.8K87.7K31.3K928.7K
2026-07-071.7M184.7K72.8K2.0M
2026-07-082.0M169.4K64.5K2.2M
2026-07-09734.1K85.7K44.0K863.7K
2026-07-101.2M106.8K121.0K1.5M
2026-07-111.2M104.3K62.9K1.3M
2026-07-122.0M209.8K115.8K2.3M
2026-07-131.1M152.8K53.1K1.3M
2026-07-14931.7K90.3K46.7K1.1M
2026-07-15690.7K72.2K38.3K801.2K
2026-07-16274.2K39.3K19.7K333.1K
2026-07-17419.7K38.3K19.5K477.5K
2026-07-181.5M136.0K78.9K1.7M

Tokens vs. Commits

2026-07-01 2026-07-03 2026-07-05 2026-07-07 2026-07-09 2026-07-11 2026-07-13 2026-07-15 2026-07-17 5.3M 2.7M 5 2 Total Tokens Uncached Input Commits
DateTotal TokensInput (Uncached)Input (Cached)OutputReasoningCommits
2026-07-011.1M965.9K12.5M90.8K31.7K1
2026-07-022.0M1.8M25.1M231.8K58.1K5
2026-07-034.0M3.6M39.0M316.2K167.3K1
2026-07-043.5M3.0M42.8M373.1K144.3K0
2026-07-055.3M4.4M92.0M608.8K304.5K0
2026-07-06928.7K809.8K6.1M87.7K31.3K0
2026-07-072.0M1.7M24.4M184.7K72.8K1
2026-07-082.2M2.0M33.7M169.4K64.5K0
2026-07-09863.7K734.1K10.5M85.7K44.0K1
2026-07-101.5M1.2M31.1M106.8K121.0K0
2026-07-111.3M1.2M13.5M104.3K62.9K0
2026-07-122.3M2.0M24.2M209.8K115.8K2
2026-07-131.3M1.1M23.8M152.8K53.1K0
2026-07-141.1M931.7K19.3M90.3K46.7K0
2026-07-15801.2K690.7K9.0M72.2K38.3K1
2026-07-16333.1K274.2K4.2M39.3K19.7K0
2026-07-17477.5K419.7K5.2M38.3K19.5K0
2026-07-181.7M1.5M25.3M136.0K78.9K1

Tokens per Commit vs. per Line Added

2026-07-01 2026-07-03 2026-07-05 2026-07-07 2026-07-09 2026-07-11 2026-07-13 2026-07-15 2026-07-17 4.0M 2.0M 1.1K 549 Tokens / Commit Tokens / Line Added
DateTok/CommitTok/LineCommitsAdds
2026-07-011.1M96111.3K
2026-07-02408.6K40355.1K
2026-07-034.0M89614.5K
2026-07-040000
2026-07-050000
2026-07-060000
2026-07-072.0M143113.8K
2026-07-080000
2026-07-09863.7K20714.2K
2026-07-100000
2026-07-110000
2026-07-121.2M35626.6K
2026-07-130000
2026-07-140000
2026-07-15801.2K12816.2K
2026-07-160000
2026-07-170000
2026-07-181.7M1.1K11.6K

Cumulative Tokens vs. Cumulative Lines Added

2026-07-01 2026-07-03 2026-07-05 2026-07-07 2026-07-09 2026-07-11 2026-07-13 2026-07-15 2026-07-17 32.8M 16.4M 46.9K 23.5K Cumulative Tokens Cumulative Lines Added
DateCum. TokensCum. Lines AddedTok/Line
2026-07-011.1M11.3K96
2026-07-023.1M16.2K193
2026-07-037.2M20.6K348
2026-07-0410.7M20.6K520
2026-07-0516.0M20.6K778
2026-07-0617.0M20.6K823
2026-07-0718.9M33.2K570
2026-07-0821.2M33.2K637
2026-07-0922.0M36.8K599
2026-07-1023.5M36.8K638
2026-07-1124.8M36.8K675
2026-07-1227.1M40.1K677
2026-07-1328.4M40.1K708
2026-07-1429.5M40.1K735
2026-07-1530.3M45.5K666
2026-07-1630.6M45.5K673
2026-07-1731.1M45.5K684
2026-07-1832.8M46.9K699

Cumulative Estimated Cost

2026-07-01 2026-07-03 2026-07-05 2026-07-07 2026-07-09 2026-07-11 2026-07-13 2026-07-15 2026-07-17 $10 $4 $22 $11 Cum. Cost (Low) Cum. Cost (High)
DateDaily (Low)Daily (High)Cum. (Low)Cum. (High)
2026-07-01$0.30$0.72$0.30$0.72
2026-07-02$0.71$1.47$1.01$2.19
2026-07-03$1.06$2.61$2.07$4.80
2026-07-04$1.16$2.47$3.22$7.28
2026-07-05$1.85$3.77$5.07$11.05
2026-07-06$0.28$0.63$5.35$11.68
2026-07-07$0.59$1.34$5.94$13.02
2026-07-08$0.58$1.45$6.52$14.46
2026-07-09$0.27$0.59$6.78$15.05
2026-07-10$0.36$0.90$7.14$15.95
2026-07-11$0.35$0.86$7.49$16.81
2026-07-12$0.68$1.55$8.17$18.36
2026-07-13$0.46$0.92$8.63$19.28
2026-07-14$0.30$0.70$8.92$19.98
2026-07-15$0.23$0.53$9.16$20.51
2026-07-16$0.12$0.24$9.27$20.75
2026-07-17$0.13$0.31$9.40$21.06
2026-07-18$0.45$1.11$9.86$22.17

Rolling 7-Day Tokens per Commit Trend

2026-07-01 2026-07-03 2026-07-05 2026-07-07 2026-07-09 2026-07-11 2026-07-13 2026-07-15 2026-07-17 8.2M 4.1M
Date7d Avg Tok/CommitCommits
2026-07-011.1M1
2026-07-02521.9K5
2026-07-031.0M1
2026-07-041.5M0
2026-07-052.3M0
2026-07-062.4M0
2026-07-072.4M1
2026-07-082.9M0
2026-07-096.3M1
2026-07-108.2M0
2026-07-117.1M0
2026-07-122.8M2
2026-07-132.9M0
2026-07-143.5M0
2026-07-152.3M1
2026-07-162.9M0
2026-07-172.5M0
2026-07-182.0M1

Daily Token Breakdown by Agent Category

2026-07-01 2026-07-03 2026-07-05 2026-07-07 2026-07-09 2026-07-11 2026-07-13 2026-07-15 2026-07-17 5.3M 2.7M Build Review Plan Explore Other
DateBuildReviewPlanExploreOtherTotal
2026-07-011.1M24.9K0001.1M
2026-07-022.0M32.5K4.4K002.0M
2026-07-033.8M94.3K162.6K004.0M
2026-07-043.1M13.7K361.4K23.5K03.5M
2026-07-055.2M76.6K29.2K005.3M
2026-07-06684.5K63.3K71.7K109.3K0928.7K
2026-07-071.6M25.7K277.4K38.1K02.0M
2026-07-082.1M36.6K100.2K002.2M
2026-07-09859.1K4.7K000863.7K
2026-07-101.4M3.4K28.4K001.5M
2026-07-111.3M5.9K019.9K01.3M
2026-07-122.0M43.7K134.8K47.2K122.5K2.3M
2026-07-131.2M1.6K22.1K24.3K46.2K1.3M
2026-07-141.1M2.5K0001.1M
2026-07-15693.0K7.0K47.4K053.8K801.2K
2026-07-16330.9K2.2K000333.1K
2026-07-17384.8K1.8K034.9K56.1K477.5K
2026-07-181.6M5.3K54.0K042.4K1.7M
Cost Analysis ▾

All models run locally via LM Studio — actual API cost is $0. Cloud-equivalent costs below show what these sessions would cost if run through commercial APIs at current per-model pricing.

$0.00
Actual Cost
Local execution only · no API fees
$250.23
Cloud-Equivalent (Raw)
$45.32
Cloud-Equivalent (w/Cache)
$204.91
Saved by Context Caching

$204.91 saved via prompt context caching (81.9% reduction, 94.0% cache hit rate).

Cloud-Equivalent Cost by Model

ModelSessionsInput TokensOutput TokensRaw Costw/Cache CostCache Savings
qwen/qwen3.6-27b16400$176.70$30.67$146.03
agents-a13300$44.06$6.93$37.13
ornith-1.0-35b1800$13.85$2.59$11.26
qwen-agentworld-35b-a3b9800$13.32$4.43$8.90
qwen/qwen3.6-27b-q4100$0.96$0.17$0.79
qwen/qwen3.6-27b-lite300$0.66$0.16$0.51
google/gemma-4-31b-qat1000$0.44$0.15$0.28
big-pickle100$0.23$0.21$0.02
qwen/qwen3.5-9b200$0.00$0.00$0.00

Assumed Pricing Rates

ModelInput ($/M)Output ($/M)Cached Input ($/M)
openai/gpt-4o$2.500$10.000$1.250
anthropic/claude-sonnet-4$3.000$15.000$0.300
google/gemma-4-31b-qat$0.250$1.000$0.025
qwen/qwen3.6-27b$0.500$1.500$0.050
qwen/qwen3.6-35b-a3b$0.800$2.400$0.080
qwen/qwq-32b$0.600$1.800$0.060
ornith-1.0-35b$0.700$2.100$0.070
qwen/qwen3-coder-next$0.750$2.250$0.075
qwen-agentworld-35b-a3b$0.800$2.400$0.080
gemini/gemini-2.5-flash$0.150$0.600$0.015
fallback$0.500$1.500$0.050

Per-model rates above are used for detailed cost calculations. Flat-rate tiers below are used for summary estimates.

TierInput ($/M)Output ($/M)Cached Input ($/M)
Cheap$0.05$0.15$0.01
Expensive$0.50$1.50$0.05

Estimated Cloud Cost Over Time (Hypothetical)

2026-07-01 2026-07-03 2026-07-05 2026-07-07 2026-07-09 2026-07-11 2026-07-13 2026-07-15 2026-07-17 $10 $4 $22 $11 Cum. Cost (Low) Cum. Cost (High)
DateDaily (Low)Daily (High)Cum. (Low)Cum. (High)
2026-07-01$0.30$0.72$0.30$0.72
2026-07-02$0.71$1.47$1.01$2.19
2026-07-03$1.06$2.61$2.07$4.80
2026-07-04$1.16$2.47$3.22$7.28
2026-07-05$1.85$3.77$5.07$11.05
2026-07-06$0.28$0.63$5.35$11.68
2026-07-07$0.59$1.34$5.94$13.02
2026-07-08$0.58$1.45$6.52$14.46
2026-07-09$0.27$0.59$6.78$15.05
2026-07-10$0.36$0.90$7.14$15.95
2026-07-11$0.35$0.86$7.49$16.81
2026-07-12$0.68$1.55$8.17$18.36
2026-07-13$0.46$0.92$8.63$19.28
2026-07-14$0.30$0.70$8.92$19.98
2026-07-15$0.23$0.53$9.16$20.51
2026-07-16$0.12$0.24$9.27$20.75
2026-07-17$0.13$0.31$9.40$21.06
2026-07-18$0.45$1.11$9.86$22.17
Detailed Data Tables ▾

Model × Agent Breakdown

ModelAgentSessionsEffective Tokens
qwen/qwen3.6-27bbuild-tdd330
qwen/qwen3.6-27bbuild-docs620
agents-a1build110
qwen/qwen3.6-27bbuild130
qwen/qwen3.6-27bbuild-test120
agents-a1build-docs70
agents-a1build-test100
ornith-1.0-35bbuild-docs70
qwen/qwen3.6-27bbuild-debug60
qwen/qwen3.6-27bplanner160
qwen-agentworld-35b-a3bbuild-debug10
qwen-agentworld-35b-a3bworld-review880
agents-a1general20
qwen/qwen3.6-27bplan-bdd60
agents-a1build-debug10
qwen/qwen3.6-27bexplore90
ornith-1.0-35bbuild-quick-work80
qwen/qwen3.6-27bplan20
qwen/qwen3.6-27b-q4plan10
qwen-agentworld-35b-a3bbuild-docs70
qwen/qwen3.6-27b-liteplanner10
google/gemma-4-31b-qatbuild-docs20
google/gemma-4-31b-qatdiff-review-g3140
qwen/qwen3.6-27bbuild-code10
agents-a1planner20
big-picklebuild-docs10
qwen/qwen3.6-27bbuild-quick-work30
qwen/qwen3.6-27b-litebuild10
qwen-agentworld-35b-a3bbuild-quick-work10
ornith-1.0-35bbuild20
qwen/qwen3.6-27bsolid-review10
qwen-agentworld-35b-a3bbuild10
google/gemma-4-31b-qatplanner-g3130
google/gemma-4-31b-qatsolid-review-g3110
ornith-1.0-35bbuild-test10
qwen/qwen3.5-9bbuild20
qwen/qwen3.6-27b-litebuild-test10

Cache Approximation

Cache Impact by Model

ModelSessionsRaw InputUncachedCachedHit %
unknown164345.0M20.5M324.5M94.1%
unknown3385.8M3.3M82.5M96.1%
unknown1819.2M1.3M17.9M93.0%
unknown9814.5M2.2M12.4M85.1%
unknown11.9M124.4K1.7M93.3%
unknown101.5M267.9K1.3M82.5%
unknown31.3M156.4K1.1M87.8%
unknown1419.3K382.9K36.4K8.7%
unknown20000%

Cache Impact by Agent

AgentSessionsRaw InputUncachedCachedHit %
unknown33147.1M5.2M141.8M96.4%
unknown86130.8M9.4M121.4M92.8%
unknown3080.3M4.3M75.9M94.6%
unknown2446.8M2.0M44.7M95.7%
unknown827.4M1.7M25.7M93.8%
unknown1912.3M1.6M10.7M87.1%
unknown24.4M102.0K4.3M97.7%
unknown884.4M1.6M2.8M63.6%
unknown34.4M311.5K4.0M92.8%
unknown64.2M531.7K3.7M87.3%
unknown93.2M667.4K2.6M79.3%
unknown123.1M380.4K2.7M87.8%
unknown4568.1K141.9K426.1K75.0%
unknown1551.5K116.0K435.5K79.0%
unknown196.3K38.9K57.3K59.6%
unknown345.4K38.7K6.7K14.7%
unknown142.6K13.5K29.2K68.4%

Cache Impact by Day

DateSessionsRaw InputUncachedCachedHit %
513.5M965.9K12.5M92.8%
1726.8M1.8M25.1M93.5%
3742.6M3.6M39.0M91.7%
3945.8M3.0M42.8M93.4%
5396.4M4.4M92.0M95.4%
106.9M809.8K6.1M88.3%
2126.1M1.7M24.4M93.4%
1735.6M2.0M33.7M94.4%
1011.2M734.1K10.5M93.5%
932.3M1.2M31.1M96.2%
1014.6M1.2M13.5M92.1%
4126.2M2.0M24.2M92.3%
1324.8M1.1M23.8M95.7%
1020.2M931.7K19.3M95.4%
99.7M690.7K9.0M92.9%
64.5M274.2K4.2M93.9%
65.6M419.7K5.2M92.5%
1726.8M1.5M25.3M94.4%

Phase Breakdown

PhaseDatesEffective TokensSessionsCommitsLines AddedTest+Tok/CommitTok/LineTest%
Pre-Merge Exploration2026-05-10–2026-05-2400000000%
Ramp-Up2026-05-25–2026-05-3100000000%
Feature Velocity2026-06-01–2026-06-1400000000%
Efficiency Gains2026-06-15–2026-06-2900000000%

Commit Efficiency

Top 10 Most Efficient Commits

#DateMessageLinesAddsDelsTok/CommitTok/Line
12026-07-01CollageMaker: Phase 1 — add agents, skills, app shell, layout math, and canvas r112911129101.1M96
22026-07-15CollageMaker: add title system (handlers, interaction, manager), refactor hex pa71316247884801.2K112
32026-07-07CollageMaker: refactor into handler modules, add saliency/PWA/responsive feature150211380512162.0M131
42026-07-12CollageMaker: refactor app into handler modules, add crop preview/undo/render sy7726456431621.2M151
52026-07-09CollageMaker: add hex panel swap, multi-touch, crop overlay shape, refactor hand47714180591863.7K181
62026-07-02CollageMaker: add building-web-apps skill, test infrastructure, and Mocha/Chai t220822080408.6K185
72026-07-02CollageMaker: Fix UndoManager batch undo/redo, refactor E2E tests, add coverage141514150408.6K289
82026-07-02CollageMaker: add crop interaction, undo/redo, hover borders, and UI updates811652159408.6K504
92026-07-02CollageMaker: add crop interaction core modules7917910408.6K517
102026-07-12CollageMaker: fix render order, multi-touch pointer capture, undo callback stale20711999721.2M564

Top 10 Least Efficient Commits

#DateMessageLinesAddsDelsTok/CommitTok/Line
12026-07-02CollageMaker: remind agents to commit skills, tests, and configs110408.6K408.6K
22026-07-18CollageMaker: add multi-line title support (up to 3 lines via newline), fix hit 167515641111.7M1.0K
32026-07-03CollageMaker: add backgrounds, title/overlay rendering, export manager, and sett461445051094.0M875
42026-07-12CollageMaker: fix render order, multi-touch pointer capture, undo callback stale20711999721.2M564
52026-07-02CollageMaker: add crop interaction core modules7917910408.6K517
62026-07-02CollageMaker: add crop interaction, undo/redo, hover borders, and UI updates811652159408.6K504
72026-07-02CollageMaker: Fix UndoManager batch undo/redo, refactor E2E tests, add coverage141514150408.6K289
82026-07-02CollageMaker: add building-web-apps skill, test infrastructure, and Mocha/Chai t220822080408.6K185
92026-07-09CollageMaker: add hex panel swap, multi-touch, crop overlay shape, refactor hand47714180591863.7K181
102026-07-12CollageMaker: refactor app into handler modules, add crop preview/undo/render sy7726456431621.2M151

Agent Context Efficiency

AgentSessionsTotal TokensInputOutputReasoning
build-tdd33148.0M147.1M637.8K260.1K
build-docs86132.1M130.8M952.8K305.8K
build3080.9M80.3M436.5K181.8K
build-test2447.2M46.8M369.8K104.0K
build-debug827.6M27.4M111.4K90.5K
planner1912.5M12.3M161.9K22.8K
world-review885.0M4.4M184.5K421.1K
general24.4M4.4M35.2K6.2K
plan34.4M4.4M27.1K12.6K
plan-bdd64.3M4.2M84.1K7.9K
explore93.3M3.2M50.2K16.4K
build-quick-work123.2M3.1M22.8K18.3K
diff-review-g314591.2K568.1K4.0K19.1K
build-code1556.0K551.5K2.3K2.1K
solid-review199.1K96.3K2.5K324
planner-g31358.5K45.4K9.6K3.6K
solid-review-g31149.9K42.6K5.2K2.0K

Top Sessions by Token Count

#AgentModelTitleTokens (raw)
1build-tddqwen/qwen3.6-27bPhase 2 implementation, review, and learning capture26.9M
2build-tddqwen/qwen3.6-27bPhase 2 implementation: crop layout swap & learnings17.3M
3buildqwen/qwen3.6-27bOpencode LLM usage cost discrepancy review15.6M
4build-docsagents-a1Canvas image load error at localhost:800014.6M
5build-tddqwen/qwen3.6-27bImplement Phase 3 plan: review and capture learnings11.0M
6build-tddqwen/qwen3.6-27bPhase 1 implementation, review, and learning capture9.0M
7buildqwen/qwen3.6-27bPhase 3 implementation: fix-analytics-script-bugs.md8.9M
8build-debugqwen-agentworld-35b-a3bPhase 4 implementation, review, and learning capture8.4M
9buildagents-a1Opencode token usage analytics and reporting8.4M
10buildagents-a1Update analyzing-opencode-usage using Section 3.6 & @world-r7.8M
11build-testqwen/qwen3.6-27bImplement tests in Section 3.5; World Review and timeline up7.8M
12build-docsqwen/qwen3.6-27bPhase 2 implementation: CollageMaker Web Port7.2M
13build-docsqwen/qwen3.6-27bCollageMaker agent/skill review and adjustments7.1M
14build-docsqwen/qwen3.6-27bRun P0 tests from collagemaker-test-plan.md7.0M
15buildagents-a1Data access layer Phase 3 implementation6.7M
16build-docsqwen/qwen3.6-27bPhase 4 implementation & learnings documentation6.5M
17buildagents-a1Phase 6 implementation for data access layer plan6.4M
18build-docsqwen/qwen3.6-27bOpencode token usage analytics via SQLite6.3M
19build-docsornith-1.0-35bPlan implementation: Section 3.1 review5.8M
20build-debugqwen/qwen3.6-27bPhase 6 implementation and learnings capture5.7M