summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorByron Jones <bjones@mozilla.com>2012-03-22 07:15:12 +0100
committerByron Jones <bjones@mozilla.com>2012-03-22 07:15:12 +0100
commit6af883e17f343b8db399befba0cbec21f4f0cee3 (patch)
tree74c353b867a32984cac429292cd17c74782bf73b
parent76c90bb4e3390f5622e0426292921876be650b9c (diff)
downloadbugzilla-6af883e17f343b8db399befba0cbec21f4f0cee3.tar.gz
bugzilla-6af883e17f343b8db399befba0cbec21f4f0cee3.tar.xz
Bug 732440: Add SQL execution timings to buglist.cgi's debug output
r=LpSolit, r=LpSolit
-rwxr-xr-xbuglist.cgi3
-rw-r--r--skins/standard/buglist.css2
-rw-r--r--template/en/default/list/list.html.tmpl11
3 files changed, 11 insertions, 5 deletions
diff --git a/buglist.cgi b/buglist.cgi
index 98b10a75d..3e7aadf2c 100755
--- a/buglist.cgi
+++ b/buglist.cgi
@@ -32,6 +32,7 @@ use Bugzilla::Status;
use Bugzilla::Token;
use Date::Parse;
+use Time::HiRes qw(gettimeofday tv_interval);
my $cgi = Bugzilla->cgi;
my $dbh = Bugzilla->dbh;
@@ -792,8 +793,10 @@ $::SIG{TERM} = 'DEFAULT';
$::SIG{PIPE} = 'DEFAULT';
# Execute the query.
+my $start_time = [gettimeofday()];
my $buglist_sth = $dbh->prepare($query);
$buglist_sth->execute();
+$vars->{query_time} = tv_interval($start_time);
################################################################################
diff --git a/skins/standard/buglist.css b/skins/standard/buglist.css
index 010cd11e8..b4920c609 100644
--- a/skins/standard/buglist.css
+++ b/skins/standard/buglist.css
@@ -107,7 +107,7 @@ td.bz_total {
margin-top: .25em;
}
-.bz_query_explain {
+.bz_query_debug {
text-align: left;
}
diff --git a/template/en/default/list/list.html.tmpl b/template/en/default/list/list.html.tmpl
index f6a688c5f..6c600c6fa 100644
--- a/template/en/default/list/list.html.tmpl
+++ b/template/en/default/list/list.html.tmpl
@@ -68,10 +68,13 @@
</span>
[% IF debug %]
- <p class="bz_query">[% query FILTER html %]</p>
- [% IF query_explain.defined %]
- <pre class="bz_query_explain">[% query_explain FILTER html %]</pre>
- [% END %]
+ <div class="bz_query_debug">
+ <p>[% query FILTER html %]</p>
+ <p>Execution time: [% query_time FILTER html %] seconds</p>
+ [% IF query_explain.defined %]
+ <pre>[% query_explain FILTER html %]</pre>
+ [% END %]
+ </div>
[% END %]
[% IF user.settings.display_quips.value == 'on' %]