check how long individual active record queries take to the database

[John Merlino]

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?

[Dmitry Maksyoma]

If you're using Postgres, you can turn on query times for it. It may be queries longer than N ms or something.