1/* 2 * Copyright (c) 2021 Huawei Device Co., Ltd. 3 * Licensed under the Apache License, Version 2.0 (the "License"); 4 * you may not use this file except in compliance with the License. 5 * You may obtain a copy of the License at 6 * 7 * http://www.apache.org/licenses/LICENSE-2.0 8 * 9 * Unless required by applicable law or agreed to in writing, software 10 * distributed under the License is distributed on an "AS IS" BASIS, 11 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. 12 * See the License for the specific language governing permissions and 13 * limitations under the License. 14 */ 15 16with list as (select ta.id,type, ts, dur, ta.cpu, itid as utid, state 17 ,ts-tb.start_ts as startTime,tc.tid,tc.pid,tc.process,tc.thread 18from thread_state ta,trace_section tb 19left join ( 20 select it.id,tid,pid,ip.name as process,it.name as thread from thread as it left join process ip on it.ipid = ip.id 21 ) tc on ta.itid = tc.id 22where tc.pid = %d 23 and startTime between %s and %s 24and ta.cpu is not null 25order by startTime ) 26select * from list order by random() limit %s;