Count the amount of queries in Rails

Question

I'm trying to optimize my site, in order to do that I want to know which action is making more queries than others. Is there anyway to know the amount of DB hits made by one action?

Answer 1

i found these gem very helpful for inspecting issues and optimizing queries

• https://github.com/noahd1/oink
• https://github.com/flyerhzm/bullet

Answer 2

This gem will do exactly what you need: show the number of db queries issued per action:

https://github.com/makandra/query_diet