]>
Commit | Line | Data |
---|---|---|
84fb5b46 MKG |
1 | %# BEGIN BPS TAGGED BLOCK {{{ |
2 | %# | |
3 | %# COPYRIGHT: | |
4 | %# | |
320f0092 | 5 | %# This software is Copyright (c) 1996-2014 Best Practical Solutions, LLC |
84fb5b46 MKG |
6 | %# <sales@bestpractical.com> |
7 | %# | |
8 | %# (Except where explicitly superseded by other copyright notices) | |
9 | %# | |
10 | %# | |
11 | %# LICENSE: | |
12 | %# | |
13 | %# This work is made available to you under the terms of Version 2 of | |
14 | %# the GNU General Public License. A copy of that license should have | |
15 | %# been provided with this software, but in any event can be snarfed | |
16 | %# from www.gnu.org. | |
17 | %# | |
18 | %# This work is distributed in the hope that it will be useful, but | |
19 | %# WITHOUT ANY WARRANTY; without even the implied warranty of | |
20 | %# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
21 | %# General Public License for more details. | |
22 | %# | |
23 | %# You should have received a copy of the GNU General Public License | |
24 | %# along with this program; if not, write to the Free Software | |
25 | %# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA | |
26 | %# 02110-1301 or visit their web page on the internet at | |
27 | %# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html. | |
28 | %# | |
29 | %# | |
30 | %# CONTRIBUTION SUBMISSION POLICY: | |
31 | %# | |
32 | %# (The following paragraph is not intended to limit the rights granted | |
33 | %# to you to modify and distribute this software under the terms of | |
34 | %# the GNU General Public License and is only of importance to you if | |
35 | %# you choose to contribute your changes and enhancements to the | |
36 | %# community by submitting them to Best Practical Solutions, LLC.) | |
37 | %# | |
38 | %# By intentionally submitting any modifications, corrections or | |
39 | %# derivatives to this work, or any other work intended for use with | |
40 | %# Request Tracker, to Best Practical Solutions, LLC, you confirm that | |
41 | %# you are the copyright holder for those contributions and you grant | |
42 | %# Best Practical Solutions, LLC a nonexclusive, worldwide, irrevocable, | |
43 | %# royalty-free, perpetual, license to use, copy, create derivative | |
44 | %# works based on those contributions, and sublicense and distribute | |
45 | %# those contributions and any derivatives thereof. | |
46 | %# | |
47 | %# END BPS TAGGED BLOCK }}} | |
48 | <%init> | |
49 | my $title = loc('SQL Queries'); | |
50 | unless ($session{'CurrentUser'}->HasRight( Object=> $RT::System, Right => 'SuperUser')) { | |
51 | Abort(loc('This feature is only available to system administrators.')); | |
52 | } | |
53 | </%init> | |
54 | <& /Admin/Elements/Header, Title => $title &> | |
55 | <& /Elements/Tabs &> | |
af59614d | 56 | <script type="text/javascript" src="<%RT->Config->Get('WebPath')%>/static/js/jquery.tablesorter.min.js"></script> |
84fb5b46 MKG |
57 | |
58 | <&|/Widgets/TitleBox, title => loc('SQL Queries') &> | |
59 | % my $history = $RT::Handle->QueryHistory; | |
60 | % if (!RT->Config->Get('StatementLog')) { | |
61 | <p><&|/l&>You must set StatementLog to true to enable this query history page.</&></p> | |
62 | % } elsif (!$history) { | |
63 | <p><&|/l&>This server process has recorded no SQL queries.</&></p> | |
64 | % } else { | |
65 | <script type="text/javascript"> | |
66 | jQuery(function () { jQuery(".tablesorter").tablesorter(); }); | |
67 | </script> | |
68 | ||
69 | <ol> | |
70 | % my $r = 0; | |
71 | % for my $request (@$history) { | |
72 | % ++$r; | |
73 | ||
74 | % my ($seconds, $count) = (0, 0); | |
75 | % for my $statement (@{ $request->{Queries} }) { | |
76 | % $seconds += $statement->[3]; | |
77 | % $count++; | |
78 | % } | |
79 | ||
80 | <li> | |
81 | <tt><% $request->{Path} %></tt> - <i><&|/l, sprintf('%.4f', $seconds) &>[_1]s</&></i> | |
82 | <a href="#" onclick="return hideshow(<% "queries-$r" |n,j%>);"><&|/l, $count &>Toggle [quant,_1,query,queries]</&></a> | |
83 | <table id="queries-<%$r%>" class="tablesorter hidden"> | |
84 | <thead> | |
85 | <tr> | |
86 | <th><&|/l&>index</&></th> | |
87 | <th><&|/l&>duration</&></th> | |
88 | <th><&|/l&>statement</&></th> | |
89 | </tr> | |
90 | </thead> | |
91 | <tbody> | |
92 | % my $s = 0; | |
93 | % my @undup; | |
94 | % for my $statement (@{ $request->{Queries} }) { | |
95 | % my ($dup) = grep {$_->[1] eq $statement->[1]} @undup[-(@undup > 3?3:@undup)..-1]; | |
96 | % if ($dup) { | |
97 | % $dup->[2] = [$dup->[2]] unless $dup->[5]; | |
98 | % push @{$dup->[2]}, $statement->[2]; | |
99 | % $dup->[3] += $statement->[3]; | |
100 | % $dup->[5] ||= 1; $dup->[5]++; | |
101 | % } else { | |
102 | % push @undup, $statement; | |
103 | % } | |
104 | % } | |
105 | % for my $statement (@undup) { | |
106 | % my ( $time, $sql, $bind, $duration, $trace, $dup ) = @$statement; | |
107 | % $sql = $RT::Handle->FillIn($sql, $bind) unless $dup; | |
108 | <tr> | |
109 | <td><% ++$s %><% $dup ? " (x $dup)" : "" %></td> | |
110 | <td><i><&|/l, sprintf('%.4f', $duration) &>[_1]s</&></i></td> | |
111 | <td> | |
112 | <tt><% $sql %></tt> | |
113 | % if ($dup and @{$bind->[0]}) { | |
114 | % for my $b (@{$bind}) { | |
115 | <br><tt>[<% join(", ", @$b) %>]</tt> | |
116 | % } | |
117 | % } | |
118 | <a class="query-stacktrace-toggle" href="#" onclick="return hideshow(<% "trace-$r-$s" |n,j%>);"><&|/l &>Toggle stack trace</&></a> | |
119 | <pre id="trace-<%$r%>-<%$s%>" class="hidden"><% $trace %></pre> | |
120 | </td> | |
121 | </tr> | |
122 | % } | |
123 | </tbody> | |
124 | </table> | |
125 | </li> | |
126 | % } | |
127 | </ol> | |
128 | % } | |
129 | </&> |