Control: What provisioned IOPS volumes would be better as GP3?
Description
GP3 provides 16k base IOPS performance, don't use more costly io1 & io2 volumes.
Usage
Run the control in your terminal:
powerpipe control run aws_thrifty.control.low_iops_ebs_volumes
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run aws_thrifty.control.low_iops_ebs_volumes --share
Steampipe Tables
SQL
select arn as resource, case when volume_type not in ('io1', 'io2') then 'skip' when iops <= 16000 then 'alarm' else 'ok' end as status, case when volume_type not in ('io1', 'io2') then volume_id || ' type is ' || volume_type || '.' when iops <= 16000 then volume_id || ' only has ' || iops || ' iops.' else volume_id || ' has ' || iops || ' iops.' end as reason , region, account_idfrom aws_ebs_volume;