Q: How does Performance Insights show me the cause of performance problems?
Performance problems appear in the Performance Insights section of the RDS Management Console as spikes in the database load graph. One look at this graph can quickly tell you what type of resources your application has been spending time and resources on in the database. The console allows you to zoom in to any period within the retention time. By selecting the periods of high load, you can display a list of SQL statements, ordered by overall contribution to load.
Q: How is Performance Insights able to assess load in my RDS database instance?
Performance Insights samples the state of connected sessions in your DB instance every second. If a session is spending time on a database-related operation, Performance Insights records the current time, the type of operation (I/O, CPU, locking, etc.), the current SQL statement, and several other session attributes. Over time, this sampled data is used to characterize how sessions are contributing to load in your database instance.
Q: Can performance data be queried from inside the RDS instance?
No. Performance Insights provides access to performance data via the RDS API and the RDS Management Console. It does not populate any tables in the database, nor does it present data to be retrieved from within the database via SQL.
Q: Can I see what is happening on my instance in real time?
Yes. By default, Performance Insights displays a moving one hour window of performance data. The feature is designed to present the latest performance information within a few seconds of real time.
Q: How much does Performance Insights cost?
Performance Insights includes a free tier with a trailing seven days of performance data retention. Long-term retention up to two years is available at a small fraction of the instance price. API requests include a generous free tier and reasonable per-request pricing above free tier thresholds. See our pricing page for more information.
Q: How far back can I look at performance data stored in Performance Insights?
Performance Insights includes a free tier with a trailing seven days of performance data retention. Long-term retention up to two years is available at a small fraction of the instance price.
Q: Can I turn off Performance Insights on new instances, even though it is enabled by default?
Yes. The option for Performance Insights is selected by default in the Amazon Web Services Console when you use the instance creation wizard. You can de-select the option in the wizard to prevent Performance Insights from being enabled, or you can disable Performance Insights in an enabled instance by modifying the instance.
Q: Does Performance Insights work on RDS database instances using encrypted storage?
Yes.
Q: What is DB Load and why is it the primary measure metric used in Performance Insights to detect performance issues?
At the core of Performance Insights is a single metric called DB Load. This metric characterizes how an application is spending time in the database. DB Load is measured in units of average active sessions (AAS). An active session is a connection (session) that has submitted work to the database engine and is waiting for a response from it. For example, if you submit a SQL statement to a database instance, that session is considered “active” during the time that the instance is processing that query. By counting the number of sessions that are active in an instance at a given moment, we can provide a metric which, averaged over time periods, can show how busy an instance is, and how much time sessions are spending waiting for the instance to respond; this is DB Load. Performance Insights counts active sessions and records each session’s attributes about every second using a lightweight sampling mechanism. The sampled data is encrypted and aggregated to a variety of granularities and served through the API and in the DB Load chart in the RDS Management Console.
Q: Do I have to do anything special to my database to enable Performance Insights?
No. However, Performance Insights will work even better on some database engines when additional performance tracking is enabled. For instance, when the pg_stat_statement extension is enabled on Aurora with PostgreSQL compatibility, Performance Insights will take advantage of the additional information provided by that extension to use the PostgreSQL-native SQL identifier to label the statement.
Q: Will enabling Performance Insights affect my database performance?
The Performance Insights agent is designed to stay out of your database workloads' way. When Performance Insights detects heavy load or depleted resources, it backs off, still collecting data, but only when it is safe to do so. Database options, such as pg_stat_statement in Aurora PostgreSQL may use some database resources and potentially affect performance. Whether enabling these options will affect a particular system depends on the application workload. We recommend testing any database options against your workload prior to enabling them on a production system.
Q: Should I keep using Enhanced Monitoring or just use Performance Insights?
If you're using Enhanced Monitoring to monitor O/S metrics, you should continue to obtain that data via Enhanced Monitoring.
Q: Is the data stored in Performance Insights encrypted?
Yes. Performance Insights encrypts all potentially sensitive data using your own KMS key. Data is encrypted in flight and at rest. Our personnel cannot access or see any potentially sensitive performance data. Only your users on your Amazon Web Services account with full access to RDS can view Performance Insights.
Q: What happens to Performance Insights data retention when I stop my RDS database instance?
Stopping an RDS instance that has Performance Insights enabled has no effect on retention or visibility of historical data for that instance. The period during which the instance was stopped will contain no data.
Q: How would I interface Performance Insights with my existing performance tools?
Performance Insights exposes a publicly available API designed to enable customers and third parties to take advantage of the valuable data in Performance Insights.
Q: Is there any way for third party performance tools to integrate with Performance Insights?
Yes. Performance Insights exposes a publicly available API designed to enable customers and third parties to take advantage of the valuable data in Performance Insights.
Q: Will Performance Insights be available in all Amazon Web Services Regions where RDS is available?
Yes. Over time, the feature will be made available in all regions where RDS is supported.
Q: Can I turn on Performance Insights on existing instances?
Yes, Amazon RDS Performance Insights can be enabled on existing RDS instances by modifying the instance to enable Performance Insights.
Q: Does Performance Insights use any of the storage on my database instance?
No, Performance Insights does not consume storage space on your RDS instances.
Q: How will Performance Insights be different, if at all, when running against different database engines?
Performance Insights is designed to present a common approach, look, and feel to tuning across all database engines in RDS. Because certain attributes like wait events and SQL identifiers vary by engine type, these will naturally vary in Performance Insights when working with different database engines. One of the core tenets of Performance Insights is that existing concepts, identifiers, and attributes in a database engine should remain intact. Performance Insights will generally not re-interpret or rename wait events and other engine-specific attributes, but will present them faithfully as reported by the database engine.
Q: Does Performance Insights work on Multi-AZ instances and Read Replica instances?
Yes. Because Aurora Replicas instances are independent instances, you can either enable or disable Performance Insights on those instances.
Q: Can I export my data from Performance Insights?
Not at this time. In the future, Performance Insights will be adding functionality to export data. However, data obtained via Performance Insights is available via an API for consumption.
Q: Can I import my data to Performance Insights in order to do performance analysis?
No. Performance Insights only shows data that has been collected directly from an instance. However, data obtained via the Performance Insights is available via an API, and analysis can be done by Amazon Web Services analytics services such as Amazon Athena, Amazon Redshift, Amazon Redshift Spectrum, and Amazon Quicksight.
Q: Will enabling Performance Insights affect my instance’s eligibility for any compliance regime?
The Performance Insight feature is a feature of RDS and will inherit the compliance certifications of RDS services. Unless specifically excluded, features of each of the services are considered in scope of the assurance programs, and are reviewed and tested as part of the assessment.
