Hello Experts,
We have one non prod DB cluster in aurora postgres. We are seeing the daily cost for the RDS instance is appearing as ~$300 even we perform no activity on that database. Is there any way to further dig down and see what all queries or functions inside the database is actually contributing to these ~300$ amount?
We were initially thinking if the database backup is costing so much as the database size is ~15TB and we have 7 days backup retention set. But the cost explorer showing the cost under service "backup" as ~$2 only per day. And what should be the backup retention should we set, as it seems its occupying full DB snap each day in the storage and setting the retention for longer period (~35days for e.g.) is going to cost us more?
Aurora Serverless v2: Minimum Cost Setup for Development Environment
Aurora Serverless v2 vs RDS cost comparison?
RDS vs Aurora big price difference
Hello, PM for Amazon RDS and Aurora here.
We recommend Amazon Aurora Serverless for bursty workloads that spike up/down frequently. Think an e-commerce website which gets a lot of traffic on weekends and nothing on weekdays. Our customers love not having to scale the database to account for the surge or drop in traffic.
Amazon RDS and "regular" Amazon Aurora are for workloads that need sustained throughput. Think a search website which gets traffic throughout the day/week etc.
Hope that helps!
More on reddit.com