How to determine the time taken to complete a Rails query

Question

I would like to include query statistics (i.e. records returned and elapsed time) in my Index views (similar to Google's). I found the records returned, but am having difficultly locating the elapsed time.

I'm using Rails3 beta and the will_paginate plugin.

Answer 1

You can use mongrel It displays all the queries in your terminal.

to install mongrel

"gem install mongrel" command

Answer 2

The Rails Footnote plugin does this by registering itself with ActiveRecord as a connection adapter. Here's the relevant source code from that project that should enable you to get started.