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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인