Table: aws_lambda_function_metric_duration_daily

Amazon CloudWatch Metrics provide data about the performance of your systems. The aws_lambda_function_metric_duration_daily table provides metric statistics at 24 hour intervals for the last year.

Examples

Basic info

select
  name,
  timestamp,
  minimum,
  maximum,
  average,
  sample_count
from
  aws_lambda_function_metric_duration_daily
order by
  name,
  timestamp;

Lambda function daily maximum duration over 100 milliseconds

select
  name,
  timestamp,
  round(minimum :: numeric, 2) as min_duration,
  round(maximum :: numeric, 2) as max_duration,
  round(average :: numeric, 2) as avg_duration,
  sample_count
from
  aws_lambda_function_metric_duration_daily
where
  maximum > 100
order by
  name,
  timestamp;

Lambda function daily average duration less than 5 milliseconds

select
  name,
  timestamp,
  round(minimum :: numeric, 2) as min_duration,
  round(maximum :: numeric, 2) as max_duration,
  round(average :: numeric, 2) as avg_duration,
  sample_count
from
  aws_lambda_function_metric_duration_daily
where
  average < 5
order by
  name,
  timestamp;

Control examples

lambda_function_excessive_timeout

.inspect aws_lambda_function_metric_duration_daily

AWS Lambda Function Cloudwatch Metrics - Duration (Daily)

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
average	double precision	The average of the metric values that correspond to the data point.
maximum	double precision	The maximum metric value for the data point.
metric_name	text	The name of the metric.
minimum	double precision	The minimum metric value for the data point.
name	text	The name of the function.
namespace	text	The metric namespace.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
sample_count	double precision	The number of metric values that contributed to the aggregate value of this data point.
sum	double precision	The sum of the metric values for the data point.
timestamp	timestamp with time zone	The time stamp used for the data point.
unit	text	The standard unit for the data point.

turbot/aws