steampipe plugin install aws

Table: aws_lambda_function_metric_duration_daily - Query AWS Lambda Function Metrics using SQL

The AWS Lambda Function Metrics allows you to monitor and troubleshoot your Lambda functions. It provides near real-time metrics on the performance and health of your functions, including duration, which measures the elapsed wall clock time from when the function code starts executing as a result of an invocation to when it stops executing. The daily metric duration gives insights into the function's performance and efficiency over a 24-hour period.

Table Usage Guide

The aws_lambda_function_metric_duration_daily table in Steampipe provides you with information about daily duration metrics of AWS Lambda functions. This table allows you, as a DevOps engineer, to query duration-specific details, including average, maximum, and minimum execution times of functions, along with the total count of requests. You can utilize this table to monitor the performance of Lambda functions, such as identifying functions with long execution times, tracking daily changes in function duration, and more. The schema outlines the various attributes of the Lambda function duration metrics for you, including the timestamp, function name, region, and associated statistics.

The aws_lambda_function_metric_duration_daily table provides you with metric statistics at 24 hour intervals for the last year.

Examples

Basic info

Analyze the daily performance metrics of AWS Lambda functions to understand their execution duration trends. This can help in assessing the efficiency of your serverless applications and optimizing resource allocation.

select
name,
timestamp,
minimum,
maximum,
average,
sample_count
from
aws_lambda_function_metric_duration_daily
order by
name,
timestamp;
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

Discover the segments that have a daily maximum duration over 100 milliseconds in your Lambda functions. This allows you to identify potential performance issues and optimize your functions for better efficiency.

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;
select
name,
timestamp,
round(minimum, 2) as min_duration,
round(maximum, 2) as max_duration,
round(average, 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

Identify instances where the average daily duration of AWS Lambda functions is less than 5 milliseconds, in order to assess the efficiency and performance of your serverless applications. This information can be used to optimize resource allocation and improve application responsiveness.

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;
select
name,
timestamp,
round(minimum, 2) as min_duration,
round(maximum, 2) as max_duration,
round(average, 2) as avg_duration,
sample_count
from
aws_lambda_function_metric_duration_daily
where
average < 5
order by
name,
timestamp;

Schema for aws_lambda_function_metric_duration_daily

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
averagedouble precisionThe average of the metric values that correspond to the data point.
maximumdouble precisionThe maximum metric value for the data point.
metric_nametextThe name of the metric.
minimumdouble precisionThe minimum metric value for the data point.
nametextThe name of the function.
namespacetextThe metric namespace.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
sample_countdouble precisionThe number of metric values that contributed to the aggregate value of this data point.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
sumdouble precisionThe sum of the metric values for the data point.
timestamptimestamp with time zoneThe time stamp used for the data point.
unittextThe standard unit for the data point.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_lambda_function_metric_duration_daily