Control: Are there any lambda functions with excessive timeout?

powerpipe control run aws_thrifty.control.lambda_function_excessive_timeout

powerpipe login
powerpipe control run aws_thrifty.control.lambda_function_excessive_timeout --share

with lambda_duration as (
  select
    name,
    avg(average :: numeric) as avg_duration
  from
    aws_lambda_function_metric_duration_daily
  where
    date_part('day', now() - timestamp) <= 7
  group by
    name
)
select
  arn as resource,
  case
    when avg_duration is null then 'error'
    when ((timeout :: numeric * 1000) - avg_duration) / (timeout :: numeric * 1000) > 0.1 then 'alarm'
    else 'ok'
  end as status,
  case
    when avg_duration is null then 'CloudWatch lambda metrics not available for ' || title || '.'
    else title || ' Timeout of ' || timeout :: numeric * 1000 || ' milliseconds is ' || round(
      ((timeout :: numeric * 1000) - avg_duration) / (timeout :: numeric * 1000) * 100,
      1
    ) || '% more as compared to average of ' || round(avg_duration, 0) || ' milliseconds.'
  end as reason,
  region,
  account_id
from
  aws_lambda_function f
  left join lambda_duration as d on f.name = d.name;