Check the DBI documentation for information on the trace method. Turning on tracing on a handle (statement or database connection) makes DBI dump out information about what it's doing as it passes requests through to the database. Something like $sth->trace(2) will probably give you enough detail to see the entire query.