Rails - Mar 2005 - Trace actual SQL statements per request?

Hi everybody!

Is there a way to trace/log the actual SQL statements per request to a page?
I just love the way RoR handles everything, but since I''m going to add 
som complex relations further on I would like to know how my controller 
fetches stuff from the DB.

Good to know, so that I could add indexes etc to the DB if needed.

Regards
// JoNtE

> Is there a way to trace/log the actual SQL statements per request to a 
> page?
> I just love the way RoR handles everything, but since I''m going to
add
> som complex relations further on I would like to know how my 
> controller fetches stuff from the DB.
tail -f log/development. You''ll see all the SQL statements grouped 
together by page requests.
--
David Heinemeier Hansson,
http://www.basecamphq.com/   -- Web-based Project Management
http://www.rubyonrails.org/  -- Web-application framework for Ruby
http://www.loudthinking.com/ -- Broadcasting Brain

David Heinemeier Hansson wrote:
>> Is there a way to trace/log the actual SQL statements per request to 
>> a page?
>> I just love the way RoR handles everything, but since I''m
going to
>> add som complex relations further on I would like to know how my 
>> controller fetches stuff from the DB.
>
>
> tail -f log/development. You''ll see all the SQL statements grouped
> together by page requests.
> -- 
> David Heinemeier Hansson,
> http://www.basecamphq.com/   -- Web-based Project Management
> http://www.rubyonrails.org/  -- Web-application framework for Ruby
> http://www.loudthinking.com/ -- Broadcasting Brain
>
> _______________________________________________
> Rails mailing list
> Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
> http://lists.rubyonrails.org/mailman/listinfo/rails
>
Ah! splendid.
Thanx

Should have thought on that myself.
// JoNtE