steampipe plugin install awssteampipe plugin install aws

Table: aws_rds_db_instance_metric_connections - Query AWS RDS DBInstance Metrics using SQL

The AWS RDS DBInstance Metrics is a feature of Amazon Relational Database Service (RDS) that allows you to monitor the performance of your databases. It provides a variety of metrics that can help you understand your database's workload, throughput, and performance. These metrics can be queried using SQL, enabling you to analyze and optimize your database's performance.

Table Usage Guide

The aws_rds_db_instance_metric_connections table in Steampipe provides you with information about the number of database connections to each Amazon RDS DB instance. This table allows you, as a DevOps engineer, database administrator, or other technical professional, to query connection-specific details, including the time at which the number of connections was recorded, the maximum number of connections during the period, and the number of data points used for the statistical calculation. You can utilize this table to monitor and manage your database connections, analyze connection trends, and troubleshoot potential connection issues. The schema outlines the various attributes of the RDS DB instance connections, including the DB instance identifier, timestamp, sample count, average, minimum, and maximum number of connections.

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

Examples

Basic info

Determine the areas in which AWS RDS database instances have varying connection metrics over time. This can help in understanding the database's performance and planning for scalability.

select
  db_instance_identifier,
  timestamp,
  minimum,
  maximum,
  average,
  sample_count
from
  aws_rds_db_instance_metric_connections
order by
  db_instance_identifier,
  timestamp;

select
  db_instance_identifier,
  timestamp,
  minimum,
  maximum,
  average,
  sample_count
from
  aws_rds_db_instance_metric_connections
order by
  db_instance_identifier,
  timestamp;

Intervals averaging over 100 connections

Determine the areas in which your AWS RDS database instances have an average of over 100 connections, allowing you to identify potential performance issues or heavy usage periods.

select
  db_instance_identifier,
  timestamp,
  minimum,
  maximum,
  average,
  sample_count
from
  aws_rds_db_instance_metric_connections
where
  average > 100
order by
  db_instance_identifier,
  timestamp;

select
  db_instance_identifier,
  timestamp,
  minimum,
  maximum,
  average,
  sample_count
from
  aws_rds_db_instance_metric_connections
where
  average > 100
order by
  db_instance_identifier,
  timestamp;

Schema for aws_rds_db_instance_metric_connections

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
db_instance_identifier	text		The friendly name to identify the DB Instance.
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.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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.

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_rds_db_instance_metric_connections