Postgres Aurora Performance Insights metrics is not working properly

Hey Tushar,

Can you select the database on the Performance Insights page at all? If so are you seeing any error on the page when you try to view the metrics?

You may need further permissions to view, see here - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PerfInsights.access-control.html

Some other reasons this can happen include:

• Your DB instance doesn't have enough resources to access the data from Performance Insights
• The data load on your DB instance is below the database load threshold

Hi Brandon,

Thanks for your reply.

I can select the database on Performance insights page. I'm not seeing any error on that page.

I can see the performance insights of other DBs in the same organization. For this specific DB, performance insights charts are showing flat data.

I tried hitting few large queries then also it is not appearing in performance insights.

Let me know how I can solve this issue.

Thanks, Tushar

Hey Tushar,

Thanks for that info. Which endpoint are you hitting with your queries? Is it the Cluster or the Instance? And how many instances are in the cluster?

Also wondering if the metrics are viewable through the CLI, can you try and view them using the API - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_PerfInsights.API.html

Let me know how you go :)