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!

preguntada hace 2 años266 visualizaciones
2 Respuestas
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

respondido hace 6 meses
-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
EXPERTO
respondido hace 2 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas