Tracing SQL queries created by Ruby-on-Rails

Question

Hi,

In the web application I am currently developing, I have quite a few database queries being performed. I would like to know what parts of the code are producing these queries so that I can perhaps refactor the code to reduce them. Is there an easy way to do this?

Typically, the database queries are like:

SELECT count(*) AS count_all FROM 'stores' WHERE ('stores'.'distributor_id' = 1)

Thanks very much for your suggestions!

Gav

Answer 1

I think you're looking for QueryTrace.