Skip to content
AWS for Query.Farm

aws.ec2.describe_instance_types

Example SQL Queries

SELECT * FROM
aws.ec2.describe_instance_types;

Description

Describes the specified instance types. By default, all instance types for the current Region are described. Alternatively, you can filter the results.

Table Definition

Column NameColumn Data Type
dry_run Input Column

Checks whether you have the required permissions for the action, without actually making the request, and provides an error response. If you have the required permissions, the error response is DryRunOperation. Otherwise, it is UnauthorizedOperation.

BOOLEAN
filters Input Column

One or more filters. Filter names and values are case-sensitive.

  • auto-recovery-supported - Indicates whether Amazon CloudWatch action based recovery is supported (true | false).

  • bare-metal - Indicates whether it is a bare metal instance type (true | false).

  • burstable-performance-supported - Indicates whether the instance type is a burstable performance T instance type (true | false).

  • current-generation - Indicates whether this instance type is the latest generation instance type of an instance family (true | false).

  • ebs-info.ebs-optimized-info.baseline-bandwidth-in-mbps - The baseline bandwidth performance for an EBS-optimized instance type, in Mbps.

  • ebs-info.ebs-optimized-info.baseline-iops - The baseline input/output storage operations per second for an EBS-optimized instance type.

  • ebs-info.ebs-optimized-info.baseline-throughput-in-mbps - The baseline throughput performance for an EBS-optimized instance type, in MB/s.

  • ebs-info.ebs-optimized-info.maximum-bandwidth-in-mbps - The maximum bandwidth performance for an EBS-optimized instance type, in Mbps.

  • ebs-info.ebs-optimized-info.maximum-iops - The maximum input/output storage operations per second for an EBS-optimized instance type.

  • ebs-info.ebs-optimized-info.maximum-throughput-in-mbps - The maximum throughput performance for an EBS-optimized instance type, in MB/s.

  • ebs-info.ebs-optimized-support - Indicates whether the instance type is EBS-optimized (supported | unsupported | default).

  • ebs-info.encryption-support - Indicates whether EBS encryption is supported (supported | unsupported).

  • ebs-info.nvme-support - Indicates whether non-volatile memory express (NVMe) is supported for EBS volumes (required | supported | unsupported).

  • free-tier-eligible - Indicates whether the instance type is eligible to use in the free tier (true | false).

  • hibernation-supported - Indicates whether On-Demand hibernation is supported (true | false).

  • hypervisor - The hypervisor (nitro | xen).

  • instance-storage-info.disk.count - The number of local disks.

  • instance-storage-info.disk.size-in-gb - The storage size of each instance storage disk, in GB.

  • instance-storage-info.disk.type - The storage technology for the local instance storage disks (hdd | ssd).

  • instance-storage-info.encryption-support - Indicates whether data is encrypted at rest (required | supported | unsupported).

  • instance-storage-info.nvme-support - Indicates whether non-volatile memory express (NVMe) is supported for instance store (required | supported | unsupported).

  • instance-storage-info.total-size-in-gb - The total amount of storage available from all local instance storage, in GB.

  • instance-storage-supported - Indicates whether the instance type has local instance storage (true | false).

  • instance-type - The instance type (for example c5.2xlarge or c5*).

  • memory-info.size-in-mib - The memory size.

  • network-info.efa-info.maximum-efa-interfaces - The maximum number of Elastic Fabric Adapters (EFAs) per instance.

  • network-info.efa-supported - Indicates whether the instance type supports Elastic Fabric Adapter (EFA) (true | false).

  • network-info.ena-support - Indicates whether Elastic Network Adapter (ENA) is supported or required (required | supported | unsupported).

  • network-info.encryption-in-transit-supported - Indicates whether the instance type automatically encrypts in-transit traffic between instances (true | false).

  • network-info.ipv4-addresses-per-interface - The maximum number of private IPv4 addresses per network interface.

  • network-info.ipv6-addresses-per-interface - The maximum number of private IPv6 addresses per network interface.

  • network-info.ipv6-supported - Indicates whether the instance type supports IPv6 (true | false).

  • network-info.maximum-network-cards - The maximum number of network cards per instance.

  • network-info.maximum-network-interfaces - The maximum number of network interfaces per instance.

  • network-info.network-performance - The network performance (for example, "25 Gigabit").

  • nitro-enclaves-support - Indicates whether Nitro Enclaves is supported (supported | unsupported).

  • nitro-tpm-support - Indicates whether NitroTPM is supported (supported | unsupported).

  • nitro-tpm-info.supported-versions - The supported NitroTPM version (2.0).

  • processor-info.supported-architecture - The CPU architecture (arm64 | i386 | x86_64).

  • processor-info.sustained-clock-speed-in-ghz - The CPU clock speed, in GHz.

  • processor-info.supported-features - The supported CPU features (amd-sev-snp).

  • supported-boot-mode - The boot mode (legacy-bios | uefi).

  • supported-root-device-type - The root device type (ebs | instance-store).

  • supported-usage-class - The usage class (on-demand | spot).

  • supported-virtualization-type - The virtualization type (hvm | paravirtual).

  • vcpu-info.default-cores - The default number of cores for the instance type.

  • vcpu-info.default-threads-per-core - The default number of threads per core for the instance type.

  • vcpu-info.default-vcpus - The default number of vCPUs for the instance type.

  • vcpu-info.valid-cores - The number of cores that can be configured for the instance type.

  • vcpu-info.valid-threads-per-core - The number of threads per core that can be configured for the instance type. For example, "1" or "1,2".

STRUCT(
    "name" VARCHAR,
    "values" VARCHAR[]
)[]
Show child fields
filters[]
Show child fields
filters[].name

The name of the filter. Filter names are case-sensitive.

filters[].values[]
instance_types Input Column

The instance types.

VARCHAR[]
Show child fields
instance_types[]
_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.

_aws_region Input Column

The AWS region to use.

VARCHAR
auto_recovery_supported

Indicates whether Amazon CloudWatch action based recovery is supported.

BOOLEAN
bare_metal

Indicates whether the instance is a bare metal instance type.

BOOLEAN
burstable_performance_supported

Indicates whether the instance type is a burstable performance T instance type. For more information, see Burstable performance instances.

BOOLEAN
current_generation

Indicates whether the instance type is current generation.

BOOLEAN
dedicated_hosts_supported

Indicates whether Dedicated Hosts are supported on the instance type.

BOOLEAN
ebs_info

Describes the Amazon EBS settings for the instance type.

STRUCT(
    "ebs_optimized_support" VARCHAR,
    "encryption_support" VARCHAR,
    "ebs_optimized_info" STRUCT(
        "baseline_bandwidth_in_mbps" BIGINT,
        "baseline_throughput_in_m_bps" DOUBLE,
        "baseline_iops" BIGINT,
        "maximum_bandwidth_in_mbps" BIGINT,
        "maximum_throughput_in_m_bps" DOUBLE,
        "maximum_iops" BIGINT
    ),
    "nvme_support" VARCHAR
)
Show child fields
ebs_info.ebs_optimized_info

Describes the optimized EBS performance for the instance type.

Show child fields
ebs_info.ebs_optimized_info.baseline_bandwidth_in_mbps

The baseline bandwidth performance for an EBS-optimized instance type, in Mbps.

ebs_info.ebs_optimized_info.baseline_iops

The baseline input/output storage operations per seconds for an EBS-optimized instance type.

ebs_info.ebs_optimized_info.baseline_throughput_in_m_bps

The baseline throughput performance for an EBS-optimized instance type, in MB/s.

ebs_info.ebs_optimized_info.maximum_bandwidth_in_mbps

The maximum bandwidth performance for an EBS-optimized instance type, in Mbps.

ebs_info.ebs_optimized_info.maximum_iops

The maximum input/output storage operations per second for an EBS-optimized instance type.

ebs_info.ebs_optimized_info.maximum_throughput_in_m_bps

The maximum throughput performance for an EBS-optimized instance type, in MB/s.

ebs_info.ebs_optimized_support

Indicates whether the instance type is Amazon EBS-optimized. For more information, see Amazon EBS-optimized instances in Amazon EC2 User Guide.

ebs_info.encryption_support

Indicates whether Amazon EBS encryption is supported.

ebs_info.nvme_support

Indicates whether non-volatile memory express (NVMe) is supported.

fpga_info

Describes the FPGA accelerator settings for the instance type.

STRUCT(
    "fpgas" STRUCT(
        "name" VARCHAR,
        "manufacturer" VARCHAR,
        "count" BIGINT,
        "memory_info" STRUCT(
            "size_in_mi_b" BIGINT
        )
    )[],
    "total_fpga_memory_in_mi_b" BIGINT
)
Show child fields
fpga_info.fpgas[]
Show child fields
fpga_info.fpgas[].count

The count of FPGA accelerators for the instance type.

fpga_info.fpgas[].manufacturer

The manufacturer of the FPGA accelerator.

fpga_info.fpgas[].memory_info

Describes the memory for the FPGA accelerator for the instance type.

Show child fields
fpga_info.fpgas[].memory_info.size_in_mi_b

The size of the memory available to the FPGA accelerator, in MiB.

fpga_info.fpgas[].name

The name of the FPGA accelerator.

fpga_info.total_fpga_memory_in_mi_b

The total memory of all FPGA accelerators for the instance type.

free_tier_eligible

Indicates whether the instance type is eligible for the free tier.

BOOLEAN
gpu_info

Describes the GPU accelerator settings for the instance type.

STRUCT(
    "gpus" STRUCT(
        "name" VARCHAR,
        "manufacturer" VARCHAR,
        "count" BIGINT,
        "memory_info" STRUCT(
            "size_in_mi_b" BIGINT
        )
    )[],
    "total_gpu_memory_in_mi_b" BIGINT
)
Show child fields
gpu_info.gpus[]
Show child fields
gpu_info.gpus[].count

The number of GPUs for the instance type.

gpu_info.gpus[].manufacturer

The manufacturer of the GPU accelerator.

gpu_info.gpus[].memory_info

Describes the memory available to the GPU accelerator.

Show child fields
gpu_info.gpus[].memory_info.size_in_mi_b

The size of the memory available to the GPU accelerator, in MiB.

gpu_info.gpus[].name

The name of the GPU accelerator.

gpu_info.total_gpu_memory_in_mi_b

The total size of the memory for the GPU accelerators for the instance type, in MiB.

hibernation_supported

Indicates whether On-Demand hibernation is supported.

BOOLEAN
hypervisor

The hypervisor for the instance type.

VARCHAR
inference_accelerator_info

Describes the Inference accelerator settings for the instance type.

STRUCT(
    "accelerators" STRUCT(
        "count" BIGINT,
        "name" VARCHAR,
        "manufacturer" VARCHAR,
        "memory_info" STRUCT(
            "size_in_mi_b" BIGINT
        )
    )[],
    "total_inference_memory_in_mi_b" BIGINT
)
Show child fields
inference_accelerator_info.accelerators[]
Show child fields
inference_accelerator_info.accelerators[].count

The number of Inference accelerators for the instance type.

inference_accelerator_info.accelerators[].manufacturer

The manufacturer of the Inference accelerator.

inference_accelerator_info.accelerators[].memory_info

Describes the memory available to the inference accelerator.

Show child fields
inference_accelerator_info.accelerators[].memory_info.size_in_mi_b

The size of the memory available to the inference accelerator, in MiB.

inference_accelerator_info.accelerators[].name

The name of the Inference accelerator.

inference_accelerator_info.total_inference_memory_in_mi_b

The total size of the memory for the inference accelerators for the instance type, in MiB.

instance_storage_info

Describes the instance storage for the instance type.

STRUCT(
    "total_size_in_gb" BIGINT,
    "disks" STRUCT(
        "size_in_gb" BIGINT,
        "count" BIGINT,
        "type" VARCHAR
    )[],
    "nvme_support" VARCHAR,
    "encryption_support" VARCHAR
)
Show child fields
instance_storage_info.disks[]
Show child fields
instance_storage_info.disks[].count

The number of disks with this configuration.

instance_storage_info.disks[].size_in_gb

The size of the disk in GB.

instance_storage_info.disks[].type

The type of disk.

instance_storage_info.encryption_support

Indicates whether data is encrypted at rest.

instance_storage_info.nvme_support

Indicates whether non-volatile memory express (NVMe) is supported.

instance_storage_info.total_size_in_gb

The total size of the disks, in GB.

instance_storage_supported

Indicates whether instance storage is supported.

BOOLEAN
instance_type

The instance type. For more information, see Instance types in the Amazon EC2 User Guide.

VARCHAR
media_accelerator_info

Describes the media accelerator settings for the instance type.

STRUCT(
    "accelerators" STRUCT(
        "count" BIGINT,
        "name" VARCHAR,
        "manufacturer" VARCHAR,
        "memory_info" STRUCT(
            "size_in_mi_b" BIGINT
        )
    )[],
    "total_media_memory_in_mi_b" BIGINT
)
Show child fields
media_accelerator_info.accelerators[]
Show child fields
media_accelerator_info.accelerators[].count

The number of media accelerators for the instance type.

media_accelerator_info.accelerators[].manufacturer

The manufacturer of the media accelerator.

media_accelerator_info.accelerators[].memory_info

Describes the memory available to the media accelerator.

Show child fields
media_accelerator_info.accelerators[].memory_info.size_in_mi_b

The size of the memory available to each media accelerator, in MiB.

media_accelerator_info.accelerators[].name

The name of the media accelerator.

media_accelerator_info.total_media_memory_in_mi_b

The total size of the memory for the media accelerators for the instance type, in MiB.

memory_info

Describes the memory for the instance type.

STRUCT(
    "size_in_mi_b" BIGINT
)
Show child fields
memory_info.size_in_mi_b

The size of the memory, in MiB.

network_info

Describes the network settings for the instance type.

STRUCT(
    "network_performance" VARCHAR,
    "maximum_network_interfaces" BIGINT,
    "maximum_network_cards" BIGINT,
    "default_network_card_index" BIGINT,
    "network_cards" STRUCT(
        "network_card_index" BIGINT,
        "network_performance" VARCHAR,
        "maximum_network_interfaces" BIGINT,
        "baseline_bandwidth_in_gbps" DOUBLE,
        "peak_bandwidth_in_gbps" DOUBLE
    )[],
    "ipv4_addresses_per_interface" BIGINT,
    "ipv6_addresses_per_interface" BIGINT,
    "ipv6_supported" BOOLEAN,
    "ena_support" VARCHAR,
    "efa_supported" BOOLEAN,
    "efa_info" STRUCT(
        "maximum_efa_interfaces" BIGINT
    ),
    "encryption_in_transit_supported" BOOLEAN,
    "ena_srd_supported" BOOLEAN
)
Show child fields
network_info.default_network_card_index

The index of the default network card, starting at 0.

network_info.efa_info

Describes the Elastic Fabric Adapters for the instance type.

Show child fields
network_info.efa_info.maximum_efa_interfaces

The maximum number of Elastic Fabric Adapters for the instance type.

network_info.efa_supported

Indicates whether Elastic Fabric Adapter (EFA) is supported.

network_info.ena_srd_supported

Indicates whether the instance type supports ENA Express. ENA Express uses Amazon Web Services Scalable Reliable Datagram (SRD) technology to increase the maximum bandwidth used per stream and minimize tail latency of network traffic between EC2 instances.

network_info.ena_support

Indicates whether Elastic Network Adapter (ENA) is supported.

network_info.encryption_in_transit_supported

Indicates whether the instance type automatically encrypts in-transit traffic between instances.

network_info.ipv4_addresses_per_interface

The maximum number of IPv4 addresses per network interface.

network_info.ipv6_addresses_per_interface

The maximum number of IPv6 addresses per network interface.

network_info.ipv6_supported

Indicates whether IPv6 is supported.

network_info.maximum_network_cards

The maximum number of physical network cards that can be allocated to the instance.

network_info.maximum_network_interfaces

The maximum number of network interfaces for the instance type.

network_info.network_cards[]
Show child fields
network_info.network_cards[].baseline_bandwidth_in_gbps

The baseline network performance of the network card, in Gbps.

network_info.network_cards[].maximum_network_interfaces

The maximum number of network interfaces for the network card.

network_info.network_cards[].network_card_index

The index of the network card.

network_info.network_cards[].network_performance

The network performance of the network card.

network_info.network_cards[].peak_bandwidth_in_gbps

The peak (burst) network performance of the network card, in Gbps.

network_info.network_performance

The network performance.

neuron_info

Describes the Neuron accelerator settings for the instance type.

STRUCT(
    "neuron_devices" STRUCT(
        "count" BIGINT,
        "name" VARCHAR,
        "core_info" STRUCT(
            "count" BIGINT,
            "version" BIGINT
        ),
        "memory_info" STRUCT(
            "size_in_mi_b" BIGINT
        )
    )[],
    "total_neuron_device_memory_in_mi_b" BIGINT
)
Show child fields
neuron_info.neuron_devices[]
Show child fields
neuron_info.neuron_devices[].core_info

Describes the cores available to each neuron accelerator.

Show child fields
neuron_info.neuron_devices[].core_info.count

The number of cores available to the neuron accelerator.

neuron_info.neuron_devices[].core_info.version

The version of the neuron accelerator.

neuron_info.neuron_devices[].count

The number of neuron accelerators for the instance type.

neuron_info.neuron_devices[].memory_info

Describes the memory available to each neuron accelerator.

Show child fields
neuron_info.neuron_devices[].memory_info.size_in_mi_b

The size of the memory available to the neuron accelerator, in MiB.

neuron_info.neuron_devices[].name

The name of the neuron accelerator.

neuron_info.total_neuron_device_memory_in_mi_b

The total size of the memory for the neuron accelerators for the instance type, in MiB.

nitro_enclaves_support

Indicates whether Nitro Enclaves is supported.

VARCHAR
nitro_tpm_info

Describes the supported NitroTPM versions for the instance type.

STRUCT(
    "supported_versions" VARCHAR[]
)
Show child fields
nitro_tpm_info.supported_versions[]
nitro_tpm_support

Indicates whether NitroTPM is supported.

VARCHAR
phc_support

Indicates whether a local Precision Time Protocol (PTP) hardware clock (PHC) is supported.

VARCHAR
placement_group_info

Describes the placement group settings for the instance type.

STRUCT(
    "supported_strategies" VARCHAR[]
)
Show child fields
placement_group_info.supported_strategies[]
processor_info

Describes the processor.

STRUCT(
    "supported_architectures" VARCHAR[],
    "sustained_clock_speed_in_ghz" DOUBLE,
    "supported_features" VARCHAR[],
    "manufacturer" VARCHAR
)
Show child fields
processor_info.manufacturer

The manufacturer of the processor.

processor_info.supported_architectures[]
processor_info.supported_features[]
processor_info.sustained_clock_speed_in_ghz

The speed of the processor, in GHz.

supported_boot_modes

The supported boot modes. For more information, see Boot modes in the Amazon EC2 User Guide.

VARCHAR[]
Show child fields
supported_boot_modes[]
supported_root_device_types

The supported root device types.

VARCHAR[]
Show child fields
supported_root_device_types[]
supported_usage_classes

Indicates whether the instance type is offered for spot or On-Demand.

VARCHAR[]
Show child fields
supported_usage_classes[]
supported_virtualization_types

The supported virtualization types.

VARCHAR[]
Show child fields
supported_virtualization_types[]
v_cpu_info

Describes the vCPU configurations for the instance type.

STRUCT(
    "default_v_cpus" BIGINT,
    "default_cores" BIGINT,
    "default_threads_per_core" BIGINT,
    "valid_cores" BIGINT[],
    "valid_threads_per_core" BIGINT[]
)
Show child fields
v_cpu_info.default_cores

The default number of cores for the instance type.

v_cpu_info.default_threads_per_core

The default number of threads per core for the instance type.

v_cpu_info.default_v_cpus

The default number of vCPUs for the instance type.

v_cpu_info.valid_cores[]
v_cpu_info.valid_threads_per_core[]