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!

On 8/20/07, Geoffrey W. [email protected] wrote:

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.

Hi,

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

~ j.