azure - Githubissues

kirin-ri commented 4 months ago

let cpu_rate_per_core_hour = 0.048; // 1 vCPUあたりの料金（USD/時間） let mem_rate_per_gb_hour = 0.012; // 1 GiB RAMあたりの料金（USD/時間）

// 各名前空間のCPU使用量の料金計算 let cpu_cost = KubePodInventory | summarize AvgCPU=avg(TotalCpuUsageNanoCores) by Namespace | extend CPUHours = AvgCPU (datetime_diff('hour', max(TimeGenerated), min(TimeGenerated))) / 1e9 | extend CPUCost = CPUHours cpu_rate_per_core_hour;

// 各名前空間のメモリ使用量の料金計算 let mem_cost = KubePodInventory | summarize AvgMemory=avg(TotalMemoryUsageBytes) by Namespace | extend MemoryHours = AvgMemory (datetime_diff('hour', max(TimeGenerated), min(TimeGenerated))) / (1024 1024 1024) | extend MemoryCost = MemoryHours mem_rate_per_gb_hour;

// CPUとメモリの料金を統合 cpu_cost | join kind=inner (mem_cost) on Namespace | project Namespace, CPUCost, MemoryCost, TotalCost = CPUCost + MemoryCost

kirin-ri commented 4 months ago

Error

The name 'cpu_cost' does not refer to any known table, tabular variable or function.

kirin-ri commented 4 months ago

let cpu_rate_per_core_hour = 0.048;  // 1 vCPUあたりの料金（USD/時間）
let mem_rate_per_gb_hour = 0.012;    // 1 GiB RAMあたりの料金（USD/時間）

// 各名前空間のCPU使用量の料金計算
let cpu_cost = KubePodInventory
| summarize AvgCPU=avg(TotalCpuUsageNanoCores) by Namespace
| extend CPUHours = AvgCPU * (datetime_diff('hour', max(TimeGenerated), min(TimeGenerated))) / 1e9
| extend CPUCost = CPUHours * cpu_rate_per_core_hour;

// 各名前空間のメモリ使用量の料金計算
let mem_cost = KubePodInventory
| summarize AvgMemory=avg(TotalMemoryUsageBytes) by Namespace
| extend MemoryHours = AvgMemory * (datetime_diff('hour', max(TimeGenerated), min(TimeGenerated))) / (1024 * 1024 * 1024)
| extend MemoryCost = MemoryHours * mem_rate_per_gb_hour;

// CPUとメモリの料金を統合
cpu_cost
| join kind=inner (mem_cost) on Namespace
| project Namespace, CPUCost, MemoryCost, TotalCost = CPUCost + MemoryCost

kirin-ri commented 4 months ago

let cpu_rate_per_core_hour = 0.048; // 1 vCPUあたりの料金（USD/時間） let mem_rate_per_gb_hour = 0.012; // 1 GiB RAMあたりの料金（USD/時間）

// 各名前空間のCPU使用量の料金計算 let cpu_cost = KubePodInventory | summarize AvgCPU=avg(TotalCpuUsageNanoCores) by Namespace | extend CPUHours = AvgCPU (datetime_diff('hour', max(TimeGenerated), min(TimeGenerated))) / 1e9 | extend CPUCost = CPUHours cpu_rate_per_core_hour;

// 各名前空間のメモリ使用量の料金計算 let mem_cost = KubePodInventory | summarize AvgMemory=avg(TotalMemoryUsageBytes) by Namespace | extend MemoryHours = AvgMemory (datetime_diff('hour', max(TimeGenerated), min(TimeGenerated))) / (1024 1024 1024) | extend MemoryCost = MemoryHours mem_rate_per_gb_hour;

// CPUとメモリの料金を統合 cpu_cost | join kind=inner (mem_cost) on Namespace | project Namespace, CPUCost, MemoryCost, TotalCost = CPUCost + MemoryCost

kirin-ri commented 4 months ago

let cpu_rate_per_core_hour = 0.048; // 1 vCPUあたりの料金（USD/時間） let mem_rate_per_gb_hour = 0.012; // 1 GiB RAMあたりの料金（USD/時間）

// 各名前空間のCPU使用量の料金計算 let cpu_cost = KubePodInventory | where TimeGenerated >= ago(30d) | summarize AvgCPU=avg(CpuUsageNanoCores) by Namespace | extend CPUHours = AvgCPU (datetime_diff('hour', max(TimeGenerated), min(TimeGenerated))) / 1e9 | extend CPUCost = CPUHours cpu_rate_per_core_hour;

// 各名前空間のメモリ使用量の料金計算 let mem_cost = KubePodInventory | where TimeGenerated >= ago(30d) | summarize AvgMemory=avg(MemoryUsageBytes) by Namespace | extend MemoryHours = AvgMemory (datetime_diff('hour', max(TimeGenerated), min(TimeGenerated))) / (1024 1024 1024) | extend MemoryCost = MemoryHours mem_rate_per_gb_hour;

// CPUとメモリの料金を統合 cpu_cost | join kind=inner (mem_cost) on Namespace | project Namespace, CPUCost, MemoryCost, TotalCost = CPUCost + MemoryCost

kirin-ri commented 4 months ago

TenantId c88bf5c1-8f71-4cea-ac74-f7c80746b79e SourceSystem Containers TimeGenerated [UTC] 2024-07-24T01:19:58Z Computer aks-nodepool1-20355066-vmss000003 ClusterId /subscriptions/234a74a7-bd43-4159-906b-bee68f8574be/resourceGroups/rg-i-dna-aks/providers/Microsoft.ContainerService/managedClusters/I-DNA-Cluster ContainerCreationTimeStamp [UTC] 2024-03-22T07:37:02Z PodUid f5da154d-a68a-4d2d-a9c9-03a18afa0cc6 PodCreationTimeStamp [UTC] 2024-03-22T07:36:54Z ContainerRestartCount 0 PodRestartCount 0 PodStartTime [UTC] 2024-03-22T07:36:54Z ControllerKind DaemonSet ControllerName csi-blob-node ContainerStatus running ContainerID cce984b8b3981ebc47dd752747a2458870c3654ef088a7323ce6751e4b930a3e ContainerName f5da154d-a68a-4d2d-a9c9-03a18afa0cc6/blob Name csi-blob-node-9lfwz PodLabel [{"app":"csi-blob-node","controller-revision-hash":"6fb8776f9d","kubernetes.azure.com\/managedby":"aks","pod-template-generation":"1"}] Namespace kube-system PodStatus Running ClusterName I-DNA-Cluster PodIp 10.224.0.4 ContainerLastStatus {} Type KubePodInventory _ResourceId /subscriptions/234a74a7-bd43-4159-90

kirin-ri commented 4 months ago

kirin-ri commented 4 months ago

import subprocess
import pandas as pd

# 名前空間を指定
namespace = "<your-namespace>"

# kubectlコマンドを実行してリソース使用量を取得
kubectl_command = f"kubectl top pod --namespace {namespace}"
result = subprocess.run(kubectl_command.split(), capture_output=True, text=True)

# コマンド出力を処理
data = []
lines = result.stdout.split("\n")
for line in lines[1:]:
    if line:
        parts = line.split()
        pod_name = parts[0]
        cpu_usage = parts[1]
        memory_usage = parts[2]
        data.append({"pod_name": pod_name, "cpu_usage": cpu_usage, "memory_usage": memory_usage})

# データフレームに変換
df = pd.DataFrame(data)

# 単位変換 (mCPU to CPU, Mi to GiB)
df['cpu_usage'] = df['cpu_usage'].apply(lambda x: float(x.replace('m', '')) / 1000)
df['memory_usage'] = df['memory_usage'].apply(lambda x: float(x.replace('Mi', '')) / 1024)

# 料金計算用のレート (仮定の値を使用)
cpu_rate_per_core_hour = 0.048  # 1 vCPUあたりの料金（USD/時間）
mem_rate_per_gb_hour = 0.012    # 1 GiB RAMあたりの料金（USD/時間）

# 使用時間を仮定 (1時間の使用量)
usage_hours = 1

# CPUとメモリのコストを計算
df['cpu_cost'] = df['cpu_usage'] * cpu_rate_per_core_hour * usage_hours
df['memory_cost'] = df['memory_usage'] * mem_rate_per_gb_hour * usage_hours

# 合計コストを計算
df['total_cost'] = df['cpu_cost'] + df['memory_cost']

# 名前空間ごとのコストを集計
namespace_costs = df.sum()

print(namespace_costs)