SYNOPSIS use DBI; use Log::ger::DBI::Query; # now SQL queries will be logged my $dbh = DBI->connect("dbi:...", $user, $pass); $dbh->do("INSERT INTO table VALUES (...)"); From command-line: % TRACE=1 perl -MLog::ger::Output::Screen -MLog::ger::DBI::Query your-dbi-app.pl To also log SQL results: % TRACE=1 LOG_SQL_RESULT=1 \ perl -MLog::ger::Output::Screen -MLog::ger::DBI::Query your-dbi-app.pl Sample log output: SQL query: {{INSERT INTO table VALUES (...)} DESCRIPTION This is a simple module you can do to log SQL queries for your DBI-based applications. For queries, it logs calls to prepare(), do(), select*. For results, it logs calls to do(), select*, fetch*. Compared to Log::ger::For::DBI, it produces a bit less noise if you are only concerned with logging queries. ENVIRONMENT LOG_SQL_QUERY (bool, default 1) LOG_SQL_RESULT (bool, default 1) SEE ALSO Log::ger::DBI::QueryResult Log::ger::For::DBI which logs more methods, including connect(), etc..