Request Information

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

Parameters

Request Start Time:

Fri Jul 29 15:03:27 PDT 2005

Request Completion Time:

Fri Jul 29 15:03:27 PDT 2005

Request Duration:

297ms

IP:

172.31.0.5

Method:

GET

URL:

/jatt/startWorkSession.do

Query:

task_id=3

Request Parameters: (display)

task_id

3

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/editTask.do?id=3
user-agent	Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040204 Galeon/1.3.12

Stage	Time	Queries	Processing
Stages
wattFilter*	297ms	102ms (13 queries)	195ms

ID	Duration	Conn	Command
Database Requests
Total Queries:			13
Total Time:			102ms
1 (duplicated)	1ms	10594949	SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3 BINDS: {}
2 (duplicated)	1ms	10594949	SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1 BINDS: {}
3	90ms	10594949	INSERT INTO jatt_worksessionstatus (user_id,start,task_id,comment) VALUES (1,'2005-07-29 15:03:27',3,'') BINDS: {}
4 (duplicates # 2)	0ms	10594949	SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1 BINDS: {}
5 (duplicates # 1)	1ms	10594949	SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3 BINDS: {}
6	1ms	10594949	SELECT stop,start,task_id,comment,id FROM jatt_worksession WHERE task_id=3 ORDER BY start DESC BINDS: {}
7 (duplicates # 2)	1ms	10594949	SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1 BINDS: {}
8	1ms	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: {}
9 (duplicates # 2)	1ms	10594949	SELECT user_id,start,task_id,comment FROM jatt_worksessionstatus WHERE user_id=1 BINDS: {}
10 (duplicates # 1)	3ms	10594949	SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3 BINDS: {}
11	0ms	10594949	SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=2 BINDS: {}
12 (duplicates # 1)	1ms	10594949	SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=3 BINDS: {}
13	1ms	10594949	SELECT user_id,amendment,unexpected,rank,description,parent_id,complete,duration,id FROM jatt_task WHERE id=4 BINDS: {}

Query #	Query Text	Duration #	% of Total Query exec Time #
Long running Database Requests
Total Queries:			13
Total Query Execution Time:			102ms
Average Query Execution Time:			7ms
Query # 3	INSERT INTO jatt_worksessionstatus (user_id,start,task_id...	90ms	0.8823529411764706
Query # 10	SELECT user_id,amendment,unexpected,rank,description,pare...	3ms	0.029411764705882353
Query # 1	SELECT user_id,amendment,unexpected,rank,description,pare...	1ms	0.00980392156862745
Query # 2	SELECT user_id,start,task_id,comment FROM jatt_worksessio...	1ms	0.00980392156862745
Query # 5	SELECT user_id,amendment,unexpected,rank,description,pare...	1ms	0.00980392156862745

Query #	Query text	Duplicates	Total Query time	% of Total Query exec Time #
Duplicate DB Requests
Total Queries:				13
Total Query Execution Time:				102ms
Average Query Execution Time:				7ms
Query # 2	SELECT user_id,start,task_id,comment FROM jatt_worksessio...	4 7 9	3ms	0.029411764705882353
Query # 1	SELECT user_id,amendment,unexpected,rank,description,pare...	5 10 12	6ms	0.058823529411764705
Total		8	9ms	0.08823529411764706