How to log SQL Create,Update,Delete only?

Does anyone know of a way to log SQL statements (but without the SELECT
queries)? I would like to keep track of the changes made to the
database, but I don't want the log file to be flooded with SELECT
statements (I am using the default logger at debug level). Is it
possible to do that with the rails logger?

Suggestion: do it using the logger and ActiveRecord callbacks.

http://api.rubyonrails.com/classes/ActiveRecord/Callbacks.html

That way you can choose to log before_create, before_save,
before_destroy or whatever.

Regards,
Dave