Request for Assistance with Database Optimization: Query Execution Time Monitoring

[rushi2199]

I am reaching out to request assistance with optimizing our RDS database ( Aurora MySQL ) performance. Specifically, I am interested in implementing a system to monitor and analyze the execution time of each query in our database. Our goal is to identify queries that take the most time to execute, allowing us to optimize their performance effectively.

Could you please provide me step by step guidance that how we can perform this task on Signoz.

1. Monitoring Query Execution Times: We need a solution to track how long each query takes to execute in our database.
2. Identifying Slow Queries: We are looking for methods to pinpoint which queries are the slowest and require optimization.
3. Performance Insights: Any tools or techniques that can offer insights into query performance and suggest improvements would be highly valuable.