turbot/aws_insights

Query: elasticache_shard_details

Usage

powerpipe query aws_insights.query.elasticache_shard_details

SQL

select
rg.title || '-' || (ng ->> 'NodeGroupId') as "ID",
jsonb_array_length(ng -> 'NodeGroupMembers') as "Members",
(ng -> 'PrimaryEndpoint' ->> 'Address') || ':' || (ng -> 'PrimaryEndpoint' ->> 'Port') as "Primary Endpoint",
(ng -> 'ReaderEndpoint' ->> 'Address') || ':' || (ng -> 'ReaderEndpoint' ->> 'Port') as "Reader Endpoint",
ng ->> 'Slots' as "Slots",
ng ->> 'Status' as "Status"
from
aws_elasticache_replication_group rg,
jsonb_array_elements(node_groups) ng
where
arn = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);

Dashboards

The query is used in the dashboards: