Skip to content

/AWS1/CL_DOGPERFORMANCEINSIG01

A single query to be processed. Use these parameters to query the Performance Insights GetResourceMetrics API to retrieve the metrics for an anomaly. For more information, see GetResourceMetrics in the Amazon RDS Performance Insights API Reference.

Amazon RDS Performance Insights enables you to monitor and explore different dimensions of database load based on data captured from a running DB instance. DB load is measured as average active sessions. Performance Insights provides the data to API consumers as a two-dimensional time-series dataset. The time dimension provides DB load data for each time point in the queried time range. Each time point decomposes overall load in relation to the requested dimensions, measured at that time point. Examples include SQL, Wait event, User, and Host.

CONSTRUCTOR

IMPORTING

Optional arguments:

iv_metric TYPE /AWS1/DOGPERFORMANCEINSIGHTS02 /AWS1/DOGPERFORMANCEINSIGHTS02

The name of the meteric used used when querying an Performance Insights GetResourceMetrics API for anomaly metrics.

Valid values for Metric are:

  • db.load.avg - a scaled representation of the number of active sessions for the database engine.

  • db.sampledload.avg - the raw number of active sessions for the database engine.

If the number of active sessions is less than an internal Performance Insights threshold, db.load.avg and db.sampledload.avg are the same value. If the number of active sessions is greater than the internal threshold, Performance Insights samples the active sessions, with db.load.avg showing the scaled values, db.sampledload.avg showing the raw values, and db.sampledload.avg less than db.load.avg. For most use cases, you can query db.load.avg only.

io_groupby TYPE REF TO /AWS1/CL_DOGPERFORMANCEINSIG02 /AWS1/CL_DOGPERFORMANCEINSIG02

The specification for how to aggregate the data points from a Performance Insights GetResourceMetrics API query. The Performance Insights query returns all of the dimensions within that group, unless you provide the names of specific dimensions within that group. You can also request that Performance Insights return a limited number of values for a dimension.

it_filter TYPE /AWS1/CL_DOGPERFORMANCEINSIG04=>TT_PERFORMANCEINSIGHTSMETRIC01 TT_PERFORMANCEINSIGHTSMETRIC01

One or more filters to apply to a Performance Insights GetResourceMetrics API query. Restrictions:

  • Any number of filters by the same dimension, as specified in the GroupBy parameter.

  • A single filter for any other dimension in this dimension group.

Queryable Attributes

Metric

The name of the meteric used used when querying an Performance Insights GetResourceMetrics API for anomaly metrics.

Valid values for Metric are:

  • db.load.avg - a scaled representation of the number of active sessions for the database engine.

  • db.sampledload.avg - the raw number of active sessions for the database engine.

If the number of active sessions is less than an internal Performance Insights threshold, db.load.avg and db.sampledload.avg are the same value. If the number of active sessions is greater than the internal threshold, Performance Insights samples the active sessions, with db.load.avg showing the scaled values, db.sampledload.avg showing the raw values, and db.sampledload.avg less than db.load.avg. For most use cases, you can query db.load.avg only.

Accessible with the following methods

Method Description
GET_METRIC() Getter for METRIC, with configurable default
ASK_METRIC() Getter for METRIC w/ exceptions if field has no value
HAS_METRIC() Determine if METRIC has a value

GroupBy

The specification for how to aggregate the data points from a Performance Insights GetResourceMetrics API query. The Performance Insights query returns all of the dimensions within that group, unless you provide the names of specific dimensions within that group. You can also request that Performance Insights return a limited number of values for a dimension.

Accessible with the following methods

Method Description
GET_GROUPBY() Getter for GROUPBY

Filter

One or more filters to apply to a Performance Insights GetResourceMetrics API query. Restrictions:

  • Any number of filters by the same dimension, as specified in the GroupBy parameter.

  • A single filter for any other dimension in this dimension group.

Accessible with the following methods

Method Description
GET_FILTER() Getter for FILTER, with configurable default
ASK_FILTER() Getter for FILTER w/ exceptions if field has no value
HAS_FILTER() Determine if FILTER has a value