Need help to understand Redshift Serverless costs

0

I'm using Redshift Serverless to run some tests, but I don't understand how it's being billed. I'm still on the Free Tier $300, but already used almost $50 of those, and according to my calculations, the cost should be less than $2 so far.

Enter image description here

I understand that Redshift Serverless is billed for RPU and Storage. But when I check the usage using:

select
  date_trunc('day', start_time) usage_date,
  sum(compute_seconds) total_compute_seconds,
  sum(compute_seconds)/(60*60) total_compute_hours,
  total_compute_hours*0.375 total_compute_cost
from sys_serverless_usage
group by date_trunc('day', start_time);

Result shows that the cost should be less than $2 so far: Enter image description here

Storage doesn't seem to be the cost either, as the cost of it shows $0 so far, using:

SELECT date_trunc('day', start_time) usage_date,
SUM((data_storage/(1024*1024*1024))*(datediff(s,start_time,end_time)/3600.0)) AS GB_hours,
GB_hours / 720 AS GB_months,
GB_months*0.024 AS storage_cost_day
FROM sys_serverless_usage
GROUP BY 1 ORDER BY 1;

I need help to understand where the money is going, if there is some fixed cost or how is it draining so fast?

I also tried to find Redshift Serverless on the Billing section, but it doesn't seem to be there (maybe cause it's still under the Free Tier, but some services show up there even when cost is $0)

Thanks in advance!

已提問 2 年前檢視次數 266 次
2 個答案
0

Hi,

To compute the actual cost you need to look at the column charged_seconds instead of compute_seconds. Here's an updated query:

select
  date_trunc('day', start_time) usage_date,
  sum(compute_seconds) total_compute_seconds,
  sum(compute_seconds)/(60*60) total_compute_hours,
  sum(charged_seconds) total_charged_dpu_seconds,
  sum(charged_seconds)/(60*60) total_charged_dpu_hours,
  total_charged_dpu_hours*0.36 total_compute_cost
from sys_serverless_usage
group by date_trunc('day', start_time);

The difference between both columns is that charged_seconds is compute_seconds multiplied by the RPUs used, and rounded up to a minute.

Hope this helps, Fran

已回答 6 個月前
-1

Hi there,

I'm sorry to hear about this frustrating experience.

Our Billing team can look into this for you. I would recommend creating a support case here: http://go.aws/support-center.

Hope this helps,

— Aimee K.

AWS
專家
已回答 2 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南