DBIx::Class::QueryLog logs each transaction and query executed so you can analyze what happened in the session.