steampipe plugin install awssteampipe plugin install aws

Table: aws_ec2_instance_type

Amazon EC2 provides a wide selection of instance types optimized to fit different use cases. Instance types comprise varying combinations of CPU, memory, storage, and networking capacity and give you the flexibility to choose the appropriate mix of resources for your applications.

Examples

List of instance types which supports dedicated host

select
  instance_type,
  dedicated_hosts_supported
from
  aws_ec2_instance_type
where
  dedicated_hosts_supported;

List of instance types which does not support auto recovery

select
  instance_type,
  auto_recovery_supported
from
  aws_ec2_instance_type
where
  not auto_recovery_supported;

List of instance types which have more than 24 cores

select
  instance_type,
  dedicated_hosts_supported,
  v_cpu_info -> 'DefaultCores' as default_cores,
  v_cpu_info -> 'DefaultThreadsPerCore' as default_threads_per_core,
  v_cpu_info -> 'DefaultVCpus' as default_vcpus,
  v_cpu_info -> 'ValidCores' as valid_cores,
  v_cpu_info -> 'ValidThreadsPerCore' as valid_threads_per_core
from
  aws_ec2_instance_type
where
  v_cpu_info ->> 'DefaultCores' > '24';

List of instance types which does not support encryption to root volume

select
  instance_type,
  ebs_info ->> 'EncryptionSupport' as encryption_support
from
  aws_ec2_instance_type
where
  ebs_info ->> 'EncryptionSupport' = 'unsupported';

List of instance types eligible for free tier

select
  instance_type,
  free_tier_eligible
from
  aws_ec2_instance_type
where
  free_tier_eligible;

.inspect aws_ec2_instance_type

AWS EC2 Instance Type

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
auto_recovery_supported	boolean	Indicates whether auto recovery is supported.
bare_metal	boolean	Indicates whether the instance is a bare metal instance type.
burstable_performance_supported	boolean	Indicates whether the instance type is a burstable performance instance type.
current_generation	boolean	Indicates whether the instance type is current generation.
dedicated_hosts_supported	boolean	Indicates whether Dedicated Hosts are supported on the instance type.
ebs_info	jsonb	Describes the Amazon EBS settings for the instance type.
free_tier_eligible	boolean	Indicates whether the instance type is eligible for the free tier.
gpu_info	jsonb	Describes the GPU accelerator settings for the instance type.
hibernation_supported	boolean	Indicates whether On-Demand hibernation is supported.
hypervisor	text	The hypervisor for the instance type.
instance_storage_supported	text	Describes the instance storage for the instance type.
instance_type	text	The instance type. For more information, see [ Instance Types ](https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/instance-types.html) in the Amazon Elastic Compute Cloud User Guide.
memory_info	jsonb	Describes the memory for the instance type.
network_info	jsonb	Describes the network settings for the instance type.
placement_group_info	jsonb	Describes the placement group settings for the instance type.
processor_info	jsonb	Describes the processor.
supported_root_device_types	jsonb	The supported root device types.
supported_usage_classes	jsonb	Indicates whether the instance type is offered for spot or On-Demand.
supported_virtualization_types	jsonb	The supported virtualization types.
title	text	Title of the resource.
v_cpu_info	jsonb	Describes the vCPU configurations for the instance type.

turbot/aws