turbot/aws_insights

Query: elasticache_cluster_node_cost_per_month

Usage

powerpipe query aws_insights.query.elasticache_cluster_node_cost_per_month

SQL

select
to_char(period_start, 'Mon-YY') as "Month",
sum(unblended_cost_amount) as "Unblended Cost"
from
aws_cost_by_service_usage_type_monthly
where
service = 'Amazon ElastiCache'
and usage_type like '%NodeUsage:cache%'
group by
period_start
order by
period_start;

Dashboards

The query is used in the dashboards: