SELECT
sku_category,
SUM(measurements_consumption) AS total_consumption,
SUM(amount) AS amount_before_discount,
SUM(total_after_discount) AS total_cost
FROM sys.information_schema.instance_usage
WHERE measurement_start >= CURRENT_DATE() - INTERVAL 7 DAYS
GROUP BY sku_category
ORDER BY total_cost DESC;
按 workspace 查看本月费用排行
SELECT
workspace_name,
SUM(total_after_discount) AS total_cost
FROM sys.information_schema.instance_usage
WHERE measurement_start >= DATE_TRUNC('month', CURRENT_DATE())
GROUP BY workspace_name
ORDER BY total_cost DESC;
查看某个 workspace 的每日费用趋势
SELECT
DATE(measurement_start) AS date,
sku_category,
SUM(total_after_discount) AS daily_cost
FROM sys.information_schema.instance_usage
WHERE workspace_name = '<your_workspace>'
AND measurement_start >= CURRENT_DATE() - INTERVAL 30 DAYS
GROUP BY DATE(measurement_start), sku_category
ORDER BY date DESC, daily_cost DESC;
查询计算集群的 CRU 消耗明细
SELECT
workspace_name,
sku_name,
DATE(measurement_start) AS date,
measurements_consumption AS cru_hours,
total_after_discount AS cost
FROM sys.information_schema.instance_usage
WHERE sku_category = 'compute'
AND measurement_start >= CURRENT_DATE() - INTERVAL 7 DAYS
ORDER BY date DESC, cost DESC;
查看存储用量超过阈值的 workspace
SELECT
workspace_name,
sku_name,
DATE(measurement_start) AS date,
measurements_consumption AS storage_gib
FROM sys.information_schema.instance_usage
WHERE sku_category = 'storage'
AND measurements_consumption > 100
AND measurement_start >= CURRENT_DATE() - INTERVAL 7 DAYS
ORDER BY storage_gib DESC;
查看 AI 函数的 Token 消耗
SELECT
workspace_name,
sku_name,
SUM(measurements_consumption) AS total_tokens_m,
SUM(total_after_discount) AS total_cost
FROM sys.information_schema.instance_usage
WHERE sku_category = 'ai'
GROUP BY workspace_name, sku_name
ORDER BY total_cost DESC;
