List EC2 instances that are not using Graviton processors

Graviton-based instances provide better performance at a lower cost. Here’s a PostgreSQL query that you can use to find all expired certificates from your AWS CloudQuery sync.

SELECT 
    arn, instance_type, region
FROM 
    aws_ec2_instances
WHERE 
    instance_type NOT LIKE 't4g%' 
    AND instance_type NOT LIKE 'm6g%' 
    AND instance_type NOT LIKE 'c6g%' 
    AND instance_type NOT LIKE 'r6g%'; -- List of Graviton-based instance types
1 Like