get_dimension_key_details
¶
get_dimension_key_details(
service_type: ServiceType,
identifier: IdentifierString,
group: RequestString,
group_identifier: RequestString,
*,
config_overrides: Optional[PIClientConfig] = None,
requested_dimensions: Optional[RequestedDimensionList] = None,
) -> GetDimensionKeyDetailsResponse
Get the attributes of the specified dimension group for a DB instance or data source. For example, if you specify a SQL ID, GetDimensionKeyDetails retrieves the full text of the dimension db.sql.statement associated with this ID. This operation is useful because GetResourceMetrics and DescribeDimensionKeys don't support retrieval of large SQL statement text, lock snapshots, and execution plans.
Parameters:
-
service_type(ServiceType) –The Amazon Web Services service for which Performance Insights returns data. The only valid value is
RDS. -
identifier(IdentifierString) –The ID for a data source from which to gather dimension data. This ID must be immutable and unique within an Amazon Web Services Region. When a DB instance is the data source, specify its
DbiResourceIdvalue. For example, specifydb-ABCDEFGHIJKLMNOPQRSTU1VW2X. -
group(RequestString) –The name of the dimension group. Performance Insights searches the specified group for the dimension group ID. The following group name values are valid:
-
db.execution_plan(Amazon RDS and Aurora only) -
db.lock_snapshot(Aurora only) -
db.query(Amazon DocumentDB only) -
db.sql(Amazon RDS and Aurora only)
-
-
group_identifier(RequestString) –The ID of the dimension group from which to retrieve dimension details. For dimension group
db.sql, the group ID isdb.sql.id. The following group ID values are valid:-
db.execution_plan.idfor dimension groupdb.execution_plan(Aurora and RDS only) -
db.sql.idfor dimension groupdb.sql(Aurora and RDS only) -
db.query.idfor dimension groupdb.query(DocumentDB only) -
For the dimension group
db.lock_snapshot, theGroupIdentifieris the epoch timestamp when Performance Insights captured the snapshot, in seconds. You can retrieve this value with theGetResourceMetricsoperation for a 1 second period.
-
-
requested_dimensions(Optional[RequestedDimensionList], default:None) –A list of dimensions to retrieve the detail data for within the given dimension group. If you don't specify this parameter, Performance Insights returns all dimension data within the specified dimension group. Specify dimension names for the following dimension groups:
-
db.execution_plan- Specify the dimension namedb.execution_plan.raw_planor the short dimension nameraw_plan(Amazon RDS and Aurora only) -
db.lock_snapshot- Specify the dimension namedb.lock_snapshot.lock_treesor the short dimension namelock_trees. (Aurora only) -
db.sql- Specify either the full dimension namedb.sql.statementor the short dimension namestatement(Aurora and RDS only). -
db.query- Specify either the full dimension namedb.query.statementor the short dimension namestatement(DocumentDB only).
-
Raises:
-
InternalServiceError–The request failed due to an unknown error.
-
InvalidArgumentException–One of the arguments provided is invalid for this request.
-
NotAuthorizedException–The user is not authorized to perform this request.
-
UnknownServiceError–The service returned an error code this client does not model.