Check how long individual active record queries take to the database

Rails
1

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?

2

On Saturday, March 16, 2013 5:20:05 AM UTC+13, John M. 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.