Profile Database Usage

I'm assuming it's possible to see the database usage Rails generates, but I'm having trouble finding the correct Google search. I'm looking at ActsAsVersioned and ActsAsAudited, and I'd like to be able to see the resulting SQL as I perform work on the model, to do a little due- diligence on these plugins, but ... well, I don't know how. Pointers to information on how I can get this would be great.

(If some of you are from Java backgrounds, I'd be happy with the equivalent of a Spy driver, or hibernate's 'show sql' property, or something like a profiler with database-transaction hooks -- any and all of the above).

Thanks!

Hi,

How about tailing the current environment's log file? AR's generated SQL will show up.

~ j.