Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Jifty::Plugin::SQLQuerUser3Contributed Perl DocumeJifty::Plugin::SQLQueries(3)

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.32.1			  2013-01-29	  Jifty::Plugin::SQLQueries(3)

NAME | DESCRIPTION | USAGE | METHODS | COPYRIGHT AND LICENSE

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Jifty::Plugin::SQLQueries&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help