Table: aws_lightsail_instance

select
  availability_zone as az,
  bundle_id,
  count(*)
from
  aws_lightsail_instance
group by
  availability_zone,
  bundle_id;

select
  name,
  state_name
from
  aws_lightsail_instance
where
  state_name = 'stopped'
  and created_at <= (current_date - interval '30' day);

select
  name,
  state_name,
  bundle_id,
  region
from
  aws_lightsail_instance
where
  public_ip_address is not null;

select
  name,
  tags
from
  aws_lightsail_instance
where
  not tags :: JSONB ? 'application';

select
  name,
  hardware ->> 'CpuCount' as "CPU Count",
  hardware ->> 'RamSizeInGb' as "RAM Size (in GB)"
from
  aws_lightsail_instance;