Cost analysis by resource

Go to Yandex Cloud Billing.

Select the billing account you need from the list.

Go to the Usage details tab.

At the top right, click Export details and select Periodic export.

In the window that opens:

• In the Bucket field, enter the name of the bucket you created earlier. A CSV file with your expense details will be kept there.
• In the Directory field, enter the name of the directory for the file. The last character must be /.
• In the Language field, select the language to display product names in: English or Русский.
• In the Usage details field, select the Resource type of details.

Click Create.

Run the query against Object Storage and save the output to a file:

1. For convenience, save:

   • Name of the bucket containing the details, to a variable named $bucket:

     bucket=<bucket_name>
     

   • Key of the object containing the details, to a variable named $key:

     key=<object_key>
     

   • S3 Select expression to request the data from the details file, to a variable named $query:

     query="select service_name,resource_id,sku_id,sku_name,\"date\",cost from S3Object where service_name='Compute Cloud'"
     

2. Run this command:

   aws --endpoint https://storage.yandexcloud.net s3api select-object-content \
     --bucket $bucket \
     --key $key \
     --expression "$query" \
     --expression-type 'SQL' \
     --input-serialization 'CSV={FileHeaderInfo=USE,FieldDelimiter=,}' \
     --output-serialization 'CSV={}' \
     "output.csv"
   

To output the total cost for each resource, run an aggregation query using the awk utility:

< output.csv awk -F, '{n[$2]+=$6} END{for(i in n){print n[i] "\t" i}}' | sort -nrk1

Result:

591.206 c8rska9493**********
254.092 c8rk36jv5n**********
93.4481 a7l9vsb1bt**********
...
0.742366 fdv0u8gkl**********
0.694901 c8rhi3km7**********
0.545707 a7l7fb0at**********