Hi Billy Liu, the following is the bad queries：
2017-12-27 15:15:02,909 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 42.165 seconds
(project:vtn, thread: 0x10d2, user:kylin) -- select max(dur) as yv, t2.yf,
t2.nb, t2.nv
from kylin_ct t1
left join kylin_lt t2 on t1.nv=t2.nv
where t1.ft >= ? and t1.ft <= ?
and t2.yf is not null
group by t2.yf, t2.nb, t2.nv
order by 1 desc
limit 10 offset 0
2017-12-27 15:15:02,920 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 42.139 seconds
(project:vtn, thread: 0x10c8, user:kylin) -- select max(dur) as yv, t2.yf,
t2.nb, t2.nv
from kylin_ct t1
left join kylin_lt t2 on t1.nv=t2.nv
where t1.ft >= ? and t1.ft <= ?
and t2.yf is not null
group by t2.yf, t2.nb, t2.nv
order by 1 desc
limit 10 offset 0
2017-12-27 15:15:02,930 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 42.132 seconds
(project:vtn, thread: 0x10d0, user:kylin) -- SELECT dtv FROM kylin_ct where
ft >= ? and ft <= ? group by dtv order by 1
2017-12-27 15:16:06,503 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 62.684 seconds
(project:vtn, thread: 0x10ed, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:16:06,513 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 62.652 seconds
(project:vtn, thread: 0x10f4, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:16:06,517 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 62.622 seconds
(project:vtn, thread: 0x10d3, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:16:06,521 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 62.535 seconds
(project:vtn, thread: 0x10ee, user:kylin) -- select count(distinct t2.yf)
from kylin_ct t1
left join kylin_lt t2 on t1.nv=t2.nv
where t1.ft >= ? and t1.ft <= ?
and t2.yf is not null
2017-12-27 15:16:06,529 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 62.32 seconds
(project:vtn, thread: 0x10ec, user:kylin) -- select dg as aaa, count(*) as
bbb
from kylin_ct
where ft >= ? and ft <= ? and dtv = ?
group by dg
order by 1 desc
2017-12-27 15:16:06,539 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 57.732 seconds
(project:vtn, thread: 0x6f, user:kylin) -- select t1.mn as aaa, count(*) as
bbb
from kylin_rl t1
left join kylin_ct t2
on t1.to = t2.to
where t2.ft >= ? and t2.ft <= ? and t2.dtv = ? and t1.mn is not null
group by t1.mn
order by 2 desc
2017-12-27 15:16:06,547 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 57.363 seconds
(project:vtn, thread: 0x10ca, user:kylin) -- select t1.mn as aaa, count(*)
as bbb
from kylin_rl t1
left join kylin_ct t2
on t1.to = t2.to
where t2.ft >= ? and t2.ft <= ? and t2.dtv = ? and t1.mn is not null
group by t1.mn
order by 2 desc
2017-12-27 15:16:06,580 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 56.87 seconds
(project:vtn, thread: 0x10d6, user:kylin) -- select t1.mn as aaa, count(*)
as bbb
from kylin_rl t1
left join kylin_ct t2
on t1.to = t2.to
where t2.ft >= ? and t2.ft <= ? and t2.dtv = ? and t1.mn is not null
group by t1.mn
order by 2 desc
2017-12-27 15:17:14,564 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.846 seconds
(project:vtn, thread: 0x109c, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:17:14,573 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.829 seconds
(project:vtn, thread: 0x10cb, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:17:14,578 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.829 seconds
(project:vtn, thread: 0x1096, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:17:14,583 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.829 seconds
(project:vtn, thread: 0x10f6, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:17:14,590 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.807 seconds
(project:vtn, thread: 0x10f0, user:kylin) -- select t2.vvd as aaa, count(*)
as bbb
from kylin_ct t2
where t2.ft >= ? and t2.ft <= ? and t2.dtv = ? and t2.vvd is not
null
group by t2.vvd
order by 2 desc
2017-12-27 15:17:14,595 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.807 seconds
(project:vtn, thread: 0x1109, user:kylin) -- select t2.vvd as aaa, count(*)
as bbb
from kylin_ct t2
where t2.ft >= ? and t2.ft <= ? and t2.dtv = ? and t2.vvd is not
null
group by t2.vvd
order by 2 desc
2017-12-27 15:17:14,602 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 62.731 seconds
(project:vtn, thread: 0x10d5, user:kylin) -- select dg as aaa, count(*) as
bbb
from kylin_ct
where ft >= ? and ft <= ? and dtv = ?
group by dg
order by 1 desc
2017-12-27 15:17:14,607 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 62.675 seconds
(project:vtn, thread: 0x1107, user:kylin) -- select dg as aaa, count(*) as
bbb
from kylin_ct
where ft >= ? and ft <= ? and dtv = ?
group by dg
order by 1 desc
2017-12-27 15:18:22,611 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.807 seconds
(project:vtn, thread: 0x10f5, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:18:22,619 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.784 seconds
(project:vtn, thread: 0x111b, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:18:22,631 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 67.777 seconds
(project:vtn, thread: 0x111c, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:19:33,336 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 70.254 seconds
(project:vtn, thread: 0x112a, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:19:33,356 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 70.129 seconds
(project:vtn, thread: 0x112b, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:19:33,375 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 70.129 seconds
(project:vtn, thread: 0x112e, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:19:33,397 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 70.128 seconds
(project:vtn, thread: 0x112c, user:kylin) -- select COALESCE(t2.nb,'wm') as
aaa, count(*) as bbb
from kylin_ct t1
left join kylin_lt t2
on t1.nv = t2.nv
where t1.ft >= ? and t1.ft <= ? and t1.dtv = ?
group by t2.nb
order by 2 desc
2017-12-27 15:28:49,402 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 954.656 seconds
(project:vtn, thread: 0x10be, user:kylin) -- select t2.pm as aaa, count(*)
as bbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft = ?
AND t2.lzpo=?
group by t2.pm
order by 1
2017-12-27 15:28:49,421 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 954.621 seconds
(project:vtn, thread: 0x62, user:kylin) -- select case when T2.pm='' then
'qd' else T2.pm end AS oaaa, 'all' as raaa, 'all' as taaa, count(*) as tbbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft='20171222'
AND t2.lzpo='999999999999'
group by t2.pm
order by 4 desc
limit 10 offset 0
2017-12-27 15:29:41,078 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 902.948 seconds
(project:vtn, thread: 0x70, user:kylin) -- select case when T2.pm='' then
'qd' else T2.pm end AS oaaa, 'all' as raaa, 'all' as taaa, count(*) as tbbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft='20171222'
AND t2.lzpo='999999999999'
group by t2.pm
order by 4 desc
limit 10 offset 0
2017-12-27 15:29:41,093 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 902.947 seconds
(project:vtn, thread: 0x10bd, user:kylin) -- select t2.pm as aaa, count(*)
as bbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft = ?
AND t2.lzpo=?
group by t2.pm
order by 1
2017-12-27 15:29:41,117 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 902.939 seconds
(project:vtn, thread: 0x109d, user:kylin) -- select chy as aaa, count(*) as
bbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft=?
AND t2.lzpo=?
group by chy
order by 1
2017-12-27 15:29:41,133 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 143.617 seconds
(project:vtn, thread: 0x1108, user:kylin) -- SELECT aaa, to
from kylin_rl
order by to
2017-12-27 15:31:15,931 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 1158.123 seconds
(project:vtn, thread: 0x72, user:kylin) -- select chy as aaa, count(*) as
bbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft=?
AND t2.lzpo=?
group by chy
order by 1
2017-12-27 15:31:15,957 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 1158.108 seconds
(project:vtn, thread: 0x10a0, user:kylin) -- select t2.pm as aaa, count(*)
as bbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft = ?
AND t2.lzpo=?
group by t2.pm
order by 1
2017-12-27 15:31:15,973 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 1158.106 seconds
(project:vtn, thread: 0x1091, user:kylin) -- select case when T2.pm='' then
'qd' else T2.pm end AS oaaa, 'all' as raaa, 'all' as taaa, count(*) as tbbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft='20171130'
AND t2.lzpo='999999999999'
group by t2.pm
order by 4 desc
limit 10 offset 0
2017-12-27 15:31:15,987 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 1146.356 seconds
(project:vtn, thread: 0x109a, user:kylin) -- select chy as aaa, count(*) as
bbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft=?
AND t2.lzpo=?
group by chy
order by 1
2017-12-27 15:31:58,720 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 1146.352 seconds
(project:vtn, thread: 0x6e, user:kylin) -- select case when T2.pm='' then
'qd' else T2.pm end AS oaaa, 'all' as raaa, 'all' as taaa, count(*) as tbbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft='20171222'
AND t2.lzpo='999999999999'
group by t2.pm
order by 4 desc
limit 10 offset 0
2017-12-27 15:32:45,131 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 1146.351 seconds
(project:vtn, thread: 0x64, user:kylin) -- select t2.pm as aaa, count(*) as
bbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft = ?
AND t2.lzpo=?
group by t2.pm
order by 1
2017-12-27 15:35:09,691 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 1144.388 seconds
(project:vtn, thread: 0x73, user:kylin) -- select chy as aaa, count(*) as
bbb
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_rl t3 on t1.to=t3.to
left join kylin_lt t4 on t1.nv = t4.nv
where t1.ft=?
AND t2.lzpo=?
group by chy
order by 1
2017-12-27 15:59:06,605 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 11.267 seconds
(project:vtn, thread: 0xce, user:kylin) -- select count(distinct pm)
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_lt t3 on t1.nv = t3.nv
where t2.lzpo='999999999999'
and t1.ft >= '20171001' and t1.ft <= '20171231'
2017-12-27 15:59:06,667 INFO [BadQueryDetector]
service.BadQueryDetector:179 : Slow query has been running 10.569 seconds
(project:vtn, thread: 0xd0, user:kylin) -- select count(distinct pm)
from kylin_ct t1
left JOIN kylin_lo T2 ON T1.po=T2.po
left join kylin_lt t3 on t1.nv = t3.nv
where t2.lzpo='999999999999'
and t1.ft >= '20170101' and t1.ft <= '20171231'
--
Sent from: http://apache-kylin.74782.x6.nabble.com/
