Forum: Ruby on Rails check how long individual active record queries take to the database

I know that Rails output log shows how many milliseconds a sql query
take but I'm looking for something more fine-tuned. I want to know how
long individual activerecord queries take on an indiivdual basis. For
example, I have code that looks like this:

        items = current_user.accessible_items
        @items = items.where{item_id ==
my{current_user.item_id}}.ordered
        @other_items = current_user.accessible_items.where{item_id !=
my{current_user.item_id}}.ordered
        @accounts = @other_items.accounts.ordered

There are several database hits here. How can I check how long they
take?

On Saturday, March 16, 2013 5:20:05 AM UTC+13, John Merlino wrote:
> my{current_user.item_id}}.ordered
>         @accounts = @other_items.accounts.ordered
>
> There are several database hits here. How can I check how long they
> take?
>
>
If you're using Postgres, you can turn on query times for it. It may be
queries longer than N ms or something.