Query Statistics

Top 10 Queries by Average execution time

	bean	orig hash	exe count	avg beans	avg micros	autofetch tuned	last query
detail	app.data.Bug	993345720	33237	12	1839	true	05-Feb 09:36:20
select b.id c0, b.updtime c1, b.title c2, b.type_code c3 , a.id c4, a.updtime c5 , p.id c6, p.updtime c7 , c.code c8, c.title c9 , s.code c10 from b_bug b left outer join s_user a on b.user_logged_id = a.id join b_product p on b.product_id = p.id join b_bug_priority c on b.priority_code = c.code join b_bug_status s on b.status_code = s.code where b.fixed_version like ? and b.type_code in ( ?, ? ) order by b.id desc Autofetch Tuned: true Started Collecting Statistics: 11-Aug 11:43 Origin key: 993345720:-1061479707 app.comp.RecentBugs.findList(RecentBugs.java:40)
detail	app.data.Bug	-604475720	37426	0	1785	true	05-Feb 11:36:11
select b.id c0, b.updtime c1, b.body c2, b.reported_version c3, b.fixed_version c4, b.title c5, b.user_assigned_id c6, b.cretime c7, b.duplicate_of c8 , a.id c9, a.name c10, a.updtime c11 , p.id c12, p.name c13, p.updtime c14 , c.code c15, c.title c16 , t.code c17, t.title c18 , s.code c19, s.title c20 , e.id c21, e.body c22, e.title c23, e.cretime c24, e.updtime c25 , eu.id c26, eu.name c27, eu.updtime c28 from b_bug b left outer join s_user a on b.user_logged_id = a.id join b_product p on b.product_id = p.id join b_bug_priority c on b.priority_code = c.code join b_bug_type t on b.type_code = t.code join b_bug_status s on b.status_code = s.code left outer join b_bug_detail e on b.id = e.bug_id left outer join s_user eu on e.user_id = eu.id where b.id = ? order by b.id , e.id asc Autofetch Tuned: true Started Collecting Statistics: 11-Aug 14:04 Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Bug	-1305179324	1991	9	1749	true	05-Feb 10:30:31
select b.id c0, b.updtime c1, b.title c2, b.type_code c3 , p.id c4, p.updtime c5 , c.code c6, c.title c7 , s.code c8, s.title c9 , e.id c10, e.updtime c11 from b_bug b join b_product p on b.product_id = p.id join b_bug_priority c on b.priority_code = c.code join b_bug_status s on b.status_code = s.code left outer join b_bug_detail e on b.id = e.bug_id left outer join s_user u on b.user_assigned_id = u.id where b.status_code in (?,?) and b.type_code in (?) order by u.name desc , b.id, e.id asc Autofetch Tuned: true Started Collecting Statistics: 11-Aug 11:43 Origin key: -1305179324:-880739087 app.comp.TopBugs.findList(TopBugs.java:44)
detail	app.data.Topic	722532051	61558	0	1127	true	05-Feb 11:06:25
select t.id c0, t.body c1, t.forum_id c2, t.title c3, t.cretime c4, t.updtime c5 , u.id c6, u.name c7, u.updtime c8 , p.id c9, p.body c10, p.cretime c11, p.updtime c12 , pu.id c13, pu.name c14, pu.updtime c15 from f_topic t join s_user u on t.user_id = u.id left outer join f_topic_post p on t.id = p.topic_id left outer join s_user pu on p.user_id = pu.id where t.id = ? order by t.id Autofetch Tuned: true Started Collecting Statistics: 11-Aug 10:19 Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)
detail	app.data.Topic	592257536	35513	23	906	true	05-Feb 11:36:32
select t.id c0, t.updtime c1, t.title c2, t.post_count c3 from f_topic t where t.forum_id = ? order by t.updtime desc limit 51 Autofetch Tuned: true Started Collecting Statistics: 11-Aug 10:19 Origin key: 592257536:-202885630 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:39)
detail	app.data.Forum	887892902	1795	5	596	true	05-Feb 10:24:03
select f.id c0, f.title c1, f.updtime c2 from f_forum f order by f.sort_order Autofetch Tuned: true Started Collecting Statistics: 11-Aug 18:58 Origin key: 887892902:154414995 app.comp.init.ForumListInit.initialise(ForumListInit.java:22)
detail	app.data.Forum	1908865224	35513	0	555	true	05-Feb 11:36:32
select f.id c0, f.title c1, f.updtime c2 from f_forum f where f.id = ? Autofetch Tuned: true Started Collecting Statistics: 11-Aug 10:19 Origin key: 1908865224:1634510449 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:24)
detail	app.data.BugAttachment	-604475720	37436	0	386	false	05-Feb 11:36:11
select a.id c0, a.file_name c1, a.file_path c2, a.abstract c3, a.file_size c4, a.cretime c5, a.updtime c6, a.bug_id c7 from b_bug_attachment a where a.bug_id = ? Autofetch Tuned: false Started Collecting Statistics: 11-Aug 10:03 Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Forum	722532051	61567	0	278	false	05-Feb 11:06:25
select f.id c0, f.title c1, f.topic_count c2, f.sort_order c3, f.cretime c4, f.updtime c5 from f_forum f where f.id = ? Autofetch Tuned: false Started Collecting Statistics: 11-Aug 10:11 Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)
detail	app.data.Topic	-149309933	8975	5	220	true	05-Feb 10:24:03
select t.id c0, t.updtime c1, t.title c2, t.post_count c3 from f_topic t where t.forum_id = ? order by t.updtime desc limit 6 Autofetch Tuned: true Started Collecting Statistics: 11-Aug 18:58 Origin key: -149309933:-865332634 app.comp.init.ForumListInit.initialise(ForumListInit.java:35)

Top 10 Queries by Total aggregate execution time

	bean	orig hash	exe count	avg beans	avg micros	autofetch tuned	last query
detail	app.data.Topic	722532051	61558	0	1127	true	05-Feb 11:06:25
select t.id c0, t.body c1, t.forum_id c2, t.title c3, t.cretime c4, t.updtime c5 , u.id c6, u.name c7, u.updtime c8 , p.id c9, p.body c10, p.cretime c11, p.updtime c12 , pu.id c13, pu.name c14, pu.updtime c15 from f_topic t join s_user u on t.user_id = u.id left outer join f_topic_post p on t.id = p.topic_id left outer join s_user pu on p.user_id = pu.id where t.id = ? order by t.id Autofetch Tuned: true Started Collecting Statistics: 11-Aug 10:19 Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)
detail	app.data.Bug	-604475720	37426	0	1785	true	05-Feb 11:36:11
select b.id c0, b.updtime c1, b.body c2, b.reported_version c3, b.fixed_version c4, b.title c5, b.user_assigned_id c6, b.cretime c7, b.duplicate_of c8 , a.id c9, a.name c10, a.updtime c11 , p.id c12, p.name c13, p.updtime c14 , c.code c15, c.title c16 , t.code c17, t.title c18 , s.code c19, s.title c20 , e.id c21, e.body c22, e.title c23, e.cretime c24, e.updtime c25 , eu.id c26, eu.name c27, eu.updtime c28 from b_bug b left outer join s_user a on b.user_logged_id = a.id join b_product p on b.product_id = p.id join b_bug_priority c on b.priority_code = c.code join b_bug_type t on b.type_code = t.code join b_bug_status s on b.status_code = s.code left outer join b_bug_detail e on b.id = e.bug_id left outer join s_user eu on e.user_id = eu.id where b.id = ? order by b.id , e.id asc Autofetch Tuned: true Started Collecting Statistics: 11-Aug 14:04 Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Bug	993345720	33237	12	1839	true	05-Feb 09:36:20
select b.id c0, b.updtime c1, b.title c2, b.type_code c3 , a.id c4, a.updtime c5 , p.id c6, p.updtime c7 , c.code c8, c.title c9 , s.code c10 from b_bug b left outer join s_user a on b.user_logged_id = a.id join b_product p on b.product_id = p.id join b_bug_priority c on b.priority_code = c.code join b_bug_status s on b.status_code = s.code where b.fixed_version like ? and b.type_code in ( ?, ? ) order by b.id desc Autofetch Tuned: true Started Collecting Statistics: 11-Aug 11:43 Origin key: 993345720:-1061479707 app.comp.RecentBugs.findList(RecentBugs.java:40)
detail	app.data.Topic	592257536	35513	23	906	true	05-Feb 11:36:32
select t.id c0, t.updtime c1, t.title c2, t.post_count c3 from f_topic t where t.forum_id = ? order by t.updtime desc limit 51 Autofetch Tuned: true Started Collecting Statistics: 11-Aug 10:19 Origin key: 592257536:-202885630 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:39)
detail	app.data.Forum	1908865224	35513	0	555	true	05-Feb 11:36:32
select f.id c0, f.title c1, f.updtime c2 from f_forum f where f.id = ? Autofetch Tuned: true Started Collecting Statistics: 11-Aug 10:19 Origin key: 1908865224:1634510449 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:24)
detail	app.data.Forum	722532051	61567	0	278	false	05-Feb 11:06:25
select f.id c0, f.title c1, f.topic_count c2, f.sort_order c3, f.cretime c4, f.updtime c5 from f_forum f where f.id = ? Autofetch Tuned: false Started Collecting Statistics: 11-Aug 10:11 Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)
detail	app.data.BugAttachment	-604475720	37436	0	386	false	05-Feb 11:36:11
select a.id c0, a.file_name c1, a.file_path c2, a.abstract c3, a.file_size c4, a.cretime c5, a.updtime c6, a.bug_id c7 from b_bug_attachment a where a.bug_id = ? Autofetch Tuned: false Started Collecting Statistics: 11-Aug 10:03 Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Bug	-1305179324	1991	9	1749	true	05-Feb 10:30:31
select b.id c0, b.updtime c1, b.title c2, b.type_code c3 , p.id c4, p.updtime c5 , c.code c6, c.title c7 , s.code c8, s.title c9 , e.id c10, e.updtime c11 from b_bug b join b_product p on b.product_id = p.id join b_bug_priority c on b.priority_code = c.code join b_bug_status s on b.status_code = s.code left outer join b_bug_detail e on b.id = e.bug_id left outer join s_user u on b.user_assigned_id = u.id where b.status_code in (?,?) and b.type_code in (?) order by u.name desc , b.id, e.id asc Autofetch Tuned: true Started Collecting Statistics: 11-Aug 11:43 Origin key: -1305179324:-880739087 app.comp.TopBugs.findList(TopBugs.java:44)
detail	app.data.Topic	-149309933	8975	5	220	true	05-Feb 10:24:03
select t.id c0, t.updtime c1, t.title c2, t.post_count c3 from f_topic t where t.forum_id = ? order by t.updtime desc limit 6 Autofetch Tuned: true Started Collecting Statistics: 11-Aug 18:58 Origin key: -149309933:-865332634 app.comp.init.ForumListInit.initialise(ForumListInit.java:35)
detail	app.data.Forum	887892902	1795	5	596	true	05-Feb 10:24:03
select f.id c0, f.title c1, f.updtime c2 from f_forum f order by f.sort_order Autofetch Tuned: true Started Collecting Statistics: 11-Aug 18:58 Origin key: 887892902:154414995 app.comp.init.ForumListInit.initialise(ForumListInit.java:22)

// code to get Top 10 queries by average execution time 

List<MetaQueryStatistic> list = Ebean.find(MetaQueryStatistic.class).findList();
  	
long nowMinus24Hrs = System.currentTimeMillis() -24*(1000*60*60);

list = Ebean.filter(MetaQueryStatistic.class)
		.sort("avgTimeMicros desc")
		.gt("executionCount", 0)
		.gt("lastQueryTime", nowMinus24Hrs)
		.maxRows(10)
		.filter(list);

Strictly speaking we are looking at Ebean "Query Plans". The query plan can be reused with different 'bind' values.

Heading	Description
orig hash	The original (pre autofetch tuning) query plan hash
exe count	Number of Queries executed
avg beans	Average number of beans loaded per query
avg micros	Average number of microseconds each query execution takes
autofetch tuned	True when the query is tuned by Autofetch
collection start	Time and date when the statistics started being collected