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!

asked 2 years ago264 views
2 Answers
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

answered 6 months ago
-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
EXPERT
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions