Skip to content
Sign in

flagon-io/g1t

public
0

g1t/services/billing/src/keeper.rs

1,053 lines47,033 bytesCodeBlame
1//! Keeps every price current with what g1t actually pays.
2//!
3//! g1t passes its own costs through, so a price is only right while the
4//! cost under it is. Two jobs keep them right, on the billing service's
5//! cron:
6//!
7//! - **Settling runs** (every 15 minutes). A model run is charged when it
8//! finishes at what the sandbox reported. Each of g1t's hosted runs goes
9//! through its AI Gateway, which prices every request at the provider's
10//! current rates and logs it with the run's session. Settling sums those
11//! logs and corrects the charge to the gateway's figure, with a
12//! correction on the statement. A run whose sandbox died before
13//! reporting is charged here instead of never.
14//! - **Checking costs** (daily). What Cloudflare billed g1t's account, from
15//! its usage API, is measured against how much was used: Containers
16//! against the seconds containers ran, Workers for Platforms per request
17//! and per CPU millisecond. When a measured cost moves, the price book
18//! moves with it, since each price is its cost plus a set markup, and
19//! the change is recorded where anyone can see it. A measurement goes
20//! through `pricing` as a proposal: a small move is applied on its own (a
21//! rise only after customers have had notice), a large or suspect one
22//! waits for staff in sudo, so one odd day of data cannot reprice
23//! everything.
24
25use g1t_contracts::billing::{EntryKind, MICROS_PER_DOLLAR, Price, PriceBook, PriceChange};
26
27use g1t_contracts::time::rfc3339;
28use g1t_kit::now_ms;
29use serde::Deserialize;
30use serde_json::{Value, json};
31use worker::{Env, Fetch, Headers, Method, Request, RequestInit, Result};
32
33use crate::{Billing, RunRow};
34
35/// The cron that also checks costs against Cloudflare's bill.
36pub(crate) const DAILY: &str = "17 4 * * *";
37
38/// A run is settled once its logs have had time to land.
39const SETTLE_AFTER_MS: u64 = 5 * 60 * 1000;
40/// A run with no gateway logs after this is left as reported.
41const GIVE_UP_AFTER_MS: u64 = 3 * 60 * 60 * 1000;
42/// A run never finished after this died without reporting.
43const ABANDONED_AFTER_MS: u64 = 3 * 60 * 60 * 1000;
44
45/// Where the keeper reads what g1t pays.
46pub(crate) struct Keeper {
47 /// `CLOUDFLARE_USAGE_TOKEN`: Billing, Account Analytics and AI Gateway,
48 /// read only.
49 token: Option<String>,
50 /// What reads the bill for `costs`: `CLOUDFLARE_BILLING_TOKEN`
51 /// (Account: Billing Read and Account Analytics Read), or the usage
52 /// token, which has both.
53 billing_token: Option<String>,
54 account: String,
55 gateway: String,
56}
57
58impl Keeper {
59 pub(crate) fn from_env(env: &Env) -> Self {
60 let var = |name: &str| env.var(name).map(|v| v.to_string()).unwrap_or_default();
61 let secret = |name: &str| env.secret(name).ok().map(|v| v.to_string()).filter(|v| !v.is_empty());
62 let token = secret("CLOUDFLARE_USAGE_TOKEN");
63 Keeper {
64 billing_token: secret("CLOUDFLARE_BILLING_TOKEN").or_else(|| token.clone()),
65 token,
66 account: var("CLOUDFLARE_ACCOUNT_ID"),
67 gateway: var("AI_GATEWAY_ID"),
68 }
69 }
70
71 async fn send(&self, method: Method, url: &str, body: Option<Value>) -> Result<Value> {
72 let Some(token) = &self.token else {
73 return Err(worker::Error::RustError("no CLOUDFLARE_USAGE_TOKEN".into()));
74 };
75 send_with(token, method, url, body).await
76 }
77
78 /// Whether Cloudflare's bill can be read.
79 pub(crate) fn can_read_bill(&self) -> bool {
80 self.billing_token.is_some() && !self.account.is_empty()
81 }
82
83 fn billing_token(&self) -> Result<&str> {
84 self.billing_token
85 .as_deref()
86 .ok_or_else(|| worker::Error::RustError("no CLOUDFLARE_BILLING_TOKEN or CLOUDFLARE_USAGE_TOKEN".into()))
87 }
88
89 /// Billable usage from `from` to `to` (dates), as Cloudflare answers it.
90 pub(crate) async fn billable_usage_body(&self, from: &str, to: &str) -> Result<Value> {
91 send_with(self.billing_token()?, Method::Get, &self.api(&format!("/billable-usage?from={from}&to={to}")), None).await
92 }
93
94 /// The account's subscriptions (Workers Paid, add-ons), as Cloudflare
95 /// answers them. Needs Account: Billing Read.
96 pub(crate) async fn subscriptions_body(&self) -> Result<Value> {
97 send_with(self.billing_token()?, Method::Get, &self.api("/subscriptions"), None).await
98 }
99
100 /// A GraphQL Analytics query, as Cloudflare answers it, errors and all.
101 pub(crate) async fn graphql(&self, body: Value) -> Result<Value> {
102 send_with(self.billing_token()?, Method::Post, "https://api.cloudflare.com/client/v4/graphql", Some(body)).await
103 }
104
105 pub(crate) fn account(&self) -> &str {
106 &self.account
107 }
108
109 fn api(&self, path: &str) -> String {
110 format!("https://api.cloudflare.com/client/v4/accounts/{}{path}", self.account)
111 }
112
113 /// AI Gateway's id, empty when there is none.
114 pub(crate) fn gateway(&self) -> &str {
115 &self.gateway
116 }
117
118 /// A GraphQL query over AI Gateway's analytics: with the keeper's token
119 /// (AI Gateway Read) first, and on failure with the bill's. Not the
120 /// other way round: Cloudflare answers a token that cannot see AI
121 /// Gateway with no rows, not an error, so the bill's token would read
122 /// as a gateway that priced nothing.
123 pub(crate) async fn gateway_graphql(&self, body: Value) -> Result<Value> {
124 let Some(token) = &self.token else {
125 return self.graphql(body).await;
126 };
127 match send_with(token, Method::Post, "https://api.cloudflare.com/client/v4/graphql", Some(body.clone())).await {
128 Ok(answer) => Ok(answer),
129 Err(error) => match &self.billing_token {
130 Some(billing) if billing != token => self.graphql(body).await,
131 _ => Err(error),
132 },
133 }
134 }
135
136 /// What AI Gateway priced a session's requests at, and how many there
137 /// were, with the requests it had no price for.
138 async fn session_cost(&self, session: &str) -> Result<SessionCost> {
139 let mut total = SessionCost { complete: true, ..SessionCost::default() };
140 for page in 1..=MAX_LOG_PAGES {
141 // The filter goes as URL-encoded JSON; the bracket form is
142 // ignored, and would sum every log there is. Session ids are
143 // [a-z0-9_], which need no escaping inside it.
144 let filter = format!(
145 "%5B%7B%22key%22%3A%22metadata.value%22%2C%22operator%22%3A%22eq%22%2C%22value%22%3A%5B%22{session}%22%5D%7D%5D"
146 );
147 let url = self.api(&format!(
148 "/ai-gateway/gateways/{}/logs?per_page=50&page={page}&filters={filter}",
149 self.gateway
150 ));
151 let body = self.send(Method::Get, &url, None).await?;
152 let logs = body["result"].as_array().cloned().unwrap_or_default();
153 for log in &logs {
154 total.add(log);
155 }
156 if logs.len() < 50 {
157 return Ok(total);
158 }
159 }
160 // More logs than were read: what was read is less than the run.
161 total.complete = false;
162 Ok(total)
163 }
164
165 /// The account's billable usage, one row per service per day, as
166 /// Cloudflare reports it.
167 async fn billable_usage(&self, from: &str, to: &str) -> Result<Vec<UsageRow>> {
168 let body = self
169 .send(Method::Get, &self.api(&format!("/billable-usage?from={from}&to={to}")), None)
170 .await?;
171 let rows = body["result"].as_array().cloned().unwrap_or_default();
172 Ok(rows.iter().filter_map(UsageRow::from_value).collect())
173 }
174
175 /// What g1t's containers used from `since` to `until` (dates), as
176 /// Cloudflare bills it: memory in byte-seconds, and CPU seconds.
177 async fn container_usage(&self, since: &str, until: &str) -> Result<ContainerUsage> {
178 let query = "query ($account: String!, $since: Date!, $until: Date!) {
179 viewer { accounts(filter: { accountTag: $account }) {
180 containersUsageAdaptiveGroups(limit: 1000, filter: { date_geq: $since, date_leq: $until }) {
181 sum { cpuTimeSec allocatedMemory }
182 }
183 } }
184 }";
185 let body = self
186 .send(
187 Method::Post,
188 "https://api.cloudflare.com/client/v4/graphql",
189 Some(json!({ "query": query, "variables": { "account": self.account, "since": since, "until": until } })),
190 )
191 .await?;
192 let groups = body["data"]["viewer"]["accounts"][0]["containersUsageAdaptiveGroups"]
193 .as_array()
194 .cloned()
195 .unwrap_or_default();
196 Ok(groups.iter().fold(ContainerUsage::default(), |total, g| ContainerUsage {
197 cpu_seconds: total.cpu_seconds + g["sum"]["cpuTimeSec"].as_f64().unwrap_or(0.0),
198 memory_byte_seconds: total.memory_byte_seconds + g["sum"]["allocatedMemory"].as_f64().unwrap_or(0.0),
199 }))
200 }
201}
202
203/// A request to Cloudflare's API with a bearer token; anything but 200 is
204/// an error with what Cloudflare said.
205async fn send_with(token: &str, method: Method, url: &str, body: Option<Value>) -> Result<Value> {
206 let headers = Headers::new();
207 headers.set("authorization", &format!("Bearer {token}"))?;
208 headers.set("content-type", "application/json")?;
209 let mut init = RequestInit::new();
210 init.with_method(method).with_headers(headers);
211 if let Some(body) = body {
212 init.with_body(Some(body.to_string().into()));
213 }
214 let mut response = Fetch::Request(Request::new_with_init(url, &init)?).send().await?;
215 let status = response.status_code();
216 let value: Value = response.json().await.unwrap_or(Value::Null);
217 if status != 200 {
218 return Err(worker::Error::RustError(format!("Cloudflare answered {status}: {value}")));
219 }
220 Ok(value)
221}
222
223#[derive(Debug, Default, Clone, Copy)]
224pub(crate) struct ContainerUsage {
225 cpu_seconds: f64,
226 memory_byte_seconds: f64,
227}
228
229/// g1t's sandboxes: Containers' standard-1, half a vCPU, 4 GiB, 8 GB disk.
230const SANDBOX_GIB: f64 = 4.0;
231const SANDBOX_DISK_GB: f64 = 8.0;
232const GIB: f64 = 1024.0 * 1024.0 * 1024.0;
233/// The Durable Object behind each container is billed for as long as the
234/// container runs, at 128 MB.
235const SANDBOX_DO_GB: f64 = 0.125;
236
237/// Cloudflare's published Containers rates, in dollars, used for any rate
238/// the bill does not show yet (while usage is inside the included amount).
239const LIST_MEMORY_GIB_SECOND: f64 = 0.000_002_5;
240const LIST_DISK_GB_SECOND: f64 = 0.000_000_07;
241const LIST_VCPU_SECOND: f64 = 0.000_02;
242/// Durable Objects duration: $12.50 per million GB-seconds.
243const LIST_DO_GB_SECOND: f64 = 0.000_012_5;
244
245/// What one second of a sandbox costs whatever it does, in millionths of a
246/// dollar: its memory and disk, and the Durable Object behind it, for the
247/// whole second. CPU is billed only while busy, on top.
248pub(crate) fn sandbox_base_micros(memory: f64, disk: f64, durable_object: f64) -> f64 {
249 (SANDBOX_GIB * memory + SANDBOX_DISK_GB * disk + SANDBOX_DO_GB * durable_object) * MICROS_PER_DOLLAR as f64
250}
251
252/// What one second of a sandbox costs on average, in millionths of a
253/// dollar: its base, and the CPU sandboxes actually use per second of
254/// running. Runs that report their own CPU are priced on it instead (see
255/// `run_cost`).
256pub(crate) fn sandbox_second_micros(usage: ContainerUsage, memory: f64, disk: f64, vcpu: f64, durable_object: f64) -> Option<f64> {
257 let instance_seconds = usage.memory_byte_seconds / (SANDBOX_GIB * GIB);
258 if instance_seconds < 3600.0 {
259 return None;
260 }
261 let cpu_share = usage.cpu_seconds / instance_seconds;
262 Some(sandbox_base_micros(memory, disk, durable_object) + cpu_share * vcpu * MICROS_PER_DOLLAR as f64)
263}
264
265/// How much more a second of a larger machine's memory and disk (and the
266/// Durable Object behind it) costs than the standard sandbox's, at
267/// Cloudflare's list rates: 1 for the standard machine.
268pub(crate) fn base_scale(memory_gib: f64, disk_gb: f64) -> f64 {
269 let base = |memory: f64, disk: f64| memory * LIST_MEMORY_GIB_SECOND + disk * LIST_DISK_GB_SECOND + SANDBOX_DO_GB * LIST_DO_GB_SECOND;
270 base(memory_gib, disk_gb) / base(SANDBOX_GIB, SANDBOX_DISK_GB)
271}
272
273/// What a run that reported its own CPU cost g1t: its base for every
274/// second, and its vCPU-seconds at the vCPU rate.
275pub(crate) fn run_cost(seconds: i64, cpu_seconds: f64, base_per_second: f64, per_vcpu_second: f64) -> f64 {
276 seconds.max(0) as f64 * base_per_second + cpu_seconds.max(0.0) * per_vcpu_second
277}
278
279/// A unit's marginal rate from the bill: the median, over the days that
280/// were charged, of cost over quantity. None while nothing was charged.
281pub(crate) fn billed_rate(rows: &[&UsageRow]) -> Option<f64> {
282 let mut rates: Vec<f64> = rows
283 .iter()
284 .filter(|r| r.cost > 0.0 && r.quantity > 0.0)
285 .map(|r| r.cost / r.quantity)
286 .collect();
287 if rates.is_empty() {
288 return None;
289 }
290 rates.sort_by(f64::total_cmp);
291 Some(rates[rates.len() / 2])
292}
293
294/// One line of Cloudflare's billable usage.
295#[derive(Debug, Clone)]
296pub(crate) struct UsageRow {
297 period_start: String,
298 period_end: String,
299 service: String,
300 unit: String,
301 quantity: f64,
302 cost: f64,
303}
304
305impl UsageRow {
306 /// Read leniently: the API is new, and its field names are FOCUS's.
307 fn from_value(row: &Value) -> Option<Self> {
308 let text = |keys: &[&str]| keys.iter().find_map(|k| row[*k].as_str()).unwrap_or_default().to_owned();
309 let number = |keys: &[&str]| {
310 keys.iter()
311 .find_map(|k| row[*k].as_f64().or_else(|| row[*k].as_str().and_then(|s| s.parse().ok())))
312 .unwrap_or(0.0)
313 };
314 let service = text(&["ServiceName", "service_name", "service"]);
315 if service.is_empty() {
316 return None;
317 }
318 let family = text(&["ServiceFamilyName", "service_family_name"]);
319 Some(UsageRow {
320 period_start: text(&["ChargePeriodStart", "charge_period_start"]),
321 period_end: text(&["ChargePeriodEnd", "charge_period_end"]),
322 service: if family.is_empty() { service } else { format!("{family} / {service}") },
323 unit: text(&["PricingUnit", "ConsumedUnit", "consumed_unit"]),
324 quantity: number(&["PricingQuantity", "ConsumedQuantity", "pricing_quantity"]),
325 // What g1t pays; list price if nothing was contracted.
326 cost: Some(number(&["ContractedCost", "BilledCost", "contracted_cost"]))
327 .filter(|cost| *cost > 0.0)
328 .unwrap_or_else(|| number(&["ListCost", "list_cost"])),
329 })
330 }
331}
332
333#[derive(Deserialize)]
334struct PriceRow {
335 meter: String,
336 title: String,
337 unit: String,
338 cost_micros: f64,
339 markup_percent: u32,
340 source: String,
341 checked_at: Option<String>,
342 updated_at: String,
343}
344
345#[derive(Deserialize)]
346struct ChangeRow {
347 meter: String,
348 old_cost_micros: f64,
349 new_cost_micros: f64,
350 markup_percent: u32,
351 old_markup_percent: Option<u32>,
352 reason: String,
353 created_at: String,
354}
355
356#[derive(Deserialize)]
357struct Unsettled {
358 id: String,
359 workspace: String,
360 repo: String,
361 number: u32,
362 task: String,
363 model: String,
364 token_hash: String,
365 billed_to: Option<String>,
366 session_id: String,
367 created_at: String,
368 finished_at: Option<String>,
369}
370
371#[derive(Deserialize)]
372struct Charged {
373 cost_micros: Option<i64>,
374 description: String,
375 amount_micros: i64,
376}
377
378/// What a settled run's correction comes to, from the charges at the
379/// reported and the gateway's cost and what the workspace was charged at
380/// first. A charge up is drawn down like any charge; a charge down is
381/// given back only up to what the workspace paid, since what a credit or
382/// a pool paid was never the workspace's money.
383pub(crate) fn correction(reported_charge: i64, gateway_charge: i64, first_charged: i64) -> i64 {
384 let delta = gateway_charge - reported_charge;
385 if delta >= 0 { delta } else { delta.max(-first_charged.max(0)) }
386}
387
388/// A session's logs are read 50 at a time, up to this many pages.
389const MAX_LOG_PAGES: u32 = 40;
390
391/// What AI Gateway's logs say a session cost.
392#[derive(Clone, Debug, Default, PartialEq)]
393pub(crate) struct SessionCost {
394 /// What the gateway priced the requests at, in dollars.
395 pub cost_usd: f64,
396 pub requests: u32,
397 /// Requests that used tokens but that the gateway put no price on: a
398 /// model it has no price for. Their cost is not in `cost_usd`.
399 pub unpriced: u32,
400 /// The models of those, for the statement and the drift.
401 pub unpriced_models: Vec<String>,
402 /// False when there were more logs than were read.
403 pub complete: bool,
404}
405
406impl SessionCost {
407 /// Adds one log, read leniently: `cost` in dollars, `tokens_in` and
408 /// `tokens_out`, `cached` for an answer from the gateway's own cache
409 /// (which costs nothing).
410 pub(crate) fn add(&mut self, log: &Value) {
411 self.requests += 1;
412 let number = |key: &str| log[key].as_f64().or_else(|| log[key].as_str().and_then(|s| s.parse().ok()));
413 let cost = number("cost").filter(|c| c.is_finite() && *c > 0.0);
414 let tokens = number("tokens_in").unwrap_or(0.0) + number("tokens_out").unwrap_or(0.0);
415 let cached = log["cached"].as_bool().unwrap_or(false);
416 match cost {
417 Some(cost) => self.cost_usd += cost,
418 None if tokens > 0.0 && !cached => {
419 self.unpriced += 1;
420 let model = log["model"].as_str().unwrap_or("an unnamed model").to_owned();
421 if !self.unpriced_models.contains(&model) {
422 self.unpriced_models.push(model);
423 }
424 }
425 None => {}
426 }
427 }
428
429 /// Whether the gateway's figure is the whole of what the run cost.
430 pub(crate) fn whole(&self) -> bool {
431 self.complete && self.unpriced == 0
432 }
433}
434
435/// The cost a run is settled at, in millionths: the gateway's figure when
436/// it priced every request; otherwise (a model it has no price for, or
437/// more logs than were read) never less than the sandbox reported, since
438/// the gateway's sum is then short of what the provider bills. With a
439/// reason for the statement and the drift when it is not the gateway's
440/// figure alone.
441pub(crate) fn settled_cost(reported_micros: i64, gateway: &SessionCost) -> (i64, Option<String>) {
442 // Not held to MAX_RUN_COST_USD: the gateway's figure is trusted.
443 let priced = if gateway.cost_usd.is_finite() { (gateway.cost_usd.max(0.0) * MICROS_PER_DOLLAR as f64).ceil() as i64 } else { 0 };
444 if gateway.whole() {
445 return (priced, None);
446 }
447 let mut why = Vec::new();
448 if gateway.unpriced > 0 {
449 why.push(format!(
450 "AI Gateway has no price for {} of its {} requests ({})",
451 gateway.unpriced,
452 gateway.requests,
453 gateway.unpriced_models.join(", ")
454 ));
455 }
456 if !gateway.complete {
457 why.push(format!("more than {} of its requests were logged", gateway.requests));
458 }
459 (priced.max(reported_micros.max(0)), Some(why.join("; ")))
460}
461
462fn ms(timestamp: &str) -> u64 {
463 // RFC 3339 in UTC, as g1t writes them.
464 worker::js_sys::Date::parse(timestamp) as u64
465}
466
467impl Billing {
468 pub(crate) async fn prices(&self) -> Result<PriceBook> {
469 // Three reads at once; the plans are priced from the rows already
470 // read, not one query per meter (status.g1t.sh times this call).
471 let (prices, changes, coming) = futures_util::future::join3(
472 async { self.db.prepare("SELECT * FROM prices ORDER BY rowid").all().await?.results::<PriceRow>() },
473 async {
474 self.db
475 .prepare("SELECT * FROM price_changes ORDER BY created_at DESC LIMIT 20")
476 .all()
477 .await?
478 .results::<ChangeRow>()
479 },
480 // Changes still to come first, so a rise is seen before it is charged.
481 self.coming_changes(),
482 )
483 .await;
484 let (prices, changes, coming) = (prices?, changes?, coming?);
485 let model_markup = prices.iter().find(|row| row.meter == "agent_models").map_or(self.margin_percent, |row| row.markup_percent);
486 let book: std::collections::BTreeMap<&str, f64> = prices
487 .iter()
488 .map(|row| (row.meter.as_str(), Price::price_for(row.cost_micros, row.markup_percent)))
489 .collect();
490 // With the card fee on top of each monthly price, as it is charged.
491 let card_fee = self.card_fee().await?;
492 let plans: Vec<_> = g1t_contracts::billing::Feature::ALL
493 .iter()
494 .map(|feature| {
495 let mut plan = match feature {
496 g1t_contracts::billing::Feature::Security => crate::features::security_plan_at(&book),
497 _ => self.plan_at(&book),
498 };
499 plan.card_fee_cents = crate::tax::fee_for(i64::from(plan.monthly_cents), &card_fee) as u32;
500 plan
501 })
502 .collect();
503 Ok(PriceBook {
504 prices: prices
505 .into_iter()
506 .map(|row| Price {
507 price_micros: Price::price_for(row.cost_micros, row.markup_percent),
508 meter: row.meter,
509 title: row.title,
510 unit: row.unit,
511 cost_micros: row.cost_micros,
512 markup_percent: row.markup_percent,
513 source: row.source,
514 checked_at: row.checked_at,
515 updated_at: row.updated_at,
516 })
517 .collect(),
518 changes: coming
519 .into_iter()
520 .chain(changes.into_iter().map(|row| PriceChange {
521 meter: row.meter,
522 old_cost_micros: row.old_cost_micros,
523 new_cost_micros: row.new_cost_micros,
524 markup_percent: row.markup_percent,
525 old_markup_percent: row.old_markup_percent,
526 reason: row.reason,
527 created_at: row.created_at,
528 effective_at: None,
529 }))
530 .collect(),
531 // The markup on models' provider price: the price book's
532 // `agent_models` (none from 2026-10-08).
533 model_margin_percent: model_markup,
534 plans,
535 free: Some(g1t_contracts::billing::FreeTier {
536 trial_workspace_micros: if self.trials_on { self.plans.trial_workspace_micros } else { 0 },
537 trial_monthly_pool_micros: if self.trials_on { self.plans.trial_monthly_pool_micros } else { 0 },
538 oss_pool_micros: self.plans.oss_pool_micros,
539 oss_repo_micros: self.plans.oss_repo_micros,
540 free_private_storage_bytes: self.plans.free_storage_bytes,
541 audit_retention_days: self.plans.free_audit_days,
542 plan_audit_retention_days: self.plans.audit_days,
543 min_charge_micros: self.plans.min_charge_micros,
544 git_operations_included: self.plans.git_included,
545 paid_start_ceiling_micros: self.plans.paid_start_micros,
546 overage_forgive_cost_micros: self.plans.forgive_cost_micros,
547 }),
548 })
549 }
550
551 /// Whether the costs have never been checked against Cloudflare's bill.
552 pub(crate) async fn never_checked(&self) -> Result<bool> {
553 Ok(self
554 .db
555 .prepare("SELECT meter FROM prices WHERE checked_at IS NOT NULL LIMIT 1")
556 .first::<Value>(None)
557 .await?
558 .is_none())
559 }
560
561 /// A meter's cost and price per unit, from the book.
562 pub(crate) async fn price(&self, meter: &str) -> Result<Option<(f64, f64)>> {
563 #[derive(Deserialize)]
564 struct Row {
565 cost_micros: f64,
566 markup_percent: u32,
567 }
568 Ok(self
569 .db
570 .prepare("SELECT cost_micros, markup_percent FROM prices WHERE meter = ?")
571 .bind(&[meter.into()])?
572 .first::<Row>(None)
573 .await?
574 .map(|row| (row.cost_micros, Price::price_for(row.cost_micros, row.markup_percent))))
575 }
576
577 /// Corrects finished runs to what AI Gateway priced them at, and
578 /// charges runs whose sandbox died before reporting.
579 pub(crate) async fn settle_runs(&self, keeper: &Keeper) -> Result<()> {
580 if keeper.token.is_none() || keeper.gateway.is_empty() {
581 return Ok(());
582 }
583 let now = now_ms();
584 let runs = self
585 .db
586 .prepare(
587 "SELECT id, workspace, repo, number, task, model, token_hash, billed_to, session_id, created_at, finished_at
588 FROM runs
589 WHERE session_id IS NOT NULL AND settled_at IS NULL AND COALESCE(billed_to, 'g1t') = 'g1t'
590 AND ((finished_at IS NOT NULL AND finished_at < ?1) OR created_at < ?2)
591 ORDER BY created_at LIMIT 10",
592 )
593 .bind(&[rfc3339(now - SETTLE_AFTER_MS).into(), rfc3339(now - ABANDONED_AFTER_MS).into()])?
594 .all()
595 .await?
596 .results::<Unsettled>()?;
597 for run in runs {
598 let gateway = match keeper.session_cost(&run.session_id).await {
599 Ok(found) => found,
600 Err(error) => {
601 worker::console_error!("could not read gateway logs for {}: {error}", run.id);
602 continue;
603 }
604 };
605 let since = ms(run.finished_at.as_deref().unwrap_or(&run.created_at));
606 if gateway.requests == 0 && now.saturating_sub(since) < GIVE_UP_AFTER_MS {
607 continue;
608 }
609 self.settle(&run, &gateway).await?;
610 }
611 Ok(())
612 }
613
614 /// Closes runs on a workspace's own model provider: none is on g1t's
615 /// gateway, so nothing is corrected, but tokens the proxy counted after
616 /// the run reported, or for a sandbox that died before reporting, are
617 /// charged their agent rate now. Needs no gateway token.
618 pub(crate) async fn settle_own_runs(&self) -> Result<()> {
619 #[derive(Deserialize)]
620 struct Own {
621 id: String,
622 workspace: String,
623 repo: String,
624 number: u32,
625 task: String,
626 model: String,
627 token_hash: String,
628 billed_to: Option<String>,
629 }
630 let now = now_ms();
631 let runs = self
632 .db
633 .prepare(
634 "SELECT id, workspace, repo, number, task, model, token_hash, billed_to
635 FROM runs
636 WHERE billed_to = 'workspace' AND session_id IS NOT NULL AND settled_at IS NULL
637 AND ((finished_at IS NOT NULL AND finished_at < ?1) OR created_at < ?2)
638 ORDER BY created_at LIMIT 25",
639 )
640 .bind(&[rfc3339(now - SETTLE_AFTER_MS).into(), rfc3339(now - ABANDONED_AFTER_MS).into()])?
641 .all()
642 .await?
643 .results::<Own>()?;
644 for run in runs {
645 let settled_at = rfc3339(now_ms());
646 let claimed = self
647 .db
648 .prepare(
649 "UPDATE runs SET settled_at = ?1, finished_at = COALESCE(finished_at, ?1)
650 WHERE id = ?2 AND settled_at IS NULL RETURNING id",
651 )
652 .bind(&[settled_at.as_str().into(), run.id.as_str().into()])?
653 .first::<Value>(None)
654 .await?;
655 if claimed.is_none() {
656 continue;
657 }
658 let row = RunRow {
659 workspace: run.workspace,
660 repo: run.repo,
661 number: run.number,
662 task: run.task,
663 model: run.model,
664 token_hash: run.token_hash,
665 billed_to: run.billed_to,
666 };
667 self.charge_agent_rate(&run.id, &row, None).await?;
668 }
669 Ok(())
670 }
671
672 async fn settle(&self, run: &Unsettled, gateway: &SessionCost) -> Result<()> {
673 let requests = gateway.requests;
674 let row = RunRow {
675 workspace: run.workspace.clone(),
676 repo: run.repo.clone(),
677 number: run.number,
678 task: run.task.clone(),
679 model: run.model.clone(),
680 token_hash: run.token_hash.clone(),
681 billed_to: run.billed_to.clone(),
682 };
683 let charged = self
684 .db
685 .prepare("SELECT cost_micros, description, amount_micros FROM ledger WHERE reference = ?")
686 .bind(&[run.id.as_str().into()])?
687 .first::<Charged>(None)
688 .await?;
689 let reported = charged.as_ref().and_then(|c| c.cost_micros).unwrap_or(0);
690 // The gateway's figure; never under what the sandbox reported when
691 // the gateway could not price all of it (see `settled_cost`).
692 let (gateway_micros, short) = settled_cost(reported, gateway);
693 let terms = self.terms_of(&run.workspace).await?;
694 // Models at the price book's markup on the provider's price
695 // (`agent_models`), as `finish_run` charges them.
696 let markup = self.model_markup().await?;
697 // A cost's charge on the account's terms, and what a discount gave
698 // below cost plus the markup (counted as given, see `charged`).
699 let charge_for = |micros: i64| {
700 if self.free { (0, 0) } else { terms.discounted(crate::margin_on(micros, markup)) }
701 };
702 let settled_at = rfc3339(now_ms());
703 // Claim it, so two crons never settle it twice.
704 let claimed = self
705 .db
706 .prepare(
707 "UPDATE runs SET settled_at = ?, gateway_cost_micros = ?, gateway_note = ?, finished_at = COALESCE(finished_at, ?)
708 WHERE id = ? AND settled_at IS NULL RETURNING id",
709 )
710 .bind(&[
711 settled_at.as_str().into(),
712 (gateway_micros as f64).into(),
713 short.as_deref().map_or(worker::wasm_bindgen::JsValue::NULL, Into::into),
714 settled_at.as_str().into(),
715 run.id.as_str().into(),
716 ])?
717 .first::<Value>(None)
718 .await?;
719 if claimed.is_none() || requests == 0 {
720 return Ok(());
721 }
722 // Tokens counted after the run reported are charged their agent
723 // rate now (ai.rs).
724 self.charge_agent_rate(&run.id, &row, None).await?;
725 if let Some(why) = &short {
726 worker::console_warn!("run {} settled at no less than reported: {why}", run.id);
727 }
728 let short_note = short.as_ref().map_or(String::new(), |why| format!(" ({why}; charged at no less than the sandbox reported)"));
729 let free_note = if self.free { " (free while g1t is being built out)" } else { "" };
730 match charged {
731 // Never reported: charged now, from the gateway's figure.
732 None => {
733 let (charge, discount) = charge_for(gateway_micros);
734 let eligible = crate::credits::eligible_for(Some(g1t_contracts::billing::ComputeKind::Agent), None);
735 let drawn = self.draw(&run.workspace, charge, &settled_at[..7], &eligible).await?;
736 let description = format!(
737 "Work on {}#{}, settled from AI Gateway after the sandbox stopped without reporting{short_note}{free_note}{}",
738 run.repo,
739 run.number,
740 drawn.note()
741 );
742 self.enter(&run.workspace, EntryKind::Usage, -(charge - drawn.total()), &description, &run.id, Some(&row), Some(gateway_micros), None, None)
743 .await?;
744 self.record_drawn(&run.id, &drawn).await?;
745 self.record_discount(&run.id, discount).await?;
746 self.count_spend(&run.workspace, gateway_micros, charge - drawn.total(), &drawn).await;
747 }
748 Some(charged) => {
749 let delta = gateway_micros - reported;
750 if delta == 0 {
751 return Ok(());
752 }
753 let ((was, was_given), (now, now_given)) = (charge_for(reported), charge_for(gateway_micros));
754 let change = correction(was, now, -charged.amount_micros);
755 // What the discount gives moves with the charge.
756 let discount = now_given - was_given;
757 // A charge up is paid for like any other charge.
758 let drawn = if change > 0 {
759 let eligible = crate::credits::eligible_for(Some(g1t_contracts::billing::ComputeKind::Agent), None);
760 self.draw(&run.workspace, change, &settled_at[..7], &eligible).await?
761 } else {
762 crate::credits::Drawn::default()
763 };
764 let description = format!(
765 "Correction to “{}”: AI Gateway priced its {requests} model requests at {}, not {}{short_note}{}",
766 charged.description,
767 crate::features::dollars(gateway_micros),
768 crate::features::dollars(reported),
769 drawn.note(),
770 );
771 let reference = format!("{}/settled", run.id);
772 self.enter(
773 &run.workspace,
774 EntryKind::Usage,
775 -(change - drawn.total()),
776 &description,
777 &reference,
778 Some(&row),
779 Some(delta),
780 None,
781 None,
782 )
783 .await?;
784 self.record_drawn(&reference, &drawn).await?;
785 self.record_discount(&reference, discount).await?;
786 self.count_spend(&run.workspace, delta, change - drawn.total(), &drawn).await;
787 }
788 }
789 Ok(())
790 }
791
792 /// Checks each cost against what Cloudflare billed this month, and
793 /// moves the ones that changed.
794 pub(crate) async fn reconcile(&self, keeper: &Keeper) -> Result<()> {
795 if keeper.token.is_none() {
796 return Ok(());
797 }
798 let now = rfc3339(now_ms());
799 let today = &now[..10];
800 let since = rfc3339(now_ms() - 30 * 24 * 60 * 60 * 1000);
801 let rows = keeper.billable_usage(&since[..10], today).await?;
802 for row in &rows {
803 self.db
804 .prepare(
805 "INSERT INTO cloudflare_usage (period_start, period_end, service, unit, quantity, cost_usd, fetched_at)
806 VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7)
807 ON CONFLICT (period_start, service, unit) DO UPDATE SET
808 period_end = ?2, quantity = ?5, cost_usd = ?6, fetched_at = ?7",
809 )
810 .bind(&[
811 row.period_start.as_str().into(),
812 row.period_end.as_str().into(),
813 row.service.as_str().into(),
814 row.unit.as_str().into(),
815 row.quantity.into(),
816 row.cost.into(),
817 now.as_str().into(),
818 ])?
819 .run()
820 .await?;
821 }
822
823 let named = |words: &[&str]| -> Vec<&UsageRow> {
824 rows.iter()
825 .filter(|r| {
826 let service = r.service.to_lowercase();
827 words.iter().all(|word| service.contains(word))
828 })
829 .collect()
830 };
831
832 // Containers: each resource at what the bill shows it costs, or
833 // the published rate while the included amount still covers it,
834 // over how much CPU g1t's sandboxes really use per second.
835 let memory = billed_rate(&named(&["container memory"]));
836 let disk = billed_rate(&named(&["container disk"]));
837 let vcpu = billed_rate(&named(&["container vcpu"]));
838 let durable_object = billed_rate(&named(&["durable objects", "duration"]));
839 let usage = keeper.container_usage(&since[..10], today).await?;
840 let rates = (
841 memory.unwrap_or(LIST_MEMORY_GIB_SECOND),
842 disk.unwrap_or(LIST_DISK_GB_SECOND),
843 vcpu.unwrap_or(LIST_VCPU_SECOND),
844 durable_object.unwrap_or(LIST_DO_GB_SECOND),
845 );
846 // The parts, for runs that report their own CPU.
847 let parts_reason = "Cloudflare's Containers and Durable Objects rates, as billed or published";
848 self.measure("sandbox_base_second", sandbox_base_micros(rates.0, rates.1, rates.3), parts_reason).await?;
849 self.measure("sandbox_cpu_second", rates.2 * MICROS_PER_DOLLAR as f64, parts_reason).await?;
850 if let Some(per_second) = sandbox_second_micros(usage, rates.0, rates.1, rates.2, rates.3) {
851 let instance_seconds = usage.memory_byte_seconds / (SANDBOX_GIB * GIB);
852 let billed = [("memory", memory), ("disk", disk), ("vCPU", vcpu), ("Durable Object duration", durable_object)]
853 .iter()
854 .filter(|(_, rate)| rate.is_some())
855 .map(|(name, _)| *name)
856 .collect::<Vec<_>>();
857 let reason = format!(
858 "Sandboxes used {:.2} vCPU per second over {:.0} hours of Cloudflare Containers in the last 30 days, with the Durable Object behind each; {}",
859 usage.cpu_seconds / instance_seconds,
860 instance_seconds / 3600.0,
861 if billed.is_empty() {
862 "rates are Cloudflare's published ones".to_owned()
863 } else {
864 format!("{} at what Cloudflare billed", billed.join(", "))
865 },
866 );
867 for meter in ["sandbox_second", "build_second"] {
868 self.measure(meter, per_second, &reason).await?;
869 }
870 }
871 // Apps run as Workers: per million requests and CPU milliseconds,
872 // once the bill shows them charged.
873 // Security scans' CPU follows the same Workers CPU rate.
874 let app_meters: [(&str, &[&str], &str); 3] = [
875 ("app_requests", &["workers", "requests"], "requests"),
876 ("app_cpu", &["workers cpu"], "CPU ms"),
877 ("scan_cpu", &["workers cpu"], "CPU ms"),
878 ];
879 for (meter, words, unit) in app_meters {
880 if let Some(rate) = billed_rate(&named(words)) {
881 let reason = format!("Cloudflare billed Workers {unit} at ${:.2} per million", rate * 1e6);
882 self.measure(meter, rate * 1e6 * MICROS_PER_DOLLAR as f64, &reason).await?;
883 }
884 }
885 self.db
886 .prepare("UPDATE prices SET checked_at = ?")
887 .bind(&[now.as_str().into()])?
888 .run()
889 .await?;
890 Ok(())
891 }
892
893 /// Proposes moving a meter's cost to a measurement (see `pricing`):
894 /// applied on its own when small, after notice when a rise; left for
895 /// staff when large or suspect.
896 async fn measure(&self, meter: &str, measured: f64, reason: &str) -> Result<()> {
897 if let Some(outcome) = self.propose(meter, measured, reason, "keeper").await? {
898 worker::console_log!("{meter}: {outcome}");
899 }
900 Ok(())
901 }
902}
903
904#[cfg(test)]
905mod tests {
906 use super::*;
907
908 #[test]
909 fn a_correction_never_gives_back_what_the_workspace_did_not_pay() {
910 // Up by 2 cents: charged in full (then drawn down like any charge).
911 assert_eq!(correction(100_000, 120_000, 100_000), 20_000);
912 // Down by 2 cents, all of it paid by the workspace: given back.
913 assert_eq!(correction(120_000, 100_000, 120_000), -20_000);
914 // Down, but the open-source pool paid all but a cent: a cent back.
915 assert_eq!(correction(120_000, 100_000, 10_000), -10_000);
916 // Paid entirely by a credit or pool: nothing back.
917 assert_eq!(correction(120_000, 100_000, 0), 0);
918 }
919
920 fn logs(entries: &[Value]) -> SessionCost {
921 let mut total = SessionCost { complete: true, ..SessionCost::default() };
922 for log in entries {
923 total.add(log);
924 }
925 total
926 }
927
928 #[test]
929 fn a_run_is_settled_at_the_gateways_figure_when_it_priced_every_request() {
930 let gateway = logs(&[
931 json!({ "cost": 0.012, "tokens_in": 4000, "tokens_out": 300, "model": "claude-sonnet-5-5" }),
932 json!({ "cost": "0.003", "tokens_in": 900, "tokens_out": 40, "model": "claude-haiku-4-5" }),
933 // Served from the gateway's own cache: no cost, and none owed.
934 json!({ "cost": 0, "tokens_in": 900, "tokens_out": 40, "cached": true }),
935 // An error with no tokens costs nothing either.
936 json!({ "cost": null, "tokens_in": 0, "tokens_out": 0 }),
937 ]);
938 assert!(gateway.whole());
939 assert_eq!(gateway.requests, 4);
940 // Down from what the sandbox said, or up: the gateway's figure.
941 assert_eq!(settled_cost(20_000, &gateway), (15_000, None));
942 assert_eq!(settled_cost(9_000, &gateway), (15_000, None));
943 }
944
945 #[test]
946 fn a_model_the_gateway_cannot_price_is_never_settled_down_to_nothing() {
947 let gateway = logs(&[
948 json!({ "cost": 0.002, "tokens_in": 100, "tokens_out": 10, "model": "claude-haiku-4-5" }),
949 json!({ "cost": 0, "tokens_in": 50_000, "tokens_out": 2_000, "model": "claude-new-1" }),
950 json!({ "tokens_in": 50_000, "tokens_out": 2_000, "model": "claude-new-1" }),
951 ]);
952 assert!(!gateway.whole());
953 assert_eq!((gateway.unpriced, gateway.unpriced_models.clone()), (2, vec!["claude-new-1".to_owned()]));
954 // The sandbox said $0.90: kept, not cut to the gateway's $0.002.
955 let (cost, why) = settled_cost(900_000, &gateway);
956 assert_eq!(cost, 900_000);
957 assert!(why.unwrap().contains("no price for 2 of its 3 requests (claude-new-1)"));
958 // A sandbox that reported less than the gateway priced: the gateway's.
959 assert_eq!(settled_cost(1_000, &gateway).0, 2_000);
960 }
961
962 #[test]
963 fn more_logs_than_were_read_never_settle_a_run_down() {
964 let mut gateway = logs(&[json!({ "cost": 1.0, "tokens_in": 1, "tokens_out": 1 })]);
965 gateway.complete = false;
966 let (cost, why) = settled_cost(3_000_000, &gateway);
967 assert_eq!(cost, 3_000_000);
968 assert!(why.unwrap().contains("more than 1 of its requests"));
969 }
970
971 #[test]
972 fn a_gateway_figure_over_the_report_cap_is_charged_in_full() {
973 // A sandbox's report is believed up to $100; the gateway's is not capped.
974 let gateway = logs(&[json!({ "cost": 140.0, "tokens_in": 1, "tokens_out": 1 })]);
975 assert_eq!(settled_cost(100_000_000, &gateway).0, 140_000_000);
976 assert_eq!(crate::charge_micros(140.0, 20), 120_000_000);
977 assert_eq!(crate::margin_on(140_000_000, 20), 168_000_000);
978 // Exactly cost plus the margin, rounded up, in whole micros (dollars
979 // as floats can come out a micro high), never under it.
980 for cost in [0_i64, 1, 7, 999, 123_457, 99_999_999] {
981 let exact = (cost * 120 + 99) / 100;
982 assert_eq!(crate::margin_on(cost, 20), exact, "{cost}");
983 assert!(crate::margin_on(cost, 20) * 100 >= cost * 120, "{cost}");
984 assert!(crate::charge_micros(cost as f64 / 1e6, 20) >= exact, "{cost}");
985 }
986 }
987
988 #[test]
989 fn a_sandbox_second_is_its_memory_and_disk_and_the_cpu_it_uses() {
990 // An hour of sandboxes that kept a fifth of a vCPU busy.
991 let usage = ContainerUsage { cpu_seconds: 720.0, memory_byte_seconds: 3600.0 * 4.0 * GIB };
992 let micros =
993 sandbox_second_micros(usage, LIST_MEMORY_GIB_SECOND, LIST_DISK_GB_SECOND, LIST_VCPU_SECOND, LIST_DO_GB_SECOND).unwrap();
994 // 4 x 2.5 + 8 x 0.07 + 0.125 x 12.5 + 0.2 x 20 = 16.1225
995 assert!((micros - 16.1225).abs() < 1e-9, "{micros}");
996 // The Durable Object adds about 11% to the second it left out.
997 assert!((sandbox_base_micros(LIST_MEMORY_GIB_SECOND, LIST_DISK_GB_SECOND, LIST_DO_GB_SECOND) - 12.1225).abs() < 1e-9);
998 // Too little use to say anything.
999 assert!(sandbox_second_micros(ContainerUsage { cpu_seconds: 1.0, memory_byte_seconds: GIB }, 1.0, 1.0, 1.0, 1.0).is_none());
1000 }
1001
1002 #[test]
1003 fn a_run_that_reports_its_cpu_is_priced_on_it() {
1004 let base = sandbox_base_micros(LIST_MEMORY_GIB_SECOND, LIST_DISK_GB_SECOND, LIST_DO_GB_SECOND);
1005 let vcpu = LIST_VCPU_SECOND * MICROS_PER_DOLLAR as f64;
1006 // A 10-minute cargo build that kept its half vCPU busy throughout.
1007 let heavy = run_cost(600, 300.0, base, vcpu);
1008 assert!((heavy - (600.0 * 12.1225 + 300.0 * 20.0)).abs() < 1e-6);
1009 // The same ten minutes, mostly idle, costs less.
1010 let light = run_cost(600, 30.0, base, vcpu);
1011 assert!(light < heavy);
1012 // The average would have under-priced the heavy one.
1013 let average = 600.0 * (base + 0.195 * vcpu);
1014 assert!(average < heavy && average > light);
1015 assert_eq!(run_cost(0, -1.0, base, vcpu), 0.0);
1016 // A larger machine's base: its memory and disk, not its CPU.
1017 assert!((base_scale(SANDBOX_GIB, SANDBOX_DISK_GB) - 1.0).abs() < 1e-12);
1018 assert!((base_scale(12.0, 20.0) - 2.72).abs() < 0.01, "{}", base_scale(12.0, 20.0));
1019 assert!((base_scale(8.0, 16.0) - 1.87).abs() < 0.01, "{}", base_scale(8.0, 16.0));
1020 }
1021
1022 #[test]
1023 fn a_billed_rate_is_the_median_of_the_charged_days() {
1024 let row = |quantity: f64, cost: f64| UsageRow {
1025 period_start: String::new(),
1026 period_end: String::new(),
1027 service: "Containers / Container Memory".into(),
1028 unit: "Count".into(),
1029 quantity,
1030 cost,
1031 };
1032 let rows = [row(100.0, 0.0), row(100.0, 0.0002), row(100.0, 0.00025), row(100.0, 0.00025)];
1033 assert_eq!(billed_rate(&rows.iter().collect::<Vec<_>>()), Some(0.000_002_5));
1034 assert_eq!(billed_rate(&[&row(5.0, 0.0)]), None);
1035 }
1036
1037 #[test]
1038 fn usage_rows_are_read_by_their_focus_names() {
1039 let row = UsageRow::from_value(&json!({
1040 "ServiceFamilyName": "Containers",
1041 "ServiceName": "Memory",
1042 "PricingUnit": "GiB-seconds",
1043 "PricingQuantity": "1200.5",
1044 "ContractedCost": 0.003,
1045 "ChargePeriodStart": "2026-10-01",
1046 }))
1047 .unwrap();
1048 assert_eq!(row.service, "Containers / Memory");
1049 assert_eq!(row.quantity, 1200.5);
1050 assert_eq!(row.cost, 0.003);
1051 assert!(UsageRow::from_value(&json!({ "nothing": 1 })).is_none());
1052 }
1053}