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!

posta 2 anni fa266 visualizzazioni
2 Risposte
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

con risposta 6 mesi fa
-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
ESPERTO
con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande