In Rails, how to get the actual Query when an ActiveRecord query executes

Question

Hi,

I am using a simple query in ActiveRecord which does something like this.

MyTable.find(:all, :conditions => {:start_date => format_time(params[:date]) })

I want to get the equivalent query that is executed in the background, perhaps using a puts statement or something similar to that. MySQL is my database.

Answer 1

In development mode, your DB queries are printed to the server console, you can localize the query there.

Answer 2

You can see the SQL query that is executed by viewing the development log located in log/development.log. Note that the script/server command tails this log file by default.

• In Rails 3 you can append a .to_sql method call to the end of the finder to output the SQL.

• Alternatively, New Relic's free RPM Lite gem lets you see the SQL queries in developer mode as well as lots of other useful performance tuning information.

Answer 3

You can insatll mongrel

its gets you all sql queries on your terminal

or run active record query on script/console