Skip to content
AWS for Query.Farm

aws.ce.get_rightsizing_recommendation

Example SQL Queries

SELECT * FROM
aws.ce.get_rightsizing_recommendation
WHERE
"service" = 'VALUE';

Description

Creates recommendations that help you save cost by identifying idle and underutilized Amazon EC2 instances.

Recommendations are generated to either downsize or terminate instances, along with providing savings detail and metrics. For more information about calculation and function, see Optimizing Your Cost with Rightsizing Recommendations in the Billing and Cost Management User Guide.

Table Definition

Column NameColumn Data Type
service Required Input Column

The specific service that you want recommendations for. The only valid value for GetRightsizingRecommendation is "AmazonEC2".

VARCHAR
configuration Input Column

You can use Configuration to customize recommendations across two attributes. You can choose to view recommendations for instances within the same instance families or across different instance families. You can also choose to view your estimated savings that are associated with recommendations with consideration of existing Savings Plans or RI benefits, or neither. 

STRUCT(
    "recommendation_target" VARCHAR,
    "benefits_considered" BOOLEAN
)
Show child fields
configuration.benefits_considered

The option to consider RI or Savings Plans discount benefits in your savings calculation. The default value is TRUE.

configuration.recommendation_target

The option to see recommendations within the same instance family or recommendations for instances across other families. The default value is SAME_INSTANCE_FAMILY.

filter Input Column

Use Expression to filter in various Cost Explorer APIs.

Not all Expression types are supported in each API. Refer to the documentation for each specific API to see what is supported.

There are two patterns:

  • Simple dimension values.

    • There are three types of simple dimension values: CostCategories, Tags, and Dimensions.

      • Specify the CostCategories field to define a filter that acts on Cost Categories.

      • Specify the Tags field to define a filter that acts on Cost Allocation Tags.

      • Specify the Dimensions field to define a filter that acts on the DimensionValues .

    • For each filter type, you can set the dimension name and values for the filters that you plan to use.

      • For example, you can filter for REGION==us-east-1 OR REGION==us-west-1. For GetRightsizingRecommendation, the Region is a full name (for example, REGION==US East (N. Virginia).

      • The corresponding Expression for this example is as follows: { "Dimensions": { "Key": "REGION", "Values": [ "us-east-1", "us-west-1" ] } }

      • As shown in the previous example, lists of dimension values are combined with OR when applying the filter.

    • You can also set different match options to further control how the filter behaves. Not all APIs support match options. Refer to the documentation for each specific API to see what is supported.

      • For example, you can filter for linked account names that start with "a".

      • The corresponding Expression for this example is as follows: { "Dimensions": { "Key": "LINKED_ACCOUNT_NAME", "MatchOptions": [ "STARTS_WITH" ], "Values": [ "a" ] } }

  • Compound Expression types with logical operations.

    • You can use multiple Expression types and the logical operators AND/OR/NOT to create a list of one or more Expression objects. By doing this, you can filter by more advanced options.

    • For example, you can filter by ((REGION == us-east-1 OR REGION == us-west-1) OR (TAG.Type == Type1)) AND (USAGE_TYPE != DataTransfer).

    • The corresponding Expression for this example is as follows: { "And": [ {"Or": [ {"Dimensions": { "Key": "REGION", "Values": [ "us-east-1", "us-west-1" ] }}, {"Tags": { "Key": "TagName", "Values": ["Value1"] } } ]}, {"Not": {"Dimensions": { "Key": "USAGE_TYPE", "Values": ["DataTransfer"] }}} ] }

    Because each Expression can have only one operator, the service returns an error if more than one is specified. The following example shows an Expression object that creates an error: { "And": [ ... ], "Dimensions": { "Key": "USAGE_TYPE", "Values": [ "DataTransfer" ] } }

    The following is an example of the corresponding error message: "Expression has more than one roots. Only one root operator is allowed for each expression: And, Or, Not, Dimensions, Tags, CostCategories"

For the GetRightsizingRecommendation action, a combination of OR and NOT isn't supported. OR isn't supported between different dimensions, or dimensions and tags. NOT operators aren't supported. Dimensions are also limited to LINKED_ACCOUNT, REGION, or RIGHTSIZING_TYPE.

For the GetReservationPurchaseRecommendation action, only NOT is supported. AND and OR aren't supported. Dimensions are limited to LINKED_ACCOUNT.

STRUCT(
    "dimensions" STRUCT(
        "key" VARCHAR,
        "values" VARCHAR[],
        "match_options" VARCHAR[]
    ),
    "tags" STRUCT(
        "key" VARCHAR,
        "values" VARCHAR[],
        "match_options" VARCHAR[]
    ),
    "cost_categories" STRUCT(
        "key" VARCHAR,
        "values" VARCHAR[],
        "match_options" VARCHAR[]
    )
)
Show child fields
filter.cost_categories

The filter that's based on CostCategory values.

Show child fields
filter.cost_categories.key

The unique name of the Cost Category.

filter.cost_categories.match_options[]
filter.cost_categories.values[]
filter.dimensions

The specific Dimension to use for Expression.

Show child fields
filter.dimensions.key

The names of the metadata types that you can use to filter and group your results. For example, AZ returns a list of Availability Zones.

Not all dimensions are supported in each API. Refer to the documentation for each specific API to see what is supported.

LINK_ACCOUNT_NAME and SERVICE_CODE can only be used in CostCategoryRule.

ANOMALY_TOTAL_IMPACT_ABSOLUTE and ANOMALY_TOTAL_IMPACT_PERCENTAGE can only be used in AnomalySubscriptions.

filter.dimensions.match_options[]
filter.dimensions.values[]
filter.tags

The specific Tag to use for Expression.

Show child fields
filter.tags.key

The key for the tag.

filter.tags.match_options[]
filter.tags.values[]
next_page_token Input Column

The token to retrieve the next set of results.

VARCHAR
page_size Input Column

The number of recommendations that you want returned in a single response object.

BIGINT
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

metadata

Information regarding this specific recommendation set.

STRUCT(
    "recommendation_id" VARCHAR,
    "generation_timestamp" VARCHAR,
    "lookback_period_in_days" VARCHAR,
    "additional_metadata" VARCHAR
)
Show child fields
metadata.additional_metadata

Additional metadata that might be applicable to the recommendation.

metadata.generation_timestamp

The timestamp for when Amazon Web Services made the recommendation.

metadata.lookback_period_in_days

The number of days of previous usage that Amazon Web Services considers when making the recommendation.

metadata.recommendation_id

The ID for the recommendation.

rightsizing_recommendations

Recommendations to rightsize resources.

STRUCT(
    "account_id" VARCHAR,
    "current_instance" STRUCT(
        "resource_id" VARCHAR,
        "instance_name" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "values" VARCHAR[],
            "match_options" VARCHAR[]
        )[],
        "resource_details" STRUCT(
            "ec2_resource_details" STRUCT(
                "hourly_on_demand_rate" VARCHAR,
                "instance_type" VARCHAR,
                "platform" VARCHAR,
                "region" VARCHAR,
                "sku" VARCHAR,
                "memory" VARCHAR,
                "network_performance" VARCHAR,
                "storage" VARCHAR,
                "vcpu" VARCHAR
            )
        ),
        "resource_utilization" STRUCT(
            "ec2_resource_utilization" STRUCT(
                "max_cpu_utilization_percentage" VARCHAR,
                "max_memory_utilization_percentage" VARCHAR,
                "max_storage_utilization_percentage" VARCHAR,
                "ebs_resource_utilization" STRUCT(
                    "ebs_read_ops_per_second" VARCHAR,
                    "ebs_write_ops_per_second" VARCHAR,
                    "ebs_read_bytes_per_second" VARCHAR,
                    "ebs_write_bytes_per_second" VARCHAR
                ),
                "disk_resource_utilization" STRUCT(
                    "disk_read_ops_per_second" VARCHAR,
                    "disk_write_ops_per_second" VARCHAR,
                    "disk_read_bytes_per_second" VARCHAR,
                    "disk_write_bytes_per_second" VARCHAR
                ),
                "network_resource_utilization" STRUCT(
                    "network_in_bytes_per_second" VARCHAR,
                    "network_out_bytes_per_second" VARCHAR,
                    "network_packets_in_per_second" VARCHAR,
                    "network_packets_out_per_second" VARCHAR
                )
            )
        ),
        "reservation_covered_hours_in_lookback_period" VARCHAR,
        "savings_plans_covered_hours_in_lookback_period" VARCHAR,
        "on_demand_hours_in_lookback_period" VARCHAR,
        "total_running_hours_in_lookback_period" VARCHAR,
        "monthly_cost" VARCHAR,
        "currency_code" VARCHAR
    ),
    "rightsizing_type" VARCHAR,
    "modify_recommendation_detail" STRUCT(
        "target_instances" STRUCT(
            "estimated_monthly_cost" VARCHAR,
            "estimated_monthly_savings" VARCHAR,
            "currency_code" VARCHAR,
            "default_target_instance" BOOLEAN,
            "resource_details" STRUCT(
                "ec2_resource_details" STRUCT(
                    "hourly_on_demand_rate" VARCHAR,
                    "instance_type" VARCHAR,
                    "platform" VARCHAR,
                    "region" VARCHAR,
                    "sku" VARCHAR,
                    "memory" VARCHAR,
                    "network_performance" VARCHAR,
                    "storage" VARCHAR,
                    "vcpu" VARCHAR
                )
            ),
            "expected_resource_utilization" STRUCT(
                "ec2_resource_utilization" STRUCT(
                    "max_cpu_utilization_percentage" VARCHAR,
                    "max_memory_utilization_percentage" VARCHAR,
                    "max_storage_utilization_percentage" VARCHAR,
                    "ebs_resource_utilization" STRUCT(
                        "ebs_read_ops_per_second" VARCHAR,
                        "ebs_write_ops_per_second" VARCHAR,
                        "ebs_read_bytes_per_second" VARCHAR,
                        "ebs_write_bytes_per_second" VARCHAR
                    ),
                    "disk_resource_utilization" STRUCT(
                        "disk_read_ops_per_second" VARCHAR,
                        "disk_write_ops_per_second" VARCHAR,
                        "disk_read_bytes_per_second" VARCHAR,
                        "disk_write_bytes_per_second" VARCHAR
                    ),
                    "network_resource_utilization" STRUCT(
                        "network_in_bytes_per_second" VARCHAR,
                        "network_out_bytes_per_second" VARCHAR,
                        "network_packets_in_per_second" VARCHAR,
                        "network_packets_out_per_second" VARCHAR
                    )
                )
            ),
            "platform_differences" VARCHAR[]
        )[]
    ),
    "terminate_recommendation_detail" STRUCT(
        "estimated_monthly_savings" VARCHAR,
        "currency_code" VARCHAR
    ),
    "finding_reason_codes" VARCHAR[]
)[]
Show child fields
rightsizing_recommendations[]
Show child fields
rightsizing_recommendations[].account_id

The account that this recommendation is for.

rightsizing_recommendations[].current_instance

Context regarding the current instance.

Show child fields
rightsizing_recommendations[].current_instance.currency_code

The currency code that Amazon Web Services used to calculate the costs for this instance.

rightsizing_recommendations[].current_instance.instance_name

The name that you given an instance. This field shows as blank if you haven't given the instance a name.

rightsizing_recommendations[].current_instance.monthly_cost

The current On-Demand cost of operating this instance on a monthly basis.

rightsizing_recommendations[].current_instance.on_demand_hours_in_lookback_period

The number of hours during the lookback period that's billed at On-Demand rates.

rightsizing_recommendations[].current_instance.reservation_covered_hours_in_lookback_period

The number of hours during the lookback period that's covered by reservations.

rightsizing_recommendations[].current_instance.resource_details

Details about the resource and utilization.

Show child fields
rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details

Details for the Amazon EC2 resource.

Show child fields
rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.hourly_on_demand_rate

The hourly public On-Demand rate for the instance type.

rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.instance_type

The type of Amazon Web Services instance.

rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.memory

The memory capacity of the Amazon Web Services instance.

rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.network_performance

The network performance capacity of the Amazon Web Services instance.

rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.platform

The platform of the Amazon Web Services instance. The platform is the specific combination of operating system, license model, and software on an instance.

rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.region

The Amazon Web Services Region of the instance.

rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.sku

The SKU of the product.

rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.storage

The disk storage of the Amazon Web Services instance. This doesn't include EBS storage.

rightsizing_recommendations[].current_instance.resource_details.ec2_resource_details.vcpu

The number of VCPU cores in the Amazon Web Services instance type.

rightsizing_recommendations[].current_instance.resource_id

Resource ID of the current instance.

rightsizing_recommendations[].current_instance.resource_utilization

Utilization information of the current instance during the lookback period.

Show child fields
rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization

The utilization of current Amazon EC2 instance.

Show child fields
rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.disk_resource_utilization

The field that contains a list of disk (local storage) metrics that are associated with the current instance.

Show child fields
rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.disk_resource_utilization.disk_read_bytes_per_second

The maximum read throughput operations per second.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.disk_resource_utilization.disk_read_ops_per_second

The maximum number of read operations per second.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.disk_resource_utilization.disk_write_bytes_per_second

The maximum write throughput operations per second.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.disk_resource_utilization.disk_write_ops_per_second

The maximum number of write operations per second.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.ebs_resource_utilization

The EBS field that contains a list of EBS metrics that are associated with the current instance.

Show child fields
rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.ebs_resource_utilization.ebs_read_bytes_per_second

The maximum size of read operations per second

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.ebs_resource_utilization.ebs_read_ops_per_second

The maximum number of read operations per second.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.ebs_resource_utilization.ebs_write_bytes_per_second

The maximum size of write operations per second.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.ebs_resource_utilization.ebs_write_ops_per_second

The maximum number of write operations per second.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.max_cpu_utilization_percentage

The maximum observed or expected CPU utilization of the instance.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.max_memory_utilization_percentage

The maximum observed or expected memory utilization of the instance.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.max_storage_utilization_percentage

The maximum observed or expected storage utilization of the instance. This doesn't include EBS storage.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.network_resource_utilization

The network field that contains a list of network metrics that are associated with the current instance.

Show child fields
rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.network_resource_utilization.network_in_bytes_per_second

The network inbound throughput utilization measured in Bytes per second (Bps).

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.network_resource_utilization.network_out_bytes_per_second

The network outbound throughput utilization measured in Bytes per second (Bps).

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.network_resource_utilization.network_packets_in_per_second

The network inbound packets that are measured in packets per second.

rightsizing_recommendations[].current_instance.resource_utilization.ec2_resource_utilization.network_resource_utilization.network_packets_out_per_second

The network outbound packets that are measured in packets per second.

rightsizing_recommendations[].current_instance.savings_plans_covered_hours_in_lookback_period

The number of hours during the lookback period that's covered by Savings Plans.

rightsizing_recommendations[].current_instance.tags[]
Show child fields
rightsizing_recommendations[].current_instance.tags[].key

The key for the tag.

rightsizing_recommendations[].current_instance.tags[].match_options[]
rightsizing_recommendations[].current_instance.tags[].values[]
rightsizing_recommendations[].current_instance.total_running_hours_in_lookback_period

The total number of hours that the instance ran during the lookback period.

rightsizing_recommendations[].finding_reason_codes[]
rightsizing_recommendations[].modify_recommendation_detail

The details for the modification recommendations.

Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[]
Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].currency_code

The currency code that Amazon Web Services used to calculate the costs for this instance.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].default_target_instance

Determines whether this recommendation is the defaulted Amazon Web Services recommendation.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].estimated_monthly_cost

The expected cost to operate this instance type on a monthly basis.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].estimated_monthly_savings

The estimated savings that result from modification, on a monthly basis.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization

The expected utilization metrics for target instance type.

Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization

The utilization of current Amazon EC2 instance.

Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.disk_resource_utilization

The field that contains a list of disk (local storage) metrics that are associated with the current instance.

Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.disk_resource_utilization.disk_read_bytes_per_second

The maximum read throughput operations per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.disk_resource_utilization.disk_read_ops_per_second

The maximum number of read operations per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.disk_resource_utilization.disk_write_bytes_per_second

The maximum write throughput operations per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.disk_resource_utilization.disk_write_ops_per_second

The maximum number of write operations per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.ebs_resource_utilization

The EBS field that contains a list of EBS metrics that are associated with the current instance.

Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.ebs_resource_utilization.ebs_read_bytes_per_second

The maximum size of read operations per second

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.ebs_resource_utilization.ebs_read_ops_per_second

The maximum number of read operations per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.ebs_resource_utilization.ebs_write_bytes_per_second

The maximum size of write operations per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.ebs_resource_utilization.ebs_write_ops_per_second

The maximum number of write operations per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.max_cpu_utilization_percentage

The maximum observed or expected CPU utilization of the instance.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.max_memory_utilization_percentage

The maximum observed or expected memory utilization of the instance.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.max_storage_utilization_percentage

The maximum observed or expected storage utilization of the instance. This doesn't include EBS storage.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.network_resource_utilization

The network field that contains a list of network metrics that are associated with the current instance.

Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.network_resource_utilization.network_in_bytes_per_second

The network inbound throughput utilization measured in Bytes per second (Bps).

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.network_resource_utilization.network_out_bytes_per_second

The network outbound throughput utilization measured in Bytes per second (Bps).

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.network_resource_utilization.network_packets_in_per_second

The network inbound packets that are measured in packets per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].expected_resource_utilization.ec2_resource_utilization.network_resource_utilization.network_packets_out_per_second

The network outbound packets that are measured in packets per second.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].platform_differences[]
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details

Details on the target instance type.

Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details

Details for the Amazon EC2 resource.

Show child fields
rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.hourly_on_demand_rate

The hourly public On-Demand rate for the instance type.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.instance_type

The type of Amazon Web Services instance.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.memory

The memory capacity of the Amazon Web Services instance.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.network_performance

The network performance capacity of the Amazon Web Services instance.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.platform

The platform of the Amazon Web Services instance. The platform is the specific combination of operating system, license model, and software on an instance.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.region

The Amazon Web Services Region of the instance.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.sku

The SKU of the product.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.storage

The disk storage of the Amazon Web Services instance. This doesn't include EBS storage.

rightsizing_recommendations[].modify_recommendation_detail.target_instances[].resource_details.ec2_resource_details.vcpu

The number of VCPU cores in the Amazon Web Services instance type.

rightsizing_recommendations[].rightsizing_type

A recommendation to either terminate or modify the resource.

rightsizing_recommendations[].terminate_recommendation_detail

The details for termination recommendations.

Show child fields
rightsizing_recommendations[].terminate_recommendation_detail.currency_code

The currency code that Amazon Web Services used to calculate the costs for this instance.

rightsizing_recommendations[].terminate_recommendation_detail.estimated_monthly_savings

The estimated savings that result from modification, on a monthly basis.

summary

Summary of this recommendation set.

STRUCT(
    "total_recommendation_count" VARCHAR,
    "estimated_total_monthly_savings_amount" VARCHAR,
    "savings_currency_code" VARCHAR,
    "savings_percentage" VARCHAR
)
Show child fields
summary.estimated_total_monthly_savings_amount

The estimated total savings resulting from modifications, on a monthly basis.

summary.savings_currency_code

The currency code that Amazon Web Services used to calculate the savings.

summary.savings_percentage

The savings percentage based on the recommended modifications. It's relative to the total On-Demand costs that are associated with these instances.

summary.total_recommendation_count

The total number of instance recommendations.