这是个轻量账号:所有消费发生在 同一个上午的 36 分钟里(06-05 11:35–12:11 北京时间),全部是图片编辑,一共 $0.72。数据同样来自 billing_log,按 billing_meta->>'user_email' 过滤。
| 模型(仅 confirmed) | 笔数 | 单价 | 金额 |
|---|---|---|---|
| ultra-nano-banana-edit-resize | 10 | $0.04 | $0.40 |
| ultra-gpt-edit | 8 | $0.025 | $0.20 |
| funpub-fal-gpt-2-edit | 1 | $0.121 | $0.12 |
| 时间(北京) | 模型 | 金额 | 状态 | task |
|---|---|---|---|---|
| 06-05 12:11 | ultra-gpt-edit | $0.0251 | confirmed | c55e0272 |
| 06-05 12:10 | funpub-fal-gpt-2-edit | $0.1210 | confirmed | 39b6ba6a |
| 06-05 12:08 | ultra-gpt-edit | $0.0251 | confirmed | d44f0ba6 |
| 06-05 12:08 | ultra-gpt-edit | $0.0251 | void | 39b6ba6a |
| 06-05 12:03 | ultra-gpt-edit | $0.0251 | confirmed | be1101fc |
| 06-05 12:02 | ultra-gpt-edit | $0.0251 | confirmed | e02c8122 |
| 06-05 12:01 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | 667012f3 |
| 06-05 12:00 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | 140327da |
| 06-05 11:59 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | 98d49cb1 |
| 06-05 11:59 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | 9a93a19d |
| 06-05 11:58 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | 88bea23a |
| 06-05 11:50 | ultra-gpt-edit | $0.0251 | confirmed | 4e172576 |
| 06-05 11:49 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | 2dd0ed05 |
| 06-05 11:41 | ultra-gpt-edit | $0.0251 | confirmed | 2aa632a8 |
| 06-05 11:40 | ultra-gpt-edit | $0.0251 | confirmed | ff7ad077 |
| 06-05 11:39 | ultra-gpt-edit | $0.0251 | confirmed | b40a70ea |
| 06-05 11:38 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | ffa632fe |
| 06-05 11:37 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | b82a4a09 |
| 06-05 11:36 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | d970b921 |
| 06-05 11:35 | ultra-nano-banana-edit-resize | $0.0400 | confirmed | ec28e4bc |
19 个任务对应 19 张图。billing_meta 里没有 session_id(这批调用没带会话上下文),env 字段也是空的。
一个坑:库里 email 存的是全小写。带大写去查会查成 0 行,稳妥写法用 lower():
SELECT created_at, exec_model_id, est_cost, status FROM billing_log WHERE lower(billing_meta->>'user_email') = lower('Lopezpaultoodv1829@gmail.com') ORDER BY created_at DESC; -- 看真实花费只统计 status='confirmed';void 是换主体重记,别重复算