Hi Team,
We created Postgres Aurora read replica for Postgres RDS and enabled performance insights for Aurora read replica.
In performance insights for this read replica, it is not tracking DB CPU, SQLs, etc.
Can you please help how we can track the metrics correctly through performance insights?
Thanks, Tushar
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:
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 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 :)
Hi. Did you find a solution? I have the same issue.
Você não está conectado. Fazer login para postar uma resposta.
Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.
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:
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 :)