Query: elasticache_shard_details

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);