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