View source

If you want to see all the SQL that's being issued you need to set a DBI Trace.

You can either set the DBI_TRACE environment variable

  DBI_TRACE=2 ./myscript.pl

...or log to a file using DBI::ProfileDumper and dbiprof for analysis...

  DBI_PROFILE=DBI::ProfileDumper ./myscript.pl
  dbiprof

...or log to a file using the DBI_TRACE environment variable...

  DBI_TRACE=2=/tmp/logfile ./myscript.pl

...or by adding the following...

  DBI->trace(2 => "/tmp/logfile");

in your code. See the documentation for [http://search.cpan.org/~timb/DBI/lib/DBI/Profile.pm DBI::Profile], [http://search.cpan.org/~timb/DBI/lib/DBI/ProfileDumper.pm DBI::ProfileDumper] and [http://search.cpan.org/~timb/DBI/DBI.pm#TRACING DBI::Trace] for more info.

Another method is to enable logging capabilities of your DBMS. For example in MySQL add '--log' option to command line when starting server.