Request Information
Trace Tools Parameters | Headers | Stages | Database Requests | Execution Trace

Parameters
Request Start Time: Fri Jul 29 15:03:15 PDT 2005
Request Completion Time: Fri Jul 29 15:03:15 PDT 2005
Request Duration: 132ms
IP: 172.31.0.5
Method: GET
URL: /jatt/tasks.do
Query:
Request Parameters: (display)

HTTP Request Headers
accept text/xml, application/xml, application/xhtml+xml, text/html;q=0.9, text/plain;q=0.8, image/png, image/jpeg, image/gif;q=0.2, */*;q=0.1
accept-charset ISO-8859-15, utf-8;q=0.7, *;q=0.7
accept-language en, de;q=0.5
connection close
cookie JSESSIONID=156AB647C98876B3FB52357C26D788CE
host tomcat.example.com
referer http://tomcat.example.com/jatt/editUser.do?id=1
user-agent Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040204 Galeon/1.3.12

Stages
StageTimeQueriesProcessing
 wattFilter* 132ms 27ms (5 queries) 105ms

Database Requests
Total Queries: 5
Total Time: 27ms
ID Duration Conn Command
1 (duplicated) 1ms 10594949 SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1

BINDS: {}
2 2ms 10594949 SELECT t.id AS id, ws.stop AS stop FROM jatt_task AS t INNER JOIN jatt_worksession AS ws ON ws.task_id = t.id WHERE t.user_id = 1 ORDER BY ws.stop DESC;

BINDS: {}
3 (duplicates # 1) 0ms 10594949 SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1

BINDS: {}
4 23ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=2

BINDS: {}
5 1ms 10594949 SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=4

BINDS: {}

Long running Database Requests
Total Queries: 5
Total Query Execution Time: 27ms
Average Query Execution Time: 5ms
Query # Query Text Duration # % of Total Query
exec Time #
Query # 4 SELECT user_id,amendment,unexpected,rank,description,pare... 23ms 0.8518518518518519
Query # 2 SELECT t.id AS id, ws.stop AS stop FROM jatt_task A... 2ms 0.07407407407407407
Query # 1 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 1ms 0.037037037037037035
Query # 5 SELECT user_id,amendment,unexpected,rank,description,pare... 1ms 0.037037037037037035
Query # 3 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 0ms 0.0

Duplicate DB Requests
Total Queries: 5
Total Query Execution Time: 27ms
Average Query Execution Time: 5ms
Query # Query text Duplicates Total Query time % of Total Query
exec Time #
Query # 1 SELECT user_id,start,task_id,comment FROM jatt_worksessio... 3 1ms 0.037037037037037035
Total 2 1ms 0.037037037037037035