GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  JIFTY::PLUGIN::SQLQUERIES (3)

.ds Aq ’

NAME

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

CONTENTS

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.

Search for    or go to Top of page |  Section 3 |  Main Index


perl v5.20.3 JIFTY::PLUGIN::SQLQUERIES (3) 2010-12-10

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.