One thing I really like about RDS is the query visualizer. It shows which queries ran when and for how long and what they spent their time waiting for, CPU or disk or locks or whatever. It’s really good. Are there any free tools that show a similar view?
edit: i think it’s called performance insights in RDS
Would be a whole lot better if it didn't prune their query logs to x (I think 1000?) characters.
We autogenerate many of our own queries which can have significant complexity (regularly over 10 joins, sometimes up to 30!) and our infrastructure isn't quite there yet to be able to recreate the exact query plan a customer saw on their own data without a lot of work. It could all be so much simpler, so if there is a setting to prevent this please tell me!
edit: i think it’s called performance insights in RDS