Monitoring RDS Data API queries with Performance Insights (original) (raw)

How RDS Data API queries are represented in Performance Insights

If your Aurora cluster is running Aurora Serverless v2 or provisioned instances, you can use Performance Insights with RDS Data API.

For more information about how to use Performance Insights with Aurora, seeMonitoring DB load with Performance Insights on Amazon Aurora.

How RDS Data API queries are represented in Performance Insights

With Data API, your Aurora cluster processes queries based on Data API calls that you submit from your application. Data API also performs some SQL statements as part of its own internal workings, such as canceling queries that exceed the timeout threshold. Both kinds of SQL operations are shown in Performance Insights statistics and charts.

• For Data API queries that you submit to an Aurora cluster, the Host field in the PI dashboard is marked as RDS Data API. For Aurora PostgreSQL, theapplication_name field has the value rds-data-api. Look for these labels when you analyze database load using Top hosts or Top Applications as a dimension.
• All internal queries that Data API runs to manage database aspects such as the connection pool and query timeouts are annotated with a prefix RDS Data API. Example: /* RDS Data API */ select * from my_table; Looks for these prefixes when you analyze database load byTop SQL as a dimension. statements are annotated with a SQL comment of /* RDS Data API */.

Logging RDS Data API calls with AWS CloudTrail

Using the query editor

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.