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	-604475720	5	0	2024	false	10-Mar 06:03:48
select b.id c0, b.title c1, b.body c2, b.resolution c3, b.reported_version c4, b.fixed_version c5, b.duplicate_of c6, b.cretime c7, b.updtime c8 , u.id c9, u.email c10, u.name c11, u.pwd c12, u.salt c13, u.last_login c14, u.cookie_login c15, u.error_count c16, u.reset_code c17, u.reset_time c18, u.cretime c19, u.updtime c20, u.status_code c21 , a.id c22, a.email c23, a.name c24, a.pwd c25, a.salt c26, a.last_login c27, a.cookie_login c28, a.error_count c29, a.reset_code c30, a.reset_time c31, a.cretime c32, a.updtime c33, a.status_code c34 , p.id c35, p.name c36, p.sort_order c37, p.cretime c38, p.updtime c39 , c.code c40, c.title c41, c.sort_order c42 , t.code c43, t.title c44 , s.code c45, s.title c46 , e.id c47, e.title c48, e.post_date c49, e.body c50, e.cretime c51, e.updtime c52, e.bug_id c53 , eu.id c54, eu.email c55, eu.name c56, eu.pwd c57, eu.salt c58, eu.last_login c59, eu.cookie_login c60, eu.error_count c61, eu.reset_code c62, eu.reset_time c63, eu.cretime c64, eu.updtime c65, eu.status_code c66 from b_bug b left outer join s_user u on b.user_assigned_id = u.id 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: false Started Collecting Statistics: 04-Mar 12:29 Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Bug	-604475720	707	0	1789	true	10-Mar 09:42:57
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: 04-Mar 12:31 Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Topic	722532051	17	0	1614	true	10-Mar 00:05:24
select t.id c0, t.open c1, t.title c2, t.body c3, t.editor_note c4, t.post_count c5, t.rating_count c6, t.rating_total c7, t.cretime c8, t.updtime c9, t.type_code c10, t.user_id c11, t.forum_id c12 from f_topic t where t.id = ? Autofetch Tuned: true Started Collecting Statistics: 04-Mar 12:29 Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)
detail	app.data.Bug	-604475720	15	0	1470	true	10-Mar 07:40:19
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.user_id c25, e.updtime c26 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 where b.id = ? order by b.id , e.id asc Autofetch Tuned: true Started Collecting Statistics: 06-Mar 03:47 Origin key: -604475720:509217749 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Bug	993345720	1560	10	1417	true	10-Mar 07:40:25
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: 04-Mar 13:59 Origin key: 993345720:-1061479707 app.comp.RecentBugs.findList(RecentBugs.java:40)
detail	app.data.Bug	-1305179324	108	3	1364	true	10-Mar 09:26:03
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: 04-Mar 13:59 Origin key: -1305179324:-880739087 app.comp.TopBugs.findList(TopBugs.java:44)
detail	app.data.Topic	722532051	2212	0	1235	true	10-Mar 09:45:10
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: 04-Mar 12:30 Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)
detail	app.data.Topic	592257536	959	20	868	true	10-Mar 09:34:45
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: 04-Mar 12:51 Origin key: 592257536:-202885630 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:39)
detail	app.data.User	1932188223	33	0	688	false	10-Mar 00:01:38
select u.id c0, u.email c1, u.name c2, u.pwd c3, u.salt c4, u.last_login c5, u.cookie_login c6, u.error_count c7, u.reset_code c8, u.reset_time c9, u.cretime c10, u.updtime c11, u.status_code c12 from s_user u where u.id = ? Autofetch Tuned: false Started Collecting Statistics: 04-Mar 12:27 Origin key: 1932188223:-1245660067 app.global.usercontext.UserManager.loginAuto(UserManager.java:176)
detail	app.data.Forum	887892902	103	5	667	true	10-Mar 07:58:56
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: 04-Mar 15:34 Origin key: 887892902:154414995 app.comp.init.ForumListInit.initialise(ForumListInit.java:22)

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	2212	0	1235	true	10-Mar 09:45:10
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: 04-Mar 12:30 Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)
detail	app.data.Bug	993345720	1560	10	1417	true	10-Mar 07:40:25
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: 04-Mar 13:59 Origin key: 993345720:-1061479707 app.comp.RecentBugs.findList(RecentBugs.java:40)
detail	app.data.Bug	-604475720	707	0	1789	true	10-Mar 09:42:57
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: 04-Mar 12:31 Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Topic	592257536	959	20	868	true	10-Mar 09:34:45
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: 04-Mar 12:51 Origin key: 592257536:-202885630 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:39)
detail	app.data.Forum	722532051	2222	0	286	false	10-Mar 09:45:10
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: 04-Mar 12:28 Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)
detail	app.data.Forum	1908865224	959	0	587	true	10-Mar 09:34:45
select f.id c0, f.title c1, f.updtime c2 from f_forum f where f.id = ? Autofetch Tuned: true Started Collecting Statistics: 04-Mar 12:51 Origin key: 1908865224:1634510449 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:24)
detail	app.data.BugAttachment	-604475720	729	0	428	false	10-Mar 09:42:57
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: 04-Mar 12:29 Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)
detail	app.data.Bug	-1305179324	108	3	1364	true	10-Mar 09:26:03
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: 04-Mar 13:59 Origin key: -1305179324:-880739087 app.comp.TopBugs.findList(TopBugs.java:44)
detail	app.data.Topic	-149309933	515	5	265	true	10-Mar 07:58:56
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: 04-Mar 15:34 Origin key: -149309933:-865332634 app.comp.init.ForumListInit.initialise(ForumListInit.java:35)
detail	app.data.Forum	887892902	103	5	667	true	10-Mar 07:58:56
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: 04-Mar 15:34 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