steampipe plugin install aws

Table: aws_ec2_application_load_balancer_metric_request_count - Query AWS EC2 Application Load Balancer Metrics using SQL

The AWS EC2 Application Load Balancer is a component of the Elastic Load Balancing service that automatically distributes incoming application traffic across multiple targets, such as Amazon EC2 instances, containers, IP addresses, and Lambda functions. It can handle the varying load of your application traffic in a single Availability Zone or across multiple Availability Zones. The Application Load Balancer offers two types of load balancer that cater to specific needs - Classic Load Balancer (CLB) for simple load balancing across multiple Amazon EC2 instances and Application Load Balancer (ALB) for applications needing advanced routing capabilities, microservices, and container-based architectures.

Table Usage Guide

The aws_ec2_application_load_balancer_metric_request_count table in Steampipe provides you with information about the request count metrics of Application Load Balancers within Amazon Elastic Compute Cloud (EC2). This table allows you as a DevOps engineer, system administrator, or other technical professional to query specific details about the number of requests processed by your Application Load Balancers. You can utilize this table to gather insights on load balancing performance and to monitor the traffic your applications are receiving. The schema outlines the various attributes of the request count metric, including the load balancer name, namespace, metric name, and dimensions.

The aws_ec2_application_load_balancer_metric_request_count table provides you with metric statistics at 5 min intervals for the most recent 5 days.

Examples

Basic info

Explore the performance of your application load balancers on AWS EC2 by analyzing metrics such as average, maximum, and minimum request counts. This allows you to assess the load on your balancers and make informed decisions about scaling and resource allocation.

select
name,
metric_name,
namespace,
average,
maximum,
minimum,
sample_count,
timestamp
from
aws_ec2_application_load_balancer_metric_request_count
order by
name,
timestamp;
select
name,
metric_name,
namespace,
average,
maximum,
minimum,
sample_count,
timestamp
from
aws_ec2_application_load_balancer_metric_request_count
order by
name,
timestamp;

Intervals averaging less than 100 net flow count

Gain insights into application load balancer metrics where the average request count is less than 100, to understand the performance and traffic patterns. This can be beneficial for optimizing resource allocation and managing load effectively.

select
name,
metric_name,
namespace,
maximum,
minimum,
average sample_count,
timestamp
from
aws_ec2_application_load_balancer_metric_request_count
where
average < 100
order by
name,
timestamp;
select
name,
metric_name,
namespace,
maximum,
minimum,
average,
sample_count,
timestamp
from
aws_ec2_application_load_balancer_metric_request_count
where
average < 100
order by
name,
timestamp;

Schema for aws_ec2_application_load_balancer_metric_request_count

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 friendly name of the Load Balancer that was provided during resource creation.
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_ec2_application_load_balancer_metric_request_count