Jifty::Plugin::SQLQueries(3pm)				User Contributed Perl Documentation			    Jifty::Plugin::SQLQueries(3pm)

NAME

       Jifty::Plugin::SQLQueries - Inspect your application's SQL queries

DESCRIPTION

       This plugin will log each SQL query, its duration, its bind parameters, and its stack trace. Such reports are available at:

	   http://your.app/__jifty/admin/requests

USAGE

       Add the following to your site_config.yml

	framework:
	  Plugins:
	    - SQLQueries: {}

       You can turn on and off the stacktrace, as well as an "EXPLAIN" of each query, using options to the plugin:

	framework:
	  Plugins:
	    - SQLQueries:
		stacktrace: 0
		explain: 1

       The plugin defaults to logging the stack trace, but not the explain.

METHODS

   init
       Sets up a "post_init" hook.

   inspect_before_request
       Clears the query log so we don't log any unrelated previous queries.

   inspect_after_request
       Stash the query log.

   inspect_render_summary
       Display how many queries and their total time.

   inspect_render_analysis
       Render a template with all the detailed information.

   post_init
       Tells Jifty::DBI to log queries in a way that records stack traces.

   prereq_plugins
       This plugin depends on Jifty::Plugin::RequestInspector.

COPYRIGHT AND LICENSE

       Copyright 2007-2010 Best Practical Solutions

       This is free software and may be modified and distributed under the same terms as Perl itself.

perl v5.14.2							    2010-12-10					    Jifty::Plugin::SQLQueries(3pm)