• Home
  • Line#
  • Scopes#
  • Navigate#
  • Raw
  • Download
1<!DOCTYPE html>
2<html>
3  <head>
4    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
5    <title>des_tables</title>
6
7    <meta name="viewport" content="width=device-width, initial-scale=1.0" />
8
9    <style>
10      code[class*='smartperf-'],
11      pre[class*='smartperf-'] {
12        color: #333333;
13        background: none;
14        font-family: Helvetica;
15        line-height: 1.6;
16        text-align: left;
17        white-space: pre;
18        -moz-tab-size: 9;
19        -o-tab-size: 9;
20        tab-size: 8;
21        -webkit-hyphens: none;
22        -moz-hyphens: none;
23        -ms-hyphens: none;
24        hyphens: none;
25      }
26
27      /* Code blocks */
28      pre[class*='smartperf-'] {
29        padding: 0.9em;
30        overflow: auto;
31        border-radius: 2px;
32        background: #f5f5f4;
33      }
34
35      /* Inline code */
36      :not(pre) > code[class*='smartperf-'] {
37        white-space: normal;
38        background: #fcf8f8;
39        padding: 1px 0.2em;
40        border-radius: 1px 0.3em;
41      }
42
43      .tk.comment,
44      .tk.blockquote {
45        color: #8c918c;
46      }
47
48      .tk.cdata {
49        color: #183898;
50      }
51
52      .tk.doctype,
53      .tk.punctuation,
54      .tk.variable,
55      .tk.macro.property {
56        color: #424242;
57      }
58
59      .tk.operator,
60      .tk.important,
61      .tk.keyword,
62      .tk.rule,
63      .tk.builtin {
64        color: #b71d65;
65      }
66
67      .tk.string,
68      .tk.url,
69      .tk.regex,
70      .tk.attr-value {
71        color: #16338d;
72      }
73
74      .tk.property,
75      .tk.number,
76      .tk.boolean,
77      .tk.entity,
78      .tk.atrule,
79      .tk.constant,
80      .tk.symbol,
81      .tk.command,
82      .tk.code {
83        color: #037aa2;
84      }
85
86      .tk.tag,
87      .tk.selector,
88      .tk.prolog {
89        color: #69ad62;
90      }
91
92      .tk.function,
93      .tk.namespace,
94      .tk.pseudo-element,
95      .tk.class,
96      .tk.class-name,
97      .tk.pseudo-class,
98      .tk.id,
99      .tk.url-reference .tk.variable,
100      .tk.attr-name {
101        color: #775d9d;
102      }
103
104      .tk.entity {
105        cursor: help;
106      }
107
108      .tk.title,
109      .tk.title .tk.punctuation {
110        font-weight: bold;
111        color: #1a3773;
112      }
113
114      .tk.list {
115        color: #f56940;
116      }
117
118      .tk.inserted {
119        background-color: #eaffea;
120        color: #509b2f;
121      }
122
123      .tk.deleted {
124        background-color: #fae1e1;
125        color: #ad2d06;
126      }
127
128      .tk.bold {
129        font-weight: bolder;
130      }
131
132      .tk.italic {
133        font-style: normal;
134      }
135
136      /* JSON */
137      .smartperf-json .tk.property {
138        color: #19358c;
139      }
140
141      .smartperf-markup .tk.tag .tk.punctuation {
142        color: #2c2b2b;
143      }
144
145      /* CSS */
146      code.smartperf-css,
147      .smartperf-css .tk.function {
148        color: #047ca4;
149      }
150
151      /* YAML */
152      .smartperf-yaml .tk.atrule {
153        color: #609b5a;
154      }
155
156      code.smartperf-yaml {
157        color: #153491;
158      }
159
160      /* Ruby */
161      .smartperf-ruby .tk.function {
162        color: #3f3e3e;
163      }
164
165      /* Markdown */
166      .smartperf-markdown .tk.url {
167        color: #6e5298;
168      }
169
170      /* Makefile */
171      .smartperf-makefile .tk.symbol {
172        color: #6c5393;
173      }
174
175      .smartperf-makefile .tk.variable {
176        color: #183488;
177      }
178
179      .smartperf-makefile .tk.builtin {
180        color: #027ba4;
181      }
182
183      /* Bash */
184      .smartperf-bash .tk.keyword {
185        color: #027fa9;
186      }
187
188      /* highlight */
189      pre[dl] {
190        position: relative;
191        padding: 1em 1px 1px 0.9em;
192      }
193
194      pre[dl] .line-highlight-wrapper {
195        position: absolute;
196        top: 1px;
197        left: 1px;
198        background-color: transparent;
199        display: block;
200        width: 99%;
201      }
202
203      pre[dl] .line-highlight {
204        position: absolute;
205        left: 1px;
206        right: 1px;
207        padding: inherit;
208        margin-top: 0.9em;
209        background: hsla(25, 21%, 50%, 0.08);
210        background: linear-gradient(to right, hsla(24, 20%, 50%, 0.1) 70%, hsla(24, 20%, 50%, 0));
211        pointer-events: none;
212        line-height: inherit;
213        white-space: pre;
214      }
215
216      pre[dl] .line-highlight:before,
217      pre[dl] .line-highlight[data-end]:after {
218        content: attr(data-start);
219        position: absolute;
220        text-shadow: none;
221        top: 0.3em;
222        left: 0.7em;
223        min-width: 0.9em;
224        padding: 1px 0.6em;
225        background-color: hsla(24, 20%, 47%, 0.4);
226        color: hsl(20, 11%, 95%);
227        text-align: center;
228        vertical-align: 0.2em;
229        border-radius: 10000px;
230        box-shadow: 1px 2px #fdf6f6;
231      }
232
233      pre[dl] .line-highlight[data-end]:after {
234        content: attr(data-end);
235        top: auto;
236        bottom: 0.5em;
237      }
238
239      html body {
240        line-height: 1.6;
241        font-size: 16px;
242        color: #333333;
243        overflow: initial;
244        background-color: #ffffff;
245        word-wrap: break-word;
246        font-family: Helvetica;
247        box-sizing: border-box;
248      }
249
250      html body > :first-child {
251        margin-top: 0px;
252      }
253
254      html body h1,
255      html body h2,
256      html body h3,
257      html body h4,
258      html body h5,
259      html body h6 {
260        margin-top: 1em;
261        margin-bottom: 16px;
262        color: #000000;
263        line-height: 1.2;
264      }
265
266      html body h1 {
267        font-weight: 300;
268        font-size: 2.25em;
269        padding-bottom: 0.3em;
270      }
271
272      html body h2 {
273        font-weight: 410;
274        font-size: 1.74em;
275        padding-bottom: 0.2em;
276      }
277
278      html body h3 {
279        font-size: 1.6em;
280        font-weight: 501;
281      }
282
283      html body h4 {
284        font-size: 1.26em;
285        font-weight: 601;
286      }
287
288      html body h5 {
289        font-size: 1.2em;
290        font-weight: 601;
291      }
292
293      html body h6 {
294        font-size: 0.9em;
295        font-weight: 601;
296      }
297
298      html body h1,
299      html body h2,
300      html body h3,
301      html body h4,
302      html body h5 {
303        font-weight: 601;
304      }
305
306      html body h5 {
307        font-size: 0.9em;
308      }
309
310      html body h6 {
311        color: #5c5c5c;
312      }
313
314      html body strong {
315        color: #090909;
316      }
317
318      html body del {
319        color: #525252;
320      }
321
322      html body a:not([href]) {
323        color: inherit;
324        text-decoration: none;
325      }
326
327      html body a {
328        color: #0192da;
329        text-decoration: none;
330      }
331
332      html body a:hover {
333        color: #029dea;
334        text-decoration: none;
335      }
336
337      html body img {
338        max-width: 99%;
339      }
340
341      html body > p {
342        margin-top: 1px;
343        margin-bottom: 15px;
344        word-wrap: break-word;
345      }
346
347      html body > ul,
348      html body > ol {
349        margin-bottom: 15px;
350      }
351
352      html body ul,
353      html body ol {
354        padding-left: 1.9em;
355      }
356
357      html body ul.no-list,
358      html body ol.no-list {
359        padding: 0px;
360        list-style-type: none;
361      }
362
363      html body ul ul,
364      html body ul ol,
365      html body ol ol,
366      html body ol ul {
367        margin-top: 1px;
368        margin-bottom: 1px;
369      }
370
371      html body li {
372        margin-bottom: 1px;
373      }
374
375      html body li.task-list-item {
376        list-style: none;
377      }
378
379      html body li > p {
380        margin-top: 1px;
381        margin-bottom: 1px;
382      }
383
384      html body .task-list-item-checkbox {
385        margin: 0 0.3em 0.24em -1.7em;
386        vertical-align: middle;
387      }
388
389      html body .task-list-item-checkbox:hover {
390        cursor: pointer;
391      }
392
393      html body blockquote {
394        padding: 0.1px 15px 0 0.1px;
395        font-size: inherit;
396        color: #5c5c5c;
397        margin: 16px 0.1px 0 0.1px;
398        border-left: 3px solid #cbc9c9;
399        background-color: #e8e6e6;
400      }
401
402      html body blockquote > :first-child {
403        margin-top: 0.2px;
404      }
405
406      html body blockquote > :last-child {
407        margin-bottom: 0.1px;
408      }
409
410      html body hr {
411        height: 5px;
412        background-color: #cbcaca;
413        margin: 32px 0 0.1px 0;
414        border: 0 none;
415      }
416
417      html body table {
418        overflow: auto;
419        border-collapse: collapse;
420        margin: 15px 0.1px 20px 0.1px;
421        border-spacing: 0;
422      }
423
424      html body table th {
425        font-weight: bold;
426        color: #000000;
427      }
428
429      html body table td,
430      html body table th {
431        border: 1px solid #d6d6d6;
432        padding: 2px 14px;
433      }
434
435      html body dl {
436        padding: 0px;
437      }
438
439      html body dl dt {
440        padding: 0px;
441        margin-top: 15px;
442        font-size: 0.9em;
443        font-style: italic;
444        font-weight: bold;
445      }
446
447      html body dl dd {
448        padding: 0px 17px;
449        margin-bottom: 17px;
450      }
451
452      html body code {
453        font-family: Menlo, Monaco, Consolas, 'Courier New', monospace;
454        font-size: 0.86em !important;
455        color: #000000;
456        background-color: #f0f0f0;
457        border-radius: 4px;
458        padding: 0.3em 0px;
459      }
460
461      html body code::before,
462      html body code::after {
463        letter-spacing: -0.1em;
464        content: '\00a0';
465      }
466
467      html body pre > code {
468        padding: 1px;
469        margin: 0px;
470        font-size: 0.86em !important;
471        word-break: normal;
472        white-space: pre;
473        background: transparent;
474        border: 0px;
475      }
476
477      html body .highlight {
478        margin-bottom: 17px;
479      }
480
481      html body .highlight pre,
482      html body pre {
483        padding: 0.9em;
484        overflow: auto;
485        font-size: 0.86em !important;
486        line-height: 1.46;
487        border: #d6d6d6;
488        border-radius: 4px;
489      }
490
491      html body .highlight pre {
492        margin-bottom: 0px;
493        word-break: normal;
494      }
495
496      html body pre code,
497      html body pre tt {
498        display: inline;
499        max-width: initial;
500        padding: 1px;
501        margin: 1px;
502        overflow: initial;
503        line-height: inherit;
504        word-wrap: normal;
505        background-color: transparent;
506        border: 1px;
507      }
508
509      html body pre code:before,
510      html body pre tt:before,
511      html body pre code:after,
512      html body pre tt:after {
513        content: normal;
514      }
515
516      html body p,
517      html body blockquote,
518      html body ul,
519      html body ol,
520      html body dl,
521      html body pre {
522        margin-top: 1px;
523        margin-bottom: 17px;
524      }
525
526      html body kbd {
527        color: #000000;
528        border: 3px solid #d6d6d6;
529        border-bottom: 3px solid #c7c7c7;
530        padding: 3px 5px;
531        background-color: #f0f0f0;
532        border-radius: 2px;
533      }
534
535      @media print {
536        html body {
537          background-color: #ffffff;
538        }
539
540        html body h1,
541        html body h2,
542        html body h3,
543        html body h4,
544        html body h5,
545        html body h6 {
546          color: #000000;
547          page-break-after: avoid;
548        }
549
550        html body blockquote {
551          color: #5c5c53;
552        }
553
554        html body pre {
555          page-break-inside: avoid;
556        }
557
558        html body table {
559          display: table;
560        }
561
562        html body img {
563          display: block;
564          max-width: 99%;
565          max-height: 99%;
566        }
567
568        html body pre,
569        html body code {
570          word-wrap: break-word;
571          white-space: pre;
572        }
573      }
574
575      .smartperf-preview {
576        width: 99%;
577        height: 99%;
578        box-sizing: border-box;
579      }
580
581      .smartperf-preview .pagebreak,
582      .smartperf-preview .newpage {
583        page-break-before: always;
584      }
585
586      .smartperf-preview pre.line-numbers {
587        position: relative;
588        padding-left: 3.7em;
589        counter-reset: linenumber;
590      }
591
592      .smartperf-preview pre.line-numbers > code {
593        position: relative;
594      }
595
596      .smartperf-preview pre.line-numbers .line-numbers-rows {
597        position: absolute;
598        pointer-events: none;
599        top: 0.9em;
600        font-size: 99%;
601        left: 1px;
602        width: 3em;
603        letter-spacing: -1px;
604        border-right: 1px solid #999;
605        -webkit-user-select: none;
606        -moz-user-select: none;
607        -ms-user-select: none;
608        user-select: none;
609      }
610
611      .smartperf-preview pre.line-numbers .line-numbers-rows > span {
612        pointer-events: none;
613        display: block;
614        counter-increment: linenumber;
615      }
616
617      .smartperf-preview pre.line-numbers .line-numbers-rows > span:before {
618        content: counter(linenumber);
619        color: #999;
620        display: block;
621        padding-right: 0.79em;
622        text-align: right;
623      }
624
625      .smartperf-preview .mathjax-exps .MathJax_Display {
626        text-align: center !important;
627      }
628
629      .smartperf-preview:not([for='preview']) .code-chunk .btn-group {
630        display: none;
631      }
632
633      .smartperf-preview:not([for='preview']) .code-chunk .status {
634        display: none;
635      }
636
637      .smartperf-preview:not([for='preview']) .code-chunk .output-div {
638        margin-bottom: 16px;
639      }
640
641      .scrollbar-style::-webkit-scrollbar {
642        width: 8px;
643      }
644
645      .scrollbar-style::-webkit-scrollbar-track {
646        border-radius: 9px;
647        background-color: transparent;
648      }
649
650      .scrollbar-style::-webkit-scrollbar-thumb {
651        border-radius: 6px;
652        background-color: rgba(150, 150, 150, 1);
653        border: 4px solid rgba(150, 150, 150, 1);
654        background-clip: content-box;
655      }
656
657      html body[for='html-export']:not([dpm]) {
658        position: relative;
659        width: 99%;
660        height: 99%;
661        top: 1px;
662        left: 1px;
663        margin: 1px;
664        padding: 1px;
665        overflow: auto;
666      }
667
668      html body[for='html-export']:not([dpm]) .smartperf-preview {
669        position: relative;
670        top: 1px;
671      }
672
673      @media screen and (min-width: 914px) {
674        html body[for='html-export']:not([dpm]) .smartperf-preview {
675          padding: 2em calc(50% - 458px + 2em);
676        }
677      }
678
679      @media screen and (max-width: 914px) {
680        html body[for='html-export']:not([dpm]) .smartperf-preview {
681          padding: 1.9em;
682        }
683      }
684
685      @media screen and (max-width: 450px) {
686        html body[for='html-export']:not([dpm]) .smartperf-preview {
687          font-size: 15px !important;
688          padding: 1.1em;
689        }
690      }
691
692      @media print {
693        html body[for='html-export']:not([dpm]) #sidebar-toc-btn {
694          display: none;
695        }
696      }
697
698      html body[for='html-export']:not([dpm]) #sidebar-toc-btn {
699        position: fixed;
700        bottom: 9px;
701        left: 9px;
702        font-size: 28px;
703        cursor: pointer;
704        color: inherit;
705        z-index: 99;
706        width: 31px;
707        text-align: center;
708        opacity: 0.5;
709      }
710
711      html body[for='html-export']:not([dpm])[hsst] #sidebar-toc-btn {
712        opacity: 1;
713      }
714
715      html body[for='html-export']:not([dpm])[hsst] .md-sidebar-toc {
716        position: fixed;
717        top: 1px;
718        left: 1px;
719        width: 300px;
720        height: 99%;
721        padding: 32px 0 48px 0;
722        font-size: 14px;
723        box-shadow: 1px 1px 4px rgba(150, 150, 150, 0.33);
724        box-sizing: border-box;
725        overflow: auto;
726        background-color: inherit;
727      }
728
729      html body[for='html-export']:not([dpm])[hsst] .md-sidebar-toc::-webkit-scrollbar {
730        width: 9px;
731      }
732
733      html body[for='html-export']:not([dpm])[hsst] .md-sidebar-toc::-webkit-scrollbar-track {
734        border-radius: 11px;
735        background-color: transparent;
736      }
737
738      html body[for='html-export']:not([dpm])[hsst] .md-sidebar-toc::-webkit-scrollbar-thumb {
739        border-radius: 6px;
740        background-color: rgba(150, 150, 150, 0.66);
741        border: 3px solid rgba(150, 150, 150, 0.66);
742        background-clip: content-box;
743      }
744
745      html body[for='html-export']:not([dpm])[hsst] .md-sidebar-toc a {
746        text-decoration: none;
747      }
748
749      html body[for='html-export']:not([dpm])[hsst] .md-sidebar-toc ul {
750        padding: 1px 1.7em;
751        margin-top: 0.9em;
752      }
753
754      html body[for='html-export']:not([dpm])[hsst] .md-sidebar-toc li {
755        margin-bottom: 0.8em;
756      }
757
758      html body[for='html-export']:not([dpm])[hsst] .md-sidebar-toc ul {
759        list-style-type: none;
760      }
761
762      html body[for='html-export']:not([dpm])[hsst] .smartperf-preview {
763        left: 301px;
764        width: calc(100% - 300px);
765        padding: 2em calc(50% - 457px - 150px);
766        margin: 1px;
767        box-sizing: border-box;
768      }
769
770      @media screen and (max-width: 1274px) {
771        html body[for='html-export']:not([dpm])[hsst] .smartperf-preview {
772          padding: 1.9em;
773        }
774      }
775
776      @media screen and (max-width: 450px) {
777        html body[for='html-export']:not([dpm])[hsst] .smartperf-preview {
778          width: 99%;
779        }
780      }
781
782      html body[for='html-export']:not([dpm]):not([hsst]) .smartperf-preview {
783        left: 50%;
784        transform: translateX(-50%);
785      }
786
787      html body[for='html-export']:not([dpm]):not([hsst]) .md-sidebar-toc {
788        display: none;
789      }
790    </style>
791  </head>
792  <body for="html-export" id="body">
793    <div class="smartperf smartperf-preview">
794      <h1 class="mume-header fontColor">TraceStreamer数据表概述</h1>
795
796      <p class="fontColor">
797        TraceStreamer可以将trace数据源转化为易于理解和使用的数据库。用户可以通过SmartPerf界面直观的研究系统跟踪数据,也可在理解TraceStreamer生成的数据库的基础上,在TraceStreamer的交互模式或者Smartperf的数据库查询模式下,使用SQL查询语句自由组装查看用户关心的数据。下文将对TraceStreamer生成的数据库进行详细描述,给用户使用SQL查询系统跟踪数据提供帮助。
798      </p>
799      <h2 class="mume-header fontColor">TraceStreamer输出的数据表分类</h2>
800
801      <ul class="fontColor">
802        <li>
803          常规泳道图数据表<br />
804          <img src="../figures/traceStreamer/db_common.png" alt="GitHub Logo" />
805        </li>
806        <li>
807          native memory数据源相关表<br />
808          <img src="../figures/traceStreamer/db_native_memory.png" alt="GitHub Logo" />
809        </li>
810        <li>
811          perf相关数据表<br />
812          <img src="../figures/traceStreamer/db_hiperf.png" alt="GitHub Logo" />
813        </li>
814        <li>
815          hisysevent相关数据表<br />
816          <img src="../figures/traceStreamer/db_hisys_event.png" alt="GitHub Logo" />
817        </li>
818      </ul>
819      <h2 class="mume-header fontColor">TraceStreamer输出数据库包含以下表格</h2>
820
821      <table class="fontColor">
822        <thead>
823          <tr>
824            <th class="fontColor">表名称</th>
825            <th class="fontColor">作用</th>
826          </tr>
827        </thead>
828        <tbody>
829          <tr>
830            <td>animation</td>
831            <td>记录动效的响应时延和完成时延</td>
832          </tr>
833          <tr>
834            <td>app_name</td>
835            <td>记录HiSysEvent事件的事件名与IDE部分事件的字段名为APPNAME中存放的相关信息的映射关系</td>
836          </tr>
837          <tr>
838            <td>app_startup</td>
839            <td>记录了应用启动相关数据</td>
840          </tr>
841          <tr>
842            <td>args</td>
843            <td>记录方法参数集合</td>
844          </tr>
845          <tr>
846            <td>bio_latency_sample</td>
847            <td>记录IO操作相关方法调用,及调用栈数据</td>
848          </tr>
849          <tr>
850            <td>callstack</td>
851            <td>
852              记录调用堆栈和异步调用信息,其中depth,stack_id和parent_stack_id仅在非异步调用中有效。当cookid不为空时,为异步调用,此时callid为进程唯一号,否则为线程唯一号
853            </td>
854          </tr>
855          <tr>
856            <td>clk_event_filter</td>
857            <td>记录时钟相关的信息</td>
858          </tr>
859          <tr>
860            <td>clock_event_filter</td>
861            <td>此结构用来维护时钟事件,cpu与唯一的ID做关联</td>
862          </tr>
863          <tr>
864            <td>clock_snapshot</td>
865            <td>时钟号和时间,时钟名的映射表</td>
866          </tr>
867          <tr>
868            <td>cpu_measure_filter</td>
869            <td>cpu事件过滤器表</td>
870          </tr>
871          <tr>
872            <td>cpu_usage</td>
873            <td>记录CPU使用率事件</td>
874          </tr>
875          <tr>
876            <td>datasource_clockid</td>
877            <td>数据源和时钟号的映射表</td>
878          </tr>
879          <tr>
880            <td>data_dict</td>
881            <td>记录常用的字符串,将字符串和索引关联,降低程序运行的内存占用,用作辅助数据</td>
882          </tr>
883          <tr>
884            <td>data_type</td>
885            <td>记录数据类型和typeId的关联关系</td>
886          </tr>
887          <tr>
888            <td>device_info</td>
889            <td>记录设备分辨率和帧率</td>
890          </tr>
891          <tr>
892            <td>device_state</td>
893            <td>记录设备屏幕亮度,蓝牙,位置,wifi,音乐,媒体等信息</td>
894          </tr>
895          <tr>
896            <td>diskio</td>
897            <td>记录磁盘读写数据事件</td>
898          </tr>
899          <tr>
900            <td>dynamic_frame</td>
901            <td>记录动效帧的分辨率和结束时间等</td>
902          </tr>
903          <tr>
904            <td>ebpf_callstack</td>
905            <td>记录了采样相关信息</td>
906          </tr>
907          <tr>
908            <td>file_system_sample</td>
909            <td>记录了调用栈的相关信息</td>
910          </tr>
911          <tr>
912            <td>frame_maps</td>
913            <td>记录应用到RS的帧的映射关系</td>
914          </tr>
915          <tr>
916            <td>frame_slice</td>
917            <td>记录RS(RenderService)和应用的帧渲染</td>
918          </tr>
919          <tr>
920            <td>gpu_slice</td>
921            <td>记录RS的帧对应的gpu渲染时长</td>
922          </tr>
923          <tr>
924            <td>hidump</td>
925            <td>记录FPS(Frame Per Second)数据</td>
926          </tr>
927          <tr>
928            <td>hisys_event_measure</td>
929            <td>记录了HiSysEvent事件相关数据,目前HiSysEvent事件包括了异常事件,IDE事件,器件状态事件</td>
930          </tr>
931          <tr>
932            <td>instant</td>
933            <td>记录Sched_waking, sched_wakeup事件, 用作ThreadState表的上下文使用</td>
934          </tr>
935          <tr>
936            <td>irq</td>
937            <td>记录中断相关事件</td>
938          </tr>
939          <tr>
940            <td>js_config</td>
941            <td>记录了arkTs数据采集的相关配置</td>
942          </tr>
943          <tr>
944            <td>js_cpu_profiler_node</td>
945            <td>记录了cpu profiler中node节点的数据</td>
946          </tr>
947          <tr>
948            <td>js_cpu_profiler_sample</td>
949            <td>记录了cpu profiler中sample节点的数据</td>
950          </tr>
951          <tr>
952            <td>js_heap_edges</td>
953            <td>记录了js内存数据类对象对应的成员的信息</td>
954          </tr>
955          <tr>
956            <td>js_heap_files</td>
957            <td>记录了js内存数据的名称和时间</td>
958          </tr>
959          <tr>
960            <td>js_heap_info</td>
961            <td>记录了js内存数据类型,如nodes和edges的字段类型和数据总数</td>
962          </tr>
963          <tr>
964            <td>js_heap_location</td>
965            <td>记录了js内存location节点相关数据</td>
966          </tr>
967          <tr>
968            <td>js_heap_nodes</td>
969            <td>记录了js内存类对象和其成员的对应关系</td>
970          </tr>
971          <tr>
972            <td>js_heap_sample</td>
973            <td>记录了timeline模式下的时间轴信息</td>
974          </tr>
975          <tr>
976            <td>js_heap_string</td>
977            <td>记录了js内存数据中的字符串</td>
978          </tr>
979          <tr>
980            <td>js_heap_trace_function_info</td>
981            <td>记录了timeline模式下的调用栈的每个函数信息</td>
982          </tr>
983          <tr>
984            <td>js_heap_trace_node</td>
985            <td>记录了timeline模式下的调用栈信息</td>
986          </tr>
987          <tr>
988            <td>live_process</td>
989            <td>记录了一些实时的进程中执行的一些数据</td>
990          </tr>
991          <tr>
992            <td>log</td>
993            <td>记录hilog打印日志数据</td>
994          </tr>
995          <tr>
996            <td>measure</td>
997            <td>记录所有的计量值</td>
998          </tr>
999          <tr>
1000            <td>measure_filter</td>
1001            <td>
1002              记录一个递增的filterid队列,所有其他的filter类型在获取过程中,均从此数据列表中获取下一个可用的filter_id并做记录
1003            </td>
1004          </tr>
1005          <tr>
1006            <td>memory_ashmem</td>
1007            <td>记录了进程所占用的ashmem相关信息</td>
1008          </tr>
1009          <tr>
1010            <td>memory_dma</td>
1011            <td>记录了进程占用的DMA内存相关信息</td>
1012          </tr>
1013          <tr>
1014            <td>memory_process_gpu</td>
1015            <td>记录进程占用GPU内存相关信息</td>
1016          </tr>
1017          <tr>
1018            <td>memory_window_gpu</td>
1019            <td>记录窗口占用GPU内存相关信息</td>
1020          </tr>
1021          <tr>
1022            <td>meta</td>
1023            <td>记录执行解析操作相关的基本信息</td>
1024          </tr>
1025          <tr>
1026            <td>native_hook</td>
1027            <td>记录堆内存申请与释放相关的数据</td>
1028          </tr>
1029          <tr>
1030            <td>native_hook_frame</td>
1031            <td>记录堆内存申请与释放相关的调用栈</td>
1032          </tr>
1033          <tr>
1034            <td>native_hook_statistic</td>
1035            <td>记录堆内存申请与释放相关的统计信息</td>
1036          </tr>
1037          <tr>
1038            <td>network</td>
1039            <td>抓取网络信息传输时产生的一些相关信息</td>
1040          </tr>
1041          <tr>
1042            <td>paged_memory_sample</td>
1043            <td>记录内存操作相关方法调用,及调用栈数据</td>
1044          </tr>
1045          <tr>
1046            <td>perf_callchain</td>
1047            <td>记录Hiperf采样数据的调用栈信息</td>
1048          </tr>
1049          <tr>
1050            <td>perf_files</td>
1051            <td>记录Hiperf工具采集到的函数符号表和文件名</td>
1052          </tr>
1053          <tr>
1054            <td>perf_report</td>
1055            <td>记录Hiperf工具采集数据时的配置信息。包括</td>
1056          </tr>
1057          <tr>
1058            <td>perf_sample</td>
1059            <td>记录Hiperf工具的采样信息</td>
1060          </tr>
1061          <tr>
1062            <td>perf_thread</td>
1063            <td>记录Hiperf工具采集到的进程和线程数据</td>
1064          </tr>
1065          <tr>
1066            <td>process</td>
1067            <td>记录所有的进程信息</td>
1068          </tr>
1069          <tr>
1070            <td>process_filter</td>
1071            <td>过滤进程</td>
1072          </tr>
1073          <tr>
1074            <td>process_measure</td>
1075            <td>保存进程的所有计量值</td>
1076          </tr>
1077          <tr>
1078            <td>process_measure_filter</td>
1079            <td>将进程ID作为key1,进程的内存,界面刷新,屏幕亮度等信息作为key2,唯一确定一个filter_id</td>
1080          </tr>
1081          <tr>
1082            <td>raw</td>
1083            <td>此数据结构主要作为ThreadState的上下文使用,这张表是sched_waking,sched_wakup, cpu_idle事件的原始记录</td>
1084          </tr>
1085          <tr>
1086            <td>sched_slice</td>
1087            <td>此数据结构主要作为ThreadState的上下文使用,这张表是sched_switch事件的原始记录</td>
1088          </tr>
1089          <tr>
1090            <td>smaps</td>
1091            <td>记录进程的内存消耗的相关信息采样</td>
1092          </tr>
1093          <tr>
1094            <td>stat</td>
1095            <td>
1096              此结果用来统计数据解析中各类数据的数据条数,数据和合法性,数据的匹配程度(begin-end),数据的损失等,查看此结构对应的表,可对数据源有基本的了解
1097            </td>
1098          </tr>
1099          <tr>
1100            <td>static_initalize</td>
1101            <td>记录了so初始化相关数据</td>
1102          </tr>
1103          <tr>
1104            <td>symbols</td>
1105            <td>记录系统调用名称和其函数指针的对应关系,trace中用addr来映射function_name来节省存储空间</td>
1106          </tr>
1107          <tr>
1108            <td>syscall</td>
1109            <td>记录用户空间函数与内核空间函数相互调用记录</td>
1110          </tr>
1111          <tr>
1112            <td>sys_event_filter</td>
1113            <td>记录所有的filter</td>
1114          </tr>
1115          <tr>
1116            <td>sys_mem_measure</td>
1117            <td>记录了所有的系统内存相关的测量信息</td>
1118          </tr>
1119          <tr>
1120            <td>task_pool</td>
1121            <td>记录任务池相关数据,与callstack表相关联</td>
1122          </tr>
1123          <tr>
1124            <td>thread</td>
1125            <td>记录所有的线程信息</td>
1126          </tr>
1127          <tr>
1128            <td>thread_filter</td>
1129            <td>过滤线程</td>
1130          </tr>
1131          <tr>
1132            <td>thread_state</td>
1133            <td>记录线程状态信息</td>
1134          </tr>
1135          <tr>
1136            <td>trace_config</td>
1137            <td>记录trace数据源,proto的事件-plugin与其process_name</td>
1138          </tr>
1139          <tr>
1140            <td>trace_range</td>
1141            <td>记录ftrace数据与其他类型数据的时间交集,供前端展示数据时使用</td>
1142          </tr>
1143        </tbody>
1144      </table>
1145      <h2 class="mume-header fontColor">表与事件来源</h2>
1146
1147      <table class="fontColor">
1148        <thead>
1149          <tr>
1150            <th class="fontColor">表名称</th>
1151            <th class="fontColor">事件源</th>
1152            <th class="fontColor">插件名</th>
1153            <th class="fontColor">备注</th>
1154          </tr>
1155        </thead>
1156        <tbody>
1157          <tr>
1158            <td>animation</td>
1159            <td>-</td>
1160            <td>ftrace-plugin</td>
1161            <td>记录动效的响应时延和完成时延</td>
1162          </tr>
1163          <tr>
1164            <td>app_name</td>
1165            <td>-</td>
1166            <td>hisysevent-plugin</td>
1167            <td>JSON数据源</td>
1168          </tr>
1169          <tr>
1170            <td>args</td>
1171            <td>-</td>
1172            <td>ftrace-plugin</td>
1173            <td>配合callstack使用</td>
1174          </tr>
1175          <tr>
1176            <td>bio_latency_sample</td>
1177            <td>-</td>
1178            <td>-</td>
1179            <td>IO操作相关方法调用,及调用栈数据</td>
1180          </tr>
1181          <tr>
1182            <td>callstack</td>
1183            <td>-</td>
1184            <td>ftrace-plugin</td>
1185            <td>异步或非异步的调用</td>
1186          </tr>
1187          <tr>
1188            <td>cpu_measure_filter</td>
1189            <td>-</td>
1190            <td>ftrace-plugin</td>
1191            <td>cpu跟踪器,cpu频率等</td>
1192          </tr>
1193          <tr>
1194            <td>cpu_usage</td>
1195            <td>-</td>
1196            <td>cpu-plugin</td>
1197            <td>cpu使用率</td>
1198          </tr>
1199          <tr>
1200            <td>data_dict</td>
1201            <td>通用的</td>
1202            <td>-</td>
1203            <td>所有字符串的记录</td>
1204          </tr>
1205          <tr>
1206            <td>data_type</td>
1207            <td>通用的</td>
1208            <td>-</td>
1209            <td>辅助表</td>
1210          </tr>
1211          <tr>
1212            <td>device_info</td>
1213            <td>-</td>
1214            <td>ftrace-plugin</td>
1215            <td>记录设备分辨率和帧率</td>
1216          </tr>
1217          <tr>
1218            <td>device_state</td>
1219            <td>通用的</td>
1220            <td>hisysevent-plugin</td>
1221            <td>记录设备屏幕亮度,蓝牙,位置等信息</td>
1222          </tr>
1223          <tr>
1224            <td>dynamic_frame</td>
1225            <td>-</td>
1226            <td>ftrace-plugin</td>
1227            <td>动效帧的分辨率和结束时间等</td>
1228          </tr>
1229          <tr>
1230            <td>ebpf_callstack</td>
1231            <td>-</td>
1232            <td>-</td>
1233            <td>磁盘读写相关的数据</td>
1234          </tr>
1235          <tr>
1236            <td>file_system_callstack</td>
1237            <td>-</td>
1238            <td>-</td>
1239            <td>ebpf文件系统</td>
1240          </tr>
1241          <tr>
1242            <td>file_system_sample</td>
1243            <td>-</td>
1244            <td>-</td>
1245            <td>ebpf文件系统</td>
1246          </tr>
1247          <tr>
1248            <td>frame_maps</td>
1249            <td>-</td>
1250            <td>ftrace-plugin</td>
1251            <td>帧渲染数据,app到RS的映射</td>
1252          </tr>
1253          <tr>
1254            <td>frame_slice</td>
1255            <td>-</td>
1256            <td>ftrace-plugin</td>
1257            <td>帧渲染数据</td>
1258          </tr>
1259          <tr>
1260            <td>gpu_slice</td>
1261            <td>-</td>
1262            <td>ftrace-plugin</td>
1263            <td>gpu渲染时长</td>
1264          </tr>
1265          <tr>
1266            <td>hidump</td>
1267            <td>-</td>
1268            <td>hidump-plugin</td>
1269            <td>FPS数据</td>
1270          </tr>
1271          <tr>
1272            <td>hisys_event_measure</td>
1273            <td>-</td>
1274            <td>hisysevent-plugin</td>
1275            <td>JSON数据源</td>
1276          </tr>
1277          <tr>
1278            <td>instant</td>
1279            <td>-</td>
1280            <td>ftrace-plugin</td>
1281            <td>waking和wakeup事件</td>
1282          </tr>
1283          <tr>
1284            <td>irq</td>
1285            <td>-</td>
1286            <td>ftrace-plugin</td>
1287            <td>记录中断事件</td>
1288          </tr>
1289          <tr>
1290            <td>js_config</td>
1291            <td>-</td>
1292            <td>arkts-plugin</td>
1293            <td>arkTs数据采集的配置</td>
1294          </tr>
1295          <tr>
1296            <td>js_cpu_profiler_node</td>
1297            <td>-</td>
1298            <td>arkts-plugin</td>
1299            <td>记录了cpu profiler中node节点的数据</td>
1300          </tr>
1301          <tr>
1302            <td>js_cpu_profiler_sample</td>
1303            <td>-</td>
1304            <td>arkts-plugin</td>
1305            <td>记录了cpu profiler中sample节点的数据</td>
1306          </tr>
1307          <tr>
1308            <td>js_heap_edges</td>
1309            <td>-</td>
1310            <td>arkts-plugin</td>
1311            <td>js内存数据</td>
1312          </tr>
1313          <tr>
1314            <td>js_heap_files</td>
1315            <td>-</td>
1316            <td>arkts-plugin</td>
1317            <td>js内存数据</td>
1318          </tr>
1319          <tr>
1320            <td>js_heap_info</td>
1321            <td>-</td>
1322            <td>arkts-plugin</td>
1323            <td>js内存数据</td>
1324          </tr>
1325          <tr>
1326            <td>js_heap_location</td>
1327            <td>-</td>
1328            <td>arkts-plugin</td>
1329            <td>js内存数据</td>
1330          </tr>
1331          <tr>
1332            <td>js_heap_nodes</td>
1333            <td>-</td>
1334            <td>arkts-plugin</td>
1335            <td>js内存数据</td>
1336          </tr>
1337          <tr>
1338            <td>js_heap_sample</td>
1339            <td>-</td>
1340            <td>arkts-plugin</td>
1341            <td>js内存数据</td>
1342          </tr>
1343          <tr>
1344            <td>js_heap_string</td>
1345            <td>-</td>
1346            <td>arkts-plugin</td>
1347            <td>js内存数据</td>
1348          </tr>
1349          <tr>
1350            <td>js_heap_trace_function_info</td>
1351            <td>-</td>
1352            <td>arkts-plugin</td>
1353            <td>js内存数据</td>
1354          </tr>
1355          <tr>
1356            <td>js_heap_trace_node</td>
1357            <td>-</td>
1358            <td>arkts-plugin</td>
1359            <td>js内存数据</td>
1360          </tr>
1361          <tr>
1362            <td>app_startup</td>
1363            <td>-</td>
1364            <td>ftrace-plugin</td>
1365            <td>应用启动数据</td>
1366          </tr>
1367          <tr>
1368            <td>static_initalize</td>
1369            <td>-</td>
1370            <td>ftrace-plugin</td>
1371            <td>so初始化数据</td>
1372          </tr>
1373          <tr>
1374            <td>live_process</td>
1375            <td>-</td>
1376            <td>process-plugin</td>
1377            <td>Monitor数据</td>
1378          </tr>
1379          <tr>
1380            <td>network</td>
1381            <td>-</td>
1382            <td>network-plugin</td>
1383            <td>Monitor数据</td>
1384          </tr>
1385          <tr>
1386            <td>diskio</td>
1387            <td>-</td>
1388            <td>diskio-plugin</td>
1389            <td>Monitor数据</td>
1390          </tr>
1391          <tr>
1392            <td>log</td>
1393            <td>-</td>
1394            <td>hilog-plugin</td>
1395            <td>系统日志</td>
1396          </tr>
1397          <tr>
1398            <td>measure</td>
1399            <td>通用的</td>
1400            <td>-</td>
1401            <td>系统中的计量值(数值型)</td>
1402          </tr>
1403          <tr>
1404            <td>measure_filter</td>
1405            <td>通用的</td>
1406            <td>-</td>
1407            <td>计量值的查询辅助表</td>
1408          </tr>
1409          <tr>
1410            <td>memory_ashmem</td>
1411            <td>-</td>
1412            <td>memory-plugin</td>
1413            <td>进程所占用ashmem相关信息</td>
1414          </tr>
1415          <tr>
1416            <td>memory_dma</td>
1417            <td>-</td>
1418            <td>memory-plugin</td>
1419            <td>进程占用的DMA内存相关信息</td>
1420          </tr>
1421          <tr>
1422            <td>memory_process_gpu</td>
1423            <td>-</td>
1424            <td>memory-plugin</td>
1425            <td>进程占用GPU内存相关信息</td>
1426          </tr>
1427          <tr>
1428            <td>memory_window_gpu</td>
1429            <td>-</td>
1430            <td>memory-plugin</td>
1431            <td>窗口占用GPU内存相关信息</td>
1432          </tr>
1433          <tr>
1434            <td>meta</td>
1435            <td>通用的</td>
1436            <td>-</td>
1437            <td>记录解析现场数据(解析时间,数据类型,解析工具等)</td>
1438          </tr>
1439          <tr>
1440            <td>native_hook</td>
1441            <td>-</td>
1442            <td>nativehook/hookdaemon</td>
1443            <td>malloc &amp;&amp; mmap内存数据</td>
1444          </tr>
1445          <tr>
1446            <td>native_hook_frame</td>
1447            <td>-</td>
1448            <td>nativehook/hookdaemon</td>
1449            <td>native_hook调用栈数据</td>
1450          </tr>
1451          <tr>
1452            <td>native_hook_statistic</td>
1453            <td>-</td>
1454            <td>nativehook/hookdaemon</td>
1455            <td>malloc &amp;&amp; mmap统计数据</td>
1456          </tr>
1457          <tr>
1458            <td>paged_memory_sample</td>
1459            <td>-</td>
1460            <td>-</td>
1461            <td>网络数据传输相关的信息</td>
1462          </tr>
1463          <tr>
1464            <td>perf_callchain</td>
1465            <td>-</td>
1466            <td>perf-plugin</td>
1467            <td>perf数据(非插件模式)</td>
1468          </tr>
1469          <tr>
1470            <td>perf_files</td>
1471            <td>-</td>
1472            <td>-</td>
1473            <td>perf数据(非插件模式)</td>
1474          </tr>
1475          <tr>
1476            <td>perf_report</td>
1477            <td>-</td>
1478            <td>-</td>
1479            <td>perf数据(非插件模式)</td>
1480          </tr>
1481          <tr>
1482            <td>perf_sample</td>
1483            <td>-</td>
1484            <td>-</td>
1485            <td>perf数据(非插件模式)</td>
1486          </tr>
1487          <tr>
1488            <td>perf_thread</td>
1489            <td>-</td>
1490            <td>-</td>
1491            <td>perf数据(非插件模式)</td>
1492          </tr>
1493          <tr>
1494            <td>process</td>
1495            <td>-</td>
1496            <td>ftrace-plugin</td>
1497            <td>进程信息</td>
1498          </tr>
1499          <tr>
1500            <td>process_filter</td>
1501            <td>-</td>
1502            <td>ftrace-plugin</td>
1503            <td>进程计量表的辅助表</td>
1504          </tr>
1505          <tr>
1506            <td>process_measure</td>
1507            <td>-</td>
1508            <td>ftrace-plugin</td>
1509            <td>进程内存</td>
1510          </tr>
1511          <tr>
1512            <td>process_measure_filter</td>
1513            <td>-</td>
1514            <td>ftrace-plugin</td>
1515            <td>process_measure的辅助表</td>
1516          </tr>
1517          <tr>
1518            <td>raw</td>
1519            <td>-</td>
1520            <td>ftrace-plugin</td>
1521            <td>线程唤醒信息</td>
1522          </tr>
1523          <tr>
1524            <td>sched_slice</td>
1525            <td>-</td>
1526            <td>ftrace-plugin</td>
1527            <td>配合现场状态表使用,dsched_switch的原始数据</td>
1528          </tr>
1529          <tr>
1530            <td>smaps</td>
1531            <td>-</td>
1532            <td>memory-plugin</td>
1533            <td>进程的内存消耗</td>
1534          </tr>
1535          <tr>
1536            <td>stat</td>
1537            <td>通用的</td>
1538            <td>-</td>
1539            <td>记录不同种类数据的数据量</td>
1540          </tr>
1541          <tr>
1542            <td>symbols</td>
1543            <td>-</td>
1544            <td>ftrace-plugin</td>
1545            <td>符号表(地址到字符串的映射)</td>
1546          </tr>
1547          <tr>
1548            <td>syscall</td>
1549            <td>-</td>
1550            <td>ftrace-plugin</td>
1551            <td>系统调用 sys_enter/exit</td>
1552          </tr>
1553          <tr>
1554            <td>sys_event_filter</td>
1555            <td>-</td>
1556            <td>ftrace-plugin</td>
1557            <td></td>
1558          </tr>
1559          <tr>
1560            <td>sys_mem_measure</td>
1561            <td>-</td>
1562            <td>memory-plugin</td>
1563            <td>系统内存</td>
1564          </tr>
1565          <tr>
1566            <td>thread</td>
1567            <td>通用的</td>
1568            <td>-</td>
1569            <td>线程信息(常用)</td>
1570          </tr>
1571          <tr>
1572            <td>thread_state</td>
1573            <td>通用的</td>
1574            <td>ftrace-plugin</td>
1575            <td>线程调度图(常用)</td>
1576          </tr>
1577          <tr>
1578            <td>trace_config</td>
1579            <td>通用的</td>
1580            <td>hisysevent-plugin</td>
1581            <td>记录trace数据源</td>
1582          </tr>
1583          <tr>
1584            <td>trace_range</td>
1585            <td>通用的</td>
1586            <td>-</td>
1587            <td>trace数据的时长</td>
1588          </tr>
1589          <tr>
1590            <td>thread_filter</td>
1591            <td>通用的</td>
1592            <td>ftrace-plugin</td>
1593            <td>线程计量跟踪表(比较少用)</td>
1594          </tr>
1595          <tr>
1596            <td>clock_snapshot</td>
1597            <td>通用的</td>
1598            <td>通用的</td>
1599            <td>时钟号和时间,时钟名的映射表</td>
1600          </tr>
1601          <tr>
1602            <td>datasource_clockid</td>
1603            <td>通用的</td>
1604            <td>通用的</td>
1605            <td>数据源和时钟号的映射表</td>
1606          </tr>
1607          <tr>
1608            <td>task_pool</td>
1609            <td>-</td>
1610            <td>-</td>
1611            <td>任务池数据</td>
1612          </tr>
1613        </tbody>
1614      </table>
1615      <h2 class="mume-header fontColor">
1616        <em><strong>表格关系图</strong></em>
1617      </h2>
1618
1619      <hr />
1620      <h3 class="mume-header fontColor">进程表与线程表关系</h3>
1621
1622      <p class="fontColor">
1623        当一个进程或者线程结束后,系统可能再次将该进程号或者线程号分配给其他进程或者线程,造成一个进程号或线程号代表多个进程或线程的情况。<br />
1624        Process和Thread表中的id字段可以唯一标识进程和线程。process表中的id在其他表中用作ipid字段。thread表中的id在其他表中用作itid字段。<br />
1625        thread表通过ipid字段关联process表的id字段,可以查询线程归属进程。<br />
1626        <img src="../figures/traceStreamer/process_thread.png" alt="GitHub Logo" />
1627      </p>
1628      <h3 class="mume-header fontColor">查询举例</h3>
1629
1630      <ul class="fontColor">
1631        <li>
1632          已知pid = 123,查看当前进程下的所有线程信息,可以使用如下SQL语句:<br />
1633          <code class="fontColor"
1634            >select thread.* from thread, process where process.pid = 123 and thread.ipid = process.id</code
1635          >
1636        </li>
1637      </ul>
1638      <h3>线程表与线程运行状态表关系图</h3>
1639      <p class="fontColor">
1640        thread_state表记录所有线程的运行状态信息,包含ts(状态起始时间),dur(状态持续时间),cpu, itid,
1641        state(线程状态)。 thread表的id字段与thread_state表的itid字段相关联。<br />
1642        <img src="../figures/traceStreamer/thread_state.png" alt="GitHub Logo" />
1643      </p>
1644      <h3>查询举例</h3>
1645      <ul class="fontColor">
1646        <li>
1647          已知tid = 123, 查看当前线程的所有运行状态信息,可以使用如下SQL语句:<br />
1648          <code class="fontColor"
1649            >select thread_state.* from thread, thread_state where thread.tid = 123 and thread.id =
1650            thread_state.itid</code
1651          >
1652        </li>
1653      </ul>
1654      <h3 class="mume-header fontColor">堆内存数据变化表关系图</h3>
1655
1656      <p class="fontColor">
1657        native_hook表记录堆内存申请(AllocEvent)和释放(FreeEvent)数据。native_hook表通过ipid和itid字段分别与process和thread表的id字段关联,通过callChainId与native_hook_frame表的callChainId字段相关联。<br />
1658        native_hook表字段解释如下:
1659      </p>
1660      <ul class="fontColor">
1661        <li>
1662          callChainId:唯一标识一次堆内存申请或释放,
1663          通过与native_hook_frame表关联可以拿到当前申请或释放的函数调用堆栈。
1664        </li>
1665        <li>addr:堆内存申请/释放的地址。</li>
1666        <li>native_hook_size:堆内存申请/释放的大小。</li>
1667      </ul>
1668      <p class="fontColor">
1669        native_hook_frame表记录内存申请/释放的调用堆栈。通过callChainId区分一组调用堆栈,depth为堆栈深度,depth为0时,表示当前行为栈顶数据。<br />
1670        <img src="../figures/traceStreamer/dump_and_mem.png" alt="GitHub Logo" />
1671      </p>
1672      <p class="fontColor">
1673        native_hook_statistic表记录内存申请/释放的统计信息。通过callChainId区分一组调用堆栈。每个统计事件将记录当前事件的callChainId,并统计当前调用栈内存分配/释放的总次数和总大小。<br />
1674        <img src="../figures/traceStreamer/db_native_hook_statistic.png" alt="GitHub Logo" />
1675      </p>
1676      <h3 class="mume-header fontColor">查询举例</h3>
1677
1678      <ul class="fontColor">
1679        <li>
1680          已知tid = 123,查看当前线程的所有堆内存变化信息,可以使用如下SQL语句:<br />
1681          <code class="fontColor"
1682            >select native_hook.* from thread, native_hook where thread.tid = 123 and thread.id = native_hook.itid</code
1683          >
1684        </li>
1685        <li>
1686          已知callchainid = 1, 查看当前内存变化调用堆栈<br />
1687          <code class="fontColor">select * from native_hook_frame where callchain_id = 1</code>
1688        </li>
1689        <li>
1690          已知callchainid = 1, 查看当前内存变化调用堆栈对应的统计信息<br />
1691          <code class="fontColor">select * from native_hook_statistic where callchain_id = 1</code>
1692        </li>
1693      </ul>
1694      <h3>日志表与进程线程表关系图</h3>
1695      <p class="fontColor">
1696        log表记录日志信息。可以根据seq字段的连续性,来判断是否存在日志丢失的情况。<br />
1697        <img src="../figures/traceStreamer/log.png" alt="GitHub Logo" />
1698      </p>
1699      <h3>查询举例</h3>
1700      <ul class="fontColor">
1701        <li>
1702          已知tid = 123,查看当前线程的所有error级别的日志,可以使用如下SQL语句:<br />
1703          <code class="fontColor">select * from log where tid = 123 and level = "error"</code>
1704        </li>
1705      </ul>
1706      <h3 class="mume-header fontColor">perf表之间关系图</h3>
1707
1708      <ul class="fontColor">
1709        <li>perf_report:此表记录Hiperf工具采集数据时的配置信息。</li>
1710        <li>perf_thread:此表记录hiperf采集到的进程和线程数据。</li>
1711        <li>
1712          perf_sample:此表中记录Hiperf工具的采样信息。sample_id唯一表识一次采样记录,与perf_callchain表中的sample_id字段相关联。thread_id为线程号。与perf_thread表中的thread_id字段相关联。event_type_id为当前采样的事件类型id,与perf_report表中的id字段相关联。
1713        </li>
1714        <li>perf_callchain:此表格记录的是调用栈信息。</li>
1715        <li>
1716          Perf_files:此表格主要存放着获取到的函数符号表和文件信息。file_id唯一表识一个文件,与perf_callchain表中的file_id字段相关联。
1717        </li>
1718      </ul>
1719      <p class="fontColor"><img src="../figures/traceStreamer/perf.png" alt="GitHub Logo" /></p>
1720      <h3 class="mume-header fontColor">查询举例</h3>
1721
1722      <ul class="fontColor">
1723        <li>
1724          <p class="fontColor">
1725            已知同步后的时间戳为28463134340470,查询采样数据<br />
1726            <code class="fontColor">select * from perf_sample where timestamp_trace = 28463134340470</code>
1727          </p>
1728        </li>
1729        <li>
1730          <p class="fontColor">
1731            已知同步后的时间戳为28463134340470,查询采样数据对应的的调用栈信息<br />
1732            <code class="fontColor"
1733              >select A.* from perf_callchain as A, perf_sample as B where B.timestamp_trace = 28463134340470 and
1734              A.sample_id = B.sample_id</code
1735            >
1736          </p>
1737        </li>
1738        <li>
1739          <p class="fontColor">
1740            已知同步后的时间戳为28463134277762,查询采样数据的函数名及文件路径<br />
1741            <code class="fontColor"
1742              >select A.*, B.name, C.path from perf_sample as A, perf_callchain as B, perf_files as C where
1743              A.timestamp_trace = 28463134277762 and B.sample_id = A.sample_id and B.callchain_id = 0 and B.file_id =
1744              C.file_id and C.serial_id = 0</code
1745            >
1746          </p>
1747        </li>
1748        <li>
1749          <p class="fontColor">
1750            已知线程号为6700,查询所有的采样记录<br />
1751            <code class="fontColor">select * from perf_sample where thread_id = 6700</code>
1752          </p>
1753        </li>
1754        <li>
1755          <p class="fontColor">
1756            已知进程号为7863,查询所有的采样记录<br />
1757            <code class="fontColor"
1758              >select A.* from perf_sample as A, perf_thread as B where B.process_id = 7863 and A.thread_id =
1759              B.thread_id</code
1760            >
1761          </p>
1762        </li>
1763        <li>
1764          <p class="fontColor">
1765            查询所有采样对应的事件类型<br />
1766            <code class="fontColor"
1767              >select A.*, B.report_value from perf_sample as A, perf_report as B where A.event_type_id = B.id</code
1768            >
1769          </p>
1770        </li>
1771      </ul>
1772      <h3 class="mume-header fontColor">帧渲染表之间的关系图</h3>
1773
1774      <p class="fontColor">
1775        frame_slice: 记录RS(RenderService)和应用的帧渲染。<br />
1776        gpu_slice: 记录RS的帧对应的gpu渲染时长。<br />
1777        frame_maps:记录应用到RS的帧的映射关系。<br />
1778        <img src="../figures/traceStreamer/frames.jpg" alt="GitHub Logo" />
1779      </p>
1780      <h3 class="mume-header fontColor">查询示例</h3>
1781
1782      <ul class="fontColor">
1783        <li>
1784          <p class="fontColor">
1785            已知进程,查询进程对应的实际渲染帧<br />
1786            <code class="fontColor">select * from frame_slice where ipid = 1</code>
1787          </p>
1788        </li>
1789        <li>
1790          <p class="fontColor">
1791            已知进程的实际渲染帧的dst为12,求其对应的RS进程的渲染帧<br />
1792            <code class="fontColor">select * from frame_slice where id = 12</code>
1793          </p>
1794        </li>
1795        <li>
1796          <p class="fontColor">
1797            已知RS的渲染帧在frame_slice中所在行是14,求其对应的GPU渲染时长<br />
1798            <code class="fontColor">select * from gpu_slice where frame_row = 14</code>
1799          </p>
1800        </li>
1801      </ul>
1802      <h3>JS内存数据表关系图</h3>
1803      <p class="fontColor">js_heap_files:记录js内存数据的文件名和文件索引</p>
1804      <p class="fontColor"><img src="../figures/traceStreamer/js_heap_files.png" /></p>
1805      <p class="fontColor">
1806        js_heap_nodes:记录js内存类对象数据<br />
1807        js_heap_edges:记录js内存类对象的成员数据<br />
1808        js_heap_trace_node:记录timeline的调用栈信息<br />
1809        js_heap_sample:记录timeline的时间轴信息<br />
1810        <img src="../figures/traceStreamer/js_heap_nodes.png" />
1811      </p>
1812      <h2>TraceStreamer输出数据库表格详细介绍</h2>
1813      <h3>app_name表</h3>
1814      <h4>表结构</h4>
1815      <table class="fontColor">
1816        <thead>
1817          <tr>
1818            <th class="fontColor">Columns Name</th>
1819            <th class="fontColor">SQL TYPE</th>
1820          </tr>
1821        </thead>
1822        <tbody>
1823          <tr>
1824            <td>id</td>
1825            <td>INT</td>
1826          </tr>
1827          <tr>
1828            <td>flag</td>
1829            <td>INT</td>
1830          </tr>
1831          <tr>
1832            <td>app_name</td>
1833            <td>INT</td>
1834          </tr>
1835          <tr>
1836            <td>app_key</td>
1837            <td>INT</td>
1838          </tr>
1839        </tbody>
1840      </table>
1841      <h4>表描述</h4>
1842      <p class="fontColor">记录HiSysevent上报事件中的IDE相关事件中APPNAME的表关联信息。</p>
1843      <h4>字段详细描述</h4>
1844      <ul class="fontColor">
1845        <li>id:用于与表hisys_event_measure表中的key_id字段做对应</li>
1846        <li>app_name:对应的事件的信息ID</li>
1847        <li>app_key:对应的事件的APPNAME字段的信息ID</li>
1848      </ul>
1849      <h3>args表</h3>
1850      <h4>表结构</h4>
1851      <table class="fontColor">
1852        <thead>
1853          <tr>
1854            <th class="fontColor">Columns Name</th>
1855            <th class="fontColor">SQL TYPE</th>
1856          </tr>
1857        </thead>
1858        <tbody>
1859          <tr>
1860            <td>id</td>
1861            <td>INT</td>
1862          </tr>
1863          <tr>
1864            <td>key</td>
1865            <td>INT</td>
1866          </tr>
1867          <tr>
1868            <td>datatype</td>
1869            <td>INT</td>
1870          </tr>
1871          <tr>
1872            <td>value</td>
1873            <td>INT</td>
1874          </tr>
1875          <tr>
1876            <td>argset</td>
1877            <td>INT</td>
1878          </tr>
1879        </tbody>
1880      </table>
1881      <h4>表描述</h4>
1882      <p class="fontColor">记录方法的参数集合。</p>
1883      <h4>字段详细描述</h4>
1884      <ul class="fontColor">
1885        <li>key:键</li>
1886        <li>datatype:数据类型</li>
1887        <li>value:取值</li>
1888        <li>argset:参数集合</li>
1889      </ul>
1890      <h3>bio_latency_sample表</h3>
1891      <h4>表结构</h4>
1892      <table class="fontColor">
1893        <thead>
1894          <tr>
1895            <th class="fontColor">Columns Name</th>
1896            <th class="fontColor">SQL TYPE</th>
1897          </tr>
1898        </thead>
1899        <tbody>
1900          <tr>
1901            <td>id</td>
1902            <td>INT</td>
1903          </tr>
1904          <tr>
1905            <td>callchain_id</td>
1906            <td>INT</td>
1907          </tr>
1908          <tr>
1909            <td>datatype</td>
1910            <td>INT</td>
1911          </tr>
1912          <tr>
1913            <td>type</td>
1914            <td>INT</td>
1915          </tr>
1916          <tr>
1917            <td>ipid</td>
1918            <td>INT</td>
1919          </tr>
1920          <tr>
1921            <td>itid</td>
1922            <td>INT</td>
1923          </tr>
1924          <tr>
1925            <td>start_ts</td>
1926            <td>INT</td>
1927          </tr>
1928          <tr>
1929            <td>end_ts</td>
1930            <td>INT</td>
1931          </tr>
1932          <tr>
1933            <td>latency_dur</td>
1934            <td>INT</td>
1935          </tr>
1936          <tr>
1937            <td>tier</td>
1938            <td>INT</td>
1939          </tr>
1940          <tr>
1941            <td>size</td>
1942            <td>INT</td>
1943          </tr>
1944          <tr>
1945            <td>block_number</td>
1946            <td>TEXT</td>
1947          </tr>
1948          <tr>
1949            <td>path</td>
1950            <td>TEXT</td>
1951          </tr>
1952          <tr>
1953            <td>dur_per_4k</td>
1954            <td>INT</td>
1955          </tr>
1956        </tbody>
1957      </table>
1958      <h4>表描述</h4>
1959      <p class="fontColor">记录IO操作相关方法调用,及调用栈数据。</p>
1960      <h4>字段详细描述</h4>
1961      <ul class="fontColor">
1962        <li>callchain_id:调用栈的唯一标识。与ebpf_callstack表中Callchain_id字段关联</li>
1963        <li>
1964          type:事件类型其取值为枚举类型(DATA_READ,DATA_WRITE,METADATA_READ,- METADATA_WRITE,PAGE_IN,PAGE_OUT)
1965        </li>
1966        <li>ipid:TS内部进程号</li>
1967        <li>itid:TS内部线程号</li>
1968        <li>start_ts:开始时间</li>
1969        <li>end_ts:结束时间</li>
1970        <li>latency_dur:总延迟</li>
1971        <li>tier:优先级</li>
1972        <li>size:文件大小</li>
1973        <li>block_number:数据量大小(一般为4K)</li>
1974        <li>path:路径id</li>
1975        <li>dur_per_4k:每4k数据的平均延迟</li>
1976      </ul>
1977      <h3>callstack表</h3>
1978      <h4>表结构</h4>
1979      <table class="fontColor">
1980        <thead>
1981          <tr>
1982            <th class="fontColor">Columns Name</th>
1983            <th class="fontColor">SQL TYPE</th>
1984          </tr>
1985        </thead>
1986        <tbody>
1987          <tr>
1988            <td>id</td>
1989            <td>INT</td>
1990          </tr>
1991          <tr>
1992            <td>ts</td>
1993            <td>INT</td>
1994          </tr>
1995          <tr>
1996            <td>dur</td>
1997            <td>INT</td>
1998          </tr>
1999          <tr>
2000            <td>callid</td>
2001            <td>INT</td>
2002          </tr>
2003          <tr>
2004            <td>cat</td>
2005            <td>TEXT</td>
2006          </tr>
2007          <tr>
2008            <td>identify</td>
2009            <td>INT</td>
2010          </tr>
2011          <tr>
2012            <td>name</td>
2013            <td>TEXT</td>
2014          </tr>
2015          <tr>
2016            <td>depth</td>
2017            <td>INT</td>
2018          </tr>
2019          <tr>
2020            <td>cookie</td>
2021            <td>INT</td>
2022          </tr>
2023          <tr>
2024            <td>parent_id</td>
2025            <td>INT</td>
2026          </tr>
2027          <tr>
2028            <td>argsetid</td>
2029            <td>INT</td>
2030          </tr>
2031          <tr>
2032            <td>chainId</td>
2033            <td>TEXT</td>
2034          </tr>
2035          <tr>
2036            <td>spanId</td>
2037            <td>TEXT</td>
2038          </tr>
2039          <tr>
2040            <td>parentSpanId</td>
2041            <td>TEXT</td>
2042          </tr>
2043          <tr>
2044            <td>flag</td>
2045            <td>TEXT</td>
2046          </tr>
2047          <tr>
2048            <td>args</td>
2049            <td>TEXT</td>
2050          </tr>
2051        </tbody>
2052      </table>
2053      <h4>表描述</h4>
2054      <p class="fontColor">
2055        记录调用堆栈和异步调用信息,其中depth,stack_id和parent_stack_id仅在非异步的调用中有效。当cookid不为空时,为异步调用,此时callid为进程唯一号,否则为线程唯一号。
2056      </p>
2057      <h4>字段详细描述</h4>
2058      <ul class="fontColor">
2059        <li>dur:调用时长</li>
2060        <li>callid:调用者的ID,比如针对线程表里面的id</li>
2061        <li>identify:调用栈的名字,与表dataDict相关联能够取出其string值</li>
2062        <li>name:调用名称</li>
2063        <li>depth:调用深度</li>
2064        <li>parent_id:父调用的id</li>
2065        <li>spanId:分布式调用关联关系</li>
2066        <li>flag:C表示分布式调用发送方,S表示接受方</li>
2067        <li>args:分布式调用函数参数</li>
2068      </ul>
2069      <h3>clk_event_filter表</h3>
2070      <h4>表结构</h4>
2071      <table class="fontColor">
2072        <thead>
2073          <tr>
2074            <th class="fontColor">Columns Name</th>
2075            <th class="fontColor">SQL TYPE</th>
2076          </tr>
2077        </thead>
2078        <tbody>
2079          <tr>
2080            <td>id</td>
2081            <td>INT</td>
2082          </tr>
2083          <tr>
2084            <td>type</td>
2085            <td>TEXT</td>
2086          </tr>
2087          <tr>
2088            <td>name</td>
2089            <td>TEXT</td>
2090          </tr>
2091          <tr>
2092            <td>cpu</td>
2093            <td>INT</td>
2094          </tr>
2095        </tbody>
2096      </table>
2097      <h4>表描述</h4>
2098      <p class="fontColor">记录时钟信息。</p>
2099      <h4>字段详细描述</h4>
2100      <ul class="fontColor">
2101        <li>Type:时钟事件类型</li>
2102        <li>Name:时钟事件名称</li>
2103      </ul>
2104      <h3>clock_event_filter表</h3>
2105      <h4>表结构</h4>
2106      <table class="fontColor">
2107        <thead>
2108          <tr>
2109            <th class="fontColor">Columns Name</th>
2110            <th class="fontColor">SQL TYPE</th>
2111          </tr>
2112        </thead>
2113        <tbody>
2114          <tr>
2115            <td>id</td>
2116            <td>INT</td>
2117          </tr>
2118          <tr>
2119            <td>type</td>
2120            <td>TEXT</td>
2121          </tr>
2122          <tr>
2123            <td>name</td>
2124            <td>TEXT</td>
2125          </tr>
2126          <tr>
2127            <td>cpu</td>
2128            <td>INT</td>
2129          </tr>
2130        </tbody>
2131      </table>
2132      <h4>表描述</h4>
2133      <p class="fontColor">此结构用来维护时钟事件,cpu与唯一的ID做关联。</p>
2134      <h4>主要字段描述</h4>
2135      <ul class="fontColor">
2136        <li>Type:时钟事件类型</li>
2137        <li>Name:时钟事件名称</li>
2138      </ul>
2139      <h3>cpu_measure_filter表</h3>
2140      <h4>表结构</h4>
2141      <table class="fontColor">
2142        <thead>
2143          <tr>
2144            <th class="fontColor">Columns Name</th>
2145            <th class="fontColor">SQL TYPE</th>
2146          </tr>
2147        </thead>
2148        <tbody>
2149          <tr>
2150            <td>id</td>
2151            <td>INT</td>
2152          </tr>
2153          <tr>
2154            <td>type</td>
2155            <td>TEXT</td>
2156          </tr>
2157          <tr>
2158            <td>name</td>
2159            <td>TEXT</td>
2160          </tr>
2161          <tr>
2162            <td>cpu</td>
2163            <td>INT</td>
2164          </tr>
2165        </tbody>
2166      </table>
2167      <h4>表描述</h4>
2168      <p class="fontColor">将cpu号作为key1,cpu的频率,空闲等状态作为key2,唯一确定一个filter_id。</p>
2169      <h4>主要字段描述</h4>
2170      <ul class="fontColor">
2171        <li>Id(filterid), cpu:事件名称,cpu号</li>
2172      </ul>
2173      <h3>cpu_usage表</h3>
2174      <h4>表结构</h4>
2175      <table class="fontColor">
2176        <thead>
2177          <tr>
2178            <th class="fontColor">Columns Name</th>
2179            <th class="fontColor">SQL TYPE</th>
2180          </tr>
2181        </thead>
2182        <tbody>
2183          <tr>
2184            <td>ts</td>
2185            <td>INT</td>
2186          </tr>
2187          <tr>
2188            <td>dur</td>
2189            <td>INT</td>
2190          </tr>
2191          <tr>
2192            <td>total_load</td>
2193            <td>REAL</td>
2194          </tr>
2195          <tr>
2196            <td>user_load</td>
2197            <td>REAL</td>
2198          </tr>
2199          <tr>
2200            <td>system_load</td>
2201            <td>REAL</td>
2202          </tr>
2203          <tr>
2204            <td>process_num</td>
2205            <td>INT</td>
2206          </tr>
2207        </tbody>
2208      </table>
2209      <h4>表描述</h4>
2210      <p class="fontColor">记录了与CPU使用率相关的数据。</p>
2211      <h4>主要字段描述</h4>
2212      <ul class="fontColor">
2213        <li>total_load:总负荷</li>
2214        <li>user_load:用户负载</li>
2215        <li>system_load:系统负载</li>
2216        <li>process_num:线程数</li>
2217      </ul>
2218      <h3>data_dict表</h3>
2219      <h4>表结构</h4>
2220      <table class="fontColor">
2221        <thead>
2222          <tr>
2223            <th class="fontColor">Columns Name</th>
2224            <th class="fontColor">SQL TYPE</th>
2225          </tr>
2226        </thead>
2227        <tbody>
2228          <tr>
2229            <td>id</td>
2230            <td>INT</td>
2231          </tr>
2232          <tr>
2233            <td>data</td>
2234            <td>TEXT</td>
2235          </tr>
2236        </tbody>
2237      </table>
2238      <h4>表描述</h4>
2239      <p class="fontColor">此表记录了一个数据类型ID和字符串的映射。</p>
2240      <h4>主要字段描述</h4>
2241      <ul class="fontColor">
2242        <li>id:索引值</li>
2243        <li>data:字符串</li>
2244      </ul>
2245      <h3>data_type表</h3>
2246      <h4>表结构</h4>
2247      <table class="fontColor">
2248        <thead>
2249          <tr>
2250            <th class="fontColor">Columns Name</th>
2251            <th class="fontColor">SQL TYPE</th>
2252          </tr>
2253        </thead>
2254        <tbody>
2255          <tr>
2256            <td>id</td>
2257            <td>INT</td>
2258          </tr>
2259          <tr>
2260            <td>typeId</td>
2261            <td>INT</td>
2262          </tr>
2263          <tr>
2264            <td>desc</td>
2265            <td>TEXT</td>
2266          </tr>
2267        </tbody>
2268      </table>
2269      <h4>表描述</h4>
2270      <p class="fontColor">此表记录了一个数据类型ID和数据描述的映射。</p>
2271      <h4>主要字段描述</h4>
2272      <ul class="fontColor">
2273        <li>typeId::数据类型id</li>
2274        <li>Desc:数据类型描述</li>
2275      </ul>
2276      <h3>diskio表</h3>
2277      <h4>表结构</h4>
2278      <table class="fontColor">
2279        <thead>
2280          <tr>
2281            <th class="fontColor">Columns Name</th>
2282            <th class="fontColor">SQL TYPE</th>
2283          </tr>
2284        </thead>
2285        <tbody>
2286          <tr>
2287            <td>ts</td>
2288            <td>INT</td>
2289          </tr>
2290          <tr>
2291            <td>dur</td>
2292            <td>INT</td>
2293          </tr>
2294          <tr>
2295            <td>rd</td>
2296            <td>INT</td>
2297          </tr>
2298          <tr>
2299            <td>wr</td>
2300            <td>INT</td>
2301          </tr>
2302          <tr>
2303            <td>rd_speed</td>
2304            <td>REAL</td>
2305          </tr>
2306          <tr>
2307            <td>wr_speed</td>
2308            <td>REAL</td>
2309          </tr>
2310          <tr>
2311            <td>rd_count</td>
2312            <td>INT</td>
2313          </tr>
2314          <tr>
2315            <td>wr_count</td>
2316            <td>INT</td>
2317          </tr>
2318          <tr>
2319            <td>rd_count_speed</td>
2320            <td>REAL</td>
2321          </tr>
2322          <tr>
2323            <td>wr_count_speed</td>
2324            <td>REAL</td>
2325          </tr>
2326        </tbody>
2327      </table>
2328      <h4>表描述</h4>
2329      <p class="fontColor">记录了与磁盘读写相关的数据。</p>
2330      <h4>主要字段描述</h4>
2331      <ul class="fontColor">
2332        <li>rd_sectors_kb:读数据的速度</li>
2333        <li>wr_sectors_kb:写入数据的速度</li>
2334        <li>ts:时间戳</li>
2335      </ul>
2336      <h3>ebpf_callstack表</h3>
2337      <h4>表结构</h4>
2338      <table class="fontColor">
2339        <thead>
2340          <tr>
2341            <th class="fontColor">Columns Name</th>
2342            <th class="fontColor">SQL TYPE</th>
2343          </tr>
2344        </thead>
2345        <tbody>
2346          <tr>
2347            <td>id</td>
2348            <td>INT</td>
2349          </tr>
2350          <tr>
2351            <td>callchain_id</td>
2352            <td>INT</td>
2353          </tr>
2354          <tr>
2355            <td>depth</td>
2356            <td>TEXT</td>
2357          </tr>
2358          <tr>
2359            <td>ip</td>
2360            <td>TEXT</td>
2361          </tr>
2362          <tr>
2363            <td>symbols_id</td>
2364            <td>INT</td>
2365          </tr>
2366          <tr>
2367            <td>file_path_id</td>
2368            <td>INT</td>
2369          </tr>
2370        </tbody>
2371      </table>
2372      <h4>表描述</h4>
2373      <p class="fontColor">记录了与磁盘读写相关的数据。</p>
2374      <h4>主要字段描述</h4>
2375      <ul class="fontColor">
2376        <li>callchain_id:调用栈的唯一标识</li>
2377        <li>depth:调用栈深度。取值为零时表示栈顶</li>
2378        <li>ip:调用栈ip</li>
2379        <li>symbols_id:调用栈函数名称, 与data_dict中的id字段关联</li>
2380        <li>file_path_id:调用栈函数所属文件路径, 与data_dict中的id字段关联</li>
2381      </ul>
2382      <h3>file_system_sample表</h3>
2383      <h4>表结构</h4>
2384      <table class="fontColor">
2385        <thead>
2386          <tr>
2387            <th class="fontColor">Columns Name</th>
2388            <th class="fontColor">SQL TYPE</th>
2389          </tr>
2390        </thead>
2391        <tbody>
2392          <tr>
2393            <td>callchain_id</td>
2394            <td>INT</td>
2395          </tr>
2396          <tr>
2397            <td>type</td>
2398            <td>INT</td>
2399          </tr>
2400          <tr>
2401            <td>ipid</td>
2402            <td>INT</td>
2403          </tr>
2404          <tr>
2405            <td>itid</td>
2406            <td>INT</td>
2407          </tr>
2408          <tr>
2409            <td>start_ts</td>
2410            <td>INT</td>
2411          </tr>
2412          <tr>
2413            <td>end_ts</td>
2414            <td>INT</td>
2415          </tr>
2416          <tr>
2417            <td>dur</td>
2418            <td>INT</td>
2419          </tr>
2420          <tr>
2421            <td>return_value</td>
2422            <td>TEXT</td>
2423          </tr>
2424          <tr>
2425            <td>error_code</td>
2426            <td>TEXT</td>
2427          </tr>
2428          <tr>
2429            <td>fd</td>
2430            <td>INT</td>
2431          </tr>
2432          <tr>
2433            <td>file_id</td>
2434            <td>INT</td>
2435          </tr>
2436          <tr>
2437            <td>size</td>
2438            <td>INT</td>
2439          </tr>
2440          <tr>
2441            <td>first_argument</td>
2442            <td>TEXT</td>
2443          </tr>
2444          <tr>
2445            <td>second_argument</td>
2446            <td>TEXT</td>
2447          </tr>
2448          <tr>
2449            <td>third_argument</td>
2450            <td>TEXT</td>
2451          </tr>
2452          <tr>
2453            <td>fourth_argument</td>
2454            <td>TEXT</td>
2455          </tr>
2456        </tbody>
2457      </table>
2458      <h4>表描述</h4>
2459      <p class="fontColor">记录了调用栈的相关信息。</p>
2460      <h4>主要字段描述</h4>
2461      <ul class="fontColor">
2462        <li>callchain_id:调用栈信息ID与file_system_callstack表中call_chain_id字段相关联</li>
2463        <li>type:对应文件操作open,close,read,write</li>
2464        <li>ipid:线程所属的进程ID</li>
2465        <li>start_ts:开始时间</li>
2466        <li>end_ts:结束时间</li>
2467        <li>dur:耗时</li>
2468        <li>return_value:文件操作的返回值</li>
2469        <li>error_code:文件操作发生错误时的错误码</li>
2470        <li>fd:文件描述符fd</li>
2471        <li>file_id:当type为open,close时为其操作的文件路径,当type为read,write时为固定字段(null)</li>
2472        <li>size:在type为read,write时对应的文件的读或者写的大小</li>
2473        <li>first_argument:参数一</li>
2474        <li>second_argument:参数二</li>
2475        <li>third_argument:参数三</li>
2476        <li>fourth_argument:参数四</li>
2477      </ul>
2478      <h3>hidump表</h3>
2479      <h4>表结构</h4>
2480      <table class="fontColor">
2481        <thead>
2482          <tr>
2483            <th class="fontColor">Columns Name</th>
2484            <th class="fontColor">SQL TYPE</th>
2485          </tr>
2486        </thead>
2487        <tbody>
2488          <tr>
2489            <td>id</td>
2490            <td>INT</td>
2491          </tr>
2492          <tr>
2493            <td>ts</td>
2494            <td>INT</td>
2495          </tr>
2496          <tr>
2497            <td>fps</td>
2498            <td>INT</td>
2499          </tr>
2500        </tbody>
2501      </table>
2502      <h4>表描述</h4>
2503      <p class="fontColor">此表记录了设备的帧率信息,fps。</p>
2504      <h4>相关字段描述</h4>
2505      <ul class="fontColor">
2506        <li>fps:帧率值</li>
2507      </ul>
2508      <h3>hisys_event_measure表</h3>
2509      <h4>表结构</h4>
2510      <table class="fontColor">
2511        <thead>
2512          <tr>
2513            <th class="fontColor">Columns Name</th>
2514            <th class="fontColor">SQL TYPE</th>
2515          </tr>
2516        </thead>
2517        <tbody>
2518          <tr>
2519            <td>serial</td>
2520            <td>INT</td>
2521          </tr>
2522          <tr>
2523            <td>ts</td>
2524            <td>INT</td>
2525          </tr>
2526          <tr>
2527            <td>name_id</td>
2528            <td>INT</td>
2529          </tr>
2530          <tr>
2531            <td>key_id</td>
2532            <td>INT</td>
2533          </tr>
2534          <tr>
2535            <td>type</td>
2536            <td>INT</td>
2537          </tr>
2538          <tr>
2539            <td>int_value</td>
2540            <td>REAL</td>
2541          </tr>
2542          <tr>
2543            <td>string_value</td>
2544            <td>TEXT</td>
2545          </tr>
2546        </tbody>
2547      </table>
2548      <h4>表描述</h4>
2549      <p class="fontColor">记录所有的system event事件的相关数据,及其相关表的映射信息。</p>
2550      <h4>相关字段描述</h4>
2551      <ul class="fontColor">
2552        <li>serial:每条数据过来携带唯一一条id作为标识</li>
2553        <li>name_id:存放事件对应的ID,与data_dict表相关联可以取出对应的字段</li>
2554        <li>
2555          key_id:存放事件包含的字段的ID,与表app_name的id字段相关联,找到app_name表的
2556          id字段对应行的app_key字段与表data_dict表相关联取出对应的字段
2557        </li>
2558        <li>type:存放事件所包含的字段的值所属的类型为int型还是string(0为int,1为string)</li>
2559        <li>int_value:存放本事件所包含的字段的int型的值</li>
2560        <li>string_value:存放本事件所包含的字段的string型的值</li>
2561      </ul>
2562      <h3>instant表</h3>
2563      <h4>表结构</h4>
2564      <table class="fontColor">
2565        <thead>
2566          <tr>
2567            <th class="fontColor">Columns Name</th>
2568            <th class="fontColor">SQL TYPE</th>
2569          </tr>
2570        </thead>
2571        <tbody>
2572          <tr>
2573            <td>ts</td>
2574            <td>INT</td>
2575          </tr>
2576          <tr>
2577            <td>name</td>
2578            <td>TEXT</td>
2579          </tr>
2580          <tr>
2581            <td>ref</td>
2582            <td>INT</td>
2583          </tr>
2584          <tr>
2585            <td>wakeup_from</td>
2586            <td>INT</td>
2587          </tr>
2588          <tr>
2589            <td>ref_type</td>
2590            <td>TEXT</td>
2591          </tr>
2592          <tr>
2593            <td>value</td>
2594            <td>REAL</td>
2595          </tr>
2596        </tbody>
2597      </table>
2598      <h4>表描述</h4>
2599      <p class="fontColor">记录了系统中的waking和wakeup事件。</p>
2600      <h4>字段描述</h4>
2601      <ul class="fontColor">
2602        <li>ts:唤醒时间</li>
2603        <li>name:唤醒事件的名称</li>
2604        <li>ref:索引号</li>
2605        <li>wakeup_from:唤醒当前线程的内部线程号(itid)</li>
2606        <li>ref_type:描述了value字段的类型(一般取值为itid)</li>
2607        <li>value:一般为当前线程的内部线程号取值</li>
2608      </ul>
2609      <h3>irq表</h3>
2610      <h4>表结构</h4>
2611      <table class="fontColor">
2612        <thead>
2613          <tr>
2614            <th class="fontColor">Columns Name</th>
2615            <th class="fontColor">SQL TYPE</th>
2616          </tr>
2617        </thead>
2618        <tbody>
2619          <tr>
2620            <td>id</td>
2621            <td>INT</td>
2622          </tr>
2623          <tr>
2624            <td>ts</td>
2625            <td>INT</td>
2626          </tr>
2627          <tr>
2628            <td>dur</td>
2629            <td>INT</td>
2630          </tr>
2631          <tr>
2632            <td>callid</td>
2633            <td>INT</td>
2634          </tr>
2635          <tr>
2636            <td>cat</td>
2637            <td>TEXT</td>
2638          </tr>
2639          <tr>
2640            <td>name</td>
2641            <td>TEXT</td>
2642          </tr>
2643          <tr>
2644            <td>depth</td>
2645            <td>INT</td>
2646          </tr>
2647          <tr>
2648            <td>cookie</td>
2649            <td>INT</td>
2650          </tr>
2651          <tr>
2652            <td>parent_id</td>
2653            <td>INT</td>
2654          </tr>
2655          <tr>
2656            <td>argsetid</td>
2657            <td>INT</td>
2658          </tr>
2659          <tr>
2660            <td>chainId</td>
2661            <td>TEXT</td>
2662          </tr>
2663          <tr>
2664            <td>spanId</td>
2665            <td>TEXT</td>
2666          </tr>
2667          <tr>
2668            <td>parentSpanId</td>
2669            <td>TEXT</td>
2670          </tr>
2671          <tr>
2672            <td>flag</td>
2673            <td>TEXT</td>
2674          </tr>
2675          <tr>
2676            <td>args</td>
2677            <td>TEXT</td>
2678          </tr>
2679        </tbody>
2680      </table>
2681      <h4>表描述</h4>
2682      <p class="fontColor">记录中断相关事件。</p>
2683      <h4>相关字段描述</h4>
2684      <ul class="fontColor">
2685        <li>dur:调用中断时长</li>
2686        <li>callid:调用中断者的ID,比如针对线程表里面的id</li>
2687        <li>cat:调用栈数据类型(取值范围:irq,softirq...)</li>
2688        <li>name:调用中断的名称</li>
2689        <li>depth:中断调用的深度</li>
2690        <li>parent_id:父调用中断的id</li>
2691        <li>spanId:分布式调用中断关联关系</li>
2692      </ul>
2693      <h3>js_config表</h3>
2694      <h4>表结构</h4>
2695      <table class="fontColor">
2696        <thead>
2697          <tr>
2698            <th class="fontColor">Columns Name</th>
2699            <th class="fontColor">SQL TYPE</th>
2700          </tr>
2701        </thead>
2702        <tbody>
2703          <tr>
2704            <td>pid</td>
2705            <td>INT</td>
2706          </tr>
2707          <tr>
2708            <td>type</td>
2709            <td>INT</td>
2710          </tr>
2711          <tr>
2712            <td>interval</td>
2713            <td>INT</td>
2714          </tr>
2715          <tr>
2716            <td>capture_numeric_value</td>
2717            <td>INT</td>
2718          </tr>
2719          <tr>
2720            <td>trace_allocation</td>
2721            <td>INT</td>
2722          </tr>
2723          <tr>
2724            <td>enable_cpu_profiler</td>
2725            <td>INT</td>
2726          </tr>
2727          <tr>
2728            <td>cpu_profiler_interval</td>
2729            <td>INT</td>
2730          </tr>
2731        </tbody>
2732      </table>
2733      <h4>表描述</h4>
2734      <p class="fontColor">记录arkTs数据采集的相关配置。</p>
2735      <h4>相关字段描述</h4>
2736      <ul class="fontColor">
2737        <li>pid:目标进程ID。</li>
2738        <li>
2739          type:JS数据类型,取值与枚举HeapType对应,0表示JS内存数据为snapshot类型,1表示JS内存数据为timeline类型,-1表示没有JS内存数据。
2740        </li>
2741        <li>interval:当type=0时生效,单位是秒,表示一次snapshot事件和下一次snapshot事件之间的间隔。</li>
2742        <li>capture_numeric_value:当type=0时生效,表示是否同时抓取numeric。</li>
2743        <li>track_allocation:当type=1时生效,表示是否抓取allocations。</li>
2744        <li>enable_cpu_profiler:表示是否存在cpuprofiler的数据。</li>
2745        <li>cpu_profiler_interval:表示cpuprofiler数据的采集间隔。</li>
2746      </ul>
2747      <h3>js_cpu_profiler_node表</h3>
2748      <h4>表结构</h4>
2749      <table class="fontColor">
2750        <thead>
2751          <tr>
2752            <th class="fontColor">Columns Name</th>
2753            <th class="fontColor">SQL TYPE</th>
2754          </tr>
2755        </thead>
2756        <tbody>
2757          <tr>
2758            <td>function_id</td>
2759            <td>INT</td>
2760          </tr>
2761          <tr>
2762            <td>function_index</td>
2763            <td>INT</td>
2764          </tr>
2765          <tr>
2766            <td>script_id</td>
2767            <td>INT</td>
2768          </tr>
2769          <tr>
2770            <td>url_index</td>
2771            <td>INT</td>
2772          </tr>
2773          <tr>
2774            <td>line_number</td>
2775            <td>INT</td>
2776          </tr>
2777          <tr>
2778            <td>column_number</td>
2779            <td>INT</td>
2780          </tr>
2781          <tr>
2782            <td>hit_count</td>
2783            <td>INT</td>
2784          </tr>
2785          <tr>
2786            <td>children</td>
2787            <td>INT</td>
2788          </tr>
2789          <tr>
2790            <td>parent_id</td>
2791            <td>INT</td>
2792          </tr>
2793        </tbody>
2794      </table>
2795      <h4>表描述</h4>
2796      <p class="fontColor">记录cpu profiler中node节点的数据。</p>
2797      <h4>相关字段描述</h4>
2798      <ul class="fontColor">
2799        <li>function_id: 函数的ID号。</li>
2800        <li>function_index:函数名称在data_dict中的索引号。</li>
2801        <li>script_id:关联到的类对象所在文件的绝对路径ID。</li>
2802        <li>url_index:关联到的类对象所在文件的绝对路径名称在data_dict中的索引号。</li>
2803        <li>line_number:类对象所在文件的行号。</li>
2804        <li>column_number:类对象所在文件的列号。</li>
2805        <li>hit_count:采样次数。</li>
2806        <li>children:子节点的id号。</li>
2807        <li>parent_id:父节点的id号。</li>
2808      </ul>
2809      <h3>js_cpu_profiler_sample表</h3>
2810      <h4>表结构</h4>
2811      <table class="fontColor">
2812        <thead>
2813          <tr>
2814            <th class="fontColor">Columns Name</th>
2815            <th class="fontColor">SQL TYPE</th>
2816          </tr>
2817        </thead>
2818        <tbody>
2819          <tr>
2820            <td>id</td>
2821            <td>INT</td>
2822          </tr>
2823          <tr>
2824            <td>function_id</td>
2825            <td>INT</td>
2826          </tr>
2827          <tr>
2828            <td>start_time</td>
2829            <td>INT</td>
2830          </tr>
2831          <tr>
2832            <td>end_time</td>
2833            <td>INT</td>
2834          </tr>
2835          <tr>
2836            <td>dur</td>
2837            <td>INT</td>
2838          </tr>
2839        </tbody>
2840      </table>
2841      <h4>表描述</h4>
2842      <p class="fontColor">记录了cpu profiler 中sample节点的数据。</p>
2843      <h4>相关字段描述</h4>
2844      <ul class="fontColor">
2845        <li>id: ts内部ID号。</li>
2846        <li>function_id:函数的ID号。</li>
2847        <li>start_time:数据上报的起始时间。</li>
2848        <li>end_time:数据上报的终止时间。</li>
2849        <li>dur:数据上报的间隔时间。</li>
2850      </ul>
2851      <h3>js_heap_edges表</h3>
2852      <h4>表结构</h4>
2853      <table class="fontColor">
2854        <thead>
2855          <tr>
2856            <th class="fontColor">Columns Name</th>
2857            <th class="fontColor">SQL TYPE</th>
2858          </tr>
2859        </thead>
2860        <tbody>
2861          <tr>
2862            <td>file_id</td>
2863            <td>INT</td>
2864          </tr>
2865          <tr>
2866            <td>edge_index</td>
2867            <td>INT</td>
2868          </tr>
2869          <tr>
2870            <td>type</td>
2871            <td>INT</td>
2872          </tr>
2873          <tr>
2874            <td>name_or_index</td>
2875            <td>INT</td>
2876          </tr>
2877          <tr>
2878            <td>to_node</td>
2879            <td>INT</td>
2880          </tr>
2881          <tr>
2882            <td>from_node_id</td>
2883            <td>INT</td>
2884          </tr>
2885          <tr>
2886            <td>to_node_id</td>
2887            <td>INT</td>
2888          </tr>
2889        </tbody>
2890      </table>
2891      <h4>表描述</h4>
2892      <p class="fontColor">记录js内存数据类对象对应的成员的信息。</p>
2893      <h4>相关字段描述</h4>
2894      <ul class="fontColor">
2895        <li>file_id:文件ID</li>
2896        <li>edge_index:成员的索引号</li>
2897        <li>type:成员的类型,取值范围为js_heap_info表中的edge_types</li>
2898        <li>name_or_index:数据名称,取值为js_heap_string表中的下标索引</li>
2899        <li>to_node:此成员指向的类对象在nodes数组中的索引</li>
2900        <li>from_node_id:类对象ID,该类对象指向此成员数据</li>
2901        <li>to_node_id:此成员指向到的类对象nodes数组中的ID</li>
2902      </ul>
2903      <h3>js_heap_files表</h3>
2904      <h4>表结构</h4>
2905      <table class="fontColor">
2906        <thead>
2907          <tr>
2908            <th class="fontColor">Columns Name</th>
2909            <th class="fontColor">SQL TYPE</th>
2910          </tr>
2911        </thead>
2912        <tbody>
2913          <tr>
2914            <td>id</td>
2915            <td>INT</td>
2916          </tr>
2917          <tr>
2918            <td>file_name</td>
2919            <td>TEXT</td>
2920          </tr>
2921          <tr>
2922            <td>start_time</td>
2923            <td>INT</td>
2924          </tr>
2925          <tr>
2926            <td>end_time</td>
2927            <td>INT</td>
2928          </tr>
2929          <tr>
2930            <td>pid</td>
2931            <td>INT</td>
2932          </tr>
2933        </tbody>
2934      </table>
2935      <h4>表描述</h4>
2936      <p class="fontColor">记录了js内存数据的文件名称和时间。</p>
2937      <h4>相关字段描述</h4>
2938      <ul class="fontColor">
2939        <li>id:文件ID</li>
2940        <li>file_name:文件名称</li>
2941        <li>start_time:数据抓取的起始时间</li>
2942        <li>end_time:数据抓取的终止时间</li>
2943        <li>pid:进程号</li>
2944      </ul>
2945      <h3>js_heap_info表</h3>
2946      <h4>表结构</h4>
2947      <table class="fontColor">
2948        <thead>
2949          <tr>
2950            <th class="fontColor">Columns Name</th>
2951            <th class="fontColor">SQL TYPE</th>
2952          </tr>
2953        </thead>
2954        <tbody>
2955          <tr>
2956            <td>file_id</td>
2957            <td>INT</td>
2958          </tr>
2959          <tr>
2960            <td>key</td>
2961            <td>TEXT</td>
2962          </tr>
2963          <tr>
2964            <td>type</td>
2965            <td>INT</td>
2966          </tr>
2967          <tr>
2968            <td>int_value</td>
2969            <td>INT</td>
2970          </tr>
2971          <tr>
2972            <td>str_value</td>
2973            <td>TEXT</td>
2974          </tr>
2975        </tbody>
2976      </table>
2977      <h4>表描述</h4>
2978      <p class="fontColor">记录了js内存数据类型,如nodes和edges的字段类型和数据总数。</p>
2979      <h4>相关字段描述</h4>
2980      <ul class="fontColor">
2981        <li>file_id:文件ID</li>
2982        <li>key:类型名称</li>
2983        <li>type:数据类型索引</li>
2984        <li>int_value:int类型的数据值,如count类型数据</li>
2985        <li>str_value:string类型的数据值,如typename</li>
2986      </ul>
2987      <h3>js_heap_location表</h3>
2988      <h4>表结构</h4>
2989      <table class="fontColor">
2990        <thead>
2991          <tr>
2992            <th class="fontColor">Columns Name</th>
2993            <th class="fontColor">SQL TYPE</th>
2994          </tr>
2995        </thead>
2996        <tbody>
2997          <tr>
2998            <td>file_id</td>
2999            <td>INT</td>
3000          </tr>
3001          <tr>
3002            <td>object_index</td>
3003            <td>INT</td>
3004          </tr>
3005          <tr>
3006            <td>script_id</td>
3007            <td>INT</td>
3008          </tr>
3009          <tr>
3010            <td>line</td>
3011            <td>INT</td>
3012          </tr>
3013          <tr>
3014            <td>column</td>
3015            <td>INT</td>
3016          </tr>
3017        </tbody>
3018      </table>
3019      <h4>表描述</h4>
3020      <p class="fontColor">记录了js内存location节点相关数据,此表目前无抓取到的数据。</p>
3021      <h4>相关字段描述</h4>
3022      <ul class="fontColor">
3023        <li>file_id:文件ID</li>
3024        <li>object_index:与location关联的类对象的索引,取值为js_heap_nodes的下标索引</li>
3025        <li>script_id:关联到的类对象所在文件的绝对路径ID</li>
3026        <li>line:在类对象所在的文件中的行号</li>
3027        <li>column:在类对象所在的文件中的列号</li>
3028      </ul>
3029      <h3>js_heap_nodes表</h3>
3030      <h4>表结构</h4>
3031      <table class="fontColor">
3032        <thead>
3033          <tr>
3034            <th class="fontColor">Columns Name</th>
3035            <th class="fontColor">SQL TYPE</th>
3036          </tr>
3037        </thead>
3038        <tbody>
3039          <tr>
3040            <td>file_id</td>
3041            <td>INT</td>
3042          </tr>
3043          <tr>
3044            <td>node_index</td>
3045            <td>TEXT</td>
3046          </tr>
3047          <tr>
3048            <td>type</td>
3049            <td>INT</td>
3050          </tr>
3051          <tr>
3052            <td>name</td>
3053            <td>INT</td>
3054          </tr>
3055          <tr>
3056            <td>id</td>
3057            <td>TEXT</td>
3058          </tr>
3059          <tr>
3060            <td>self_size</td>
3061            <td>INT</td>
3062          </tr>
3063          <tr>
3064            <td>edge_count</td>
3065            <td>INT</td>
3066          </tr>
3067          <tr>
3068            <td>trace_node_id</td>
3069            <td>INT</td>
3070          </tr>
3071          <tr>
3072            <td>detachedness</td>
3073            <td>INT</td>
3074          </tr>
3075        </tbody>
3076      </table>
3077      <h4>表描述</h4>
3078      <p class="fontColor">记录了js内存数据中类对象的数据。</p>
3079      <h4>相关字段描述</h4>
3080      <ul class="fontColor">
3081        <li>file_id:文件ID</li>
3082        <li>node_index:类对象的索引</li>
3083        <li>type:类对象的类型</li>
3084        <li>name:类对象的名称</li>
3085        <li>id:类对象的唯一ID</li>
3086        <li>self_size:该类对象所有成员的大小(以字节为单位)</li>
3087        <li>edge_count:该类对象指向的类成员的个数</li>
3088        <li>trace_node_id:该类对象关联到js_heap_trace_node表中的调用栈ID</li>
3089        <li>detachedness:是否可以从window全局对象访问此节点,0表示是,1表示否</li>
3090      </ul>
3091      <h3>js_heap_sample表</h3>
3092      <h4>表结构</h4>
3093      <table class="fontColor">
3094        <thead>
3095          <tr>
3096            <th class="fontColor">Columns Name</th>
3097            <th class="fontColor">SQL TYPE</th>
3098          </tr>
3099        </thead>
3100        <tbody>
3101          <tr>
3102            <td>file_id</td>
3103            <td>INT</td>
3104          </tr>
3105          <tr>
3106            <td>timestamp_us</td>
3107            <td>INT</td>
3108          </tr>
3109          <tr>
3110            <td>last_assigned_id</td>
3111            <td>INT</td>
3112          </tr>
3113        </tbody>
3114      </table>
3115      <h4>表描述</h4>
3116      <p class="fontColor">记录了timeline模式下的时间轴信息。</p>
3117      <h4>相关字段描述</h4>
3118      <ul class="fontColor">
3119        <li>file_id:文件ID</li>
3120        <li>timestamp_us:时间信息</li>
3121        <li>last_assigned_id:当前时间点的id</li>
3122      </ul>
3123      <h3>js_heap_string表</h3>
3124      <h4>表结构</h4>
3125      <table class="fontColor">
3126        <thead>
3127          <tr>
3128            <th class="fontColor">Columns Name</th>
3129            <th class="fontColor">SQL TYPE</th>
3130          </tr>
3131        </thead>
3132        <tbody>
3133          <tr>
3134            <td>file_id</td>
3135            <td>INT</td>
3136          </tr>
3137          <tr>
3138            <td>file_index</td>
3139            <td>INT</td>
3140          </tr>
3141          <tr>
3142            <td>string</td>
3143            <td>TEXT</td>
3144          </tr>
3145        </tbody>
3146      </table>
3147      <h4>表描述</h4>
3148      <p class="fontColor">记录了js内存数据中的字符串。</p>
3149      <h4>相关字段描述</h4>
3150      <ul class="fontColor">
3151        <li>file_id:文件ID</li>
3152        <li>file_index:索引</li>
3153        <li>string:对应的字符串信息</li>
3154      </ul>
3155      <h3>js_heap_trace_function_info表</h3>
3156      <h4>表结构</h4>
3157      <table class="fontColor">
3158        <thead>
3159          <tr>
3160            <th class="fontColor">Columns Name</th>
3161            <th class="fontColor">SQL TYPE</th>
3162          </tr>
3163        </thead>
3164        <tbody>
3165          <tr>
3166            <td>file_id</td>
3167            <td>INT</td>
3168          </tr>
3169          <tr>
3170            <td>function_index</td>
3171            <td>INT</td>
3172          </tr>
3173          <tr>
3174            <td>function_id</td>
3175            <td>INT</td>
3176          </tr>
3177          <tr>
3178            <td>name</td>
3179            <td>INT</td>
3180          </tr>
3181          <tr>
3182            <td>script_name</td>
3183            <td>INT</td>
3184          </tr>
3185          <tr>
3186            <td>script_id</td>
3187            <td>INT</td>
3188          </tr>
3189          <tr>
3190            <td>line</td>
3191            <td>INT</td>
3192          </tr>
3193          <tr>
3194            <td>column</td>
3195            <td>INT</td>
3196          </tr>
3197        </tbody>
3198      </table>
3199      <h4>表描述</h4>
3200      <p class="fontColor">记录了timeline模式下的调用栈的每个函数信息。</p>
3201      <h4>相关字段描述</h4>
3202      <ul class="fontColor">
3203        <li>file_id:文件ID</li>
3204        <li>function_index:函数索引</li>
3205        <li>function_id:函数ID</li>
3206        <li>name:函数名称</li>
3207        <li>script_name:关联到的类对象所在文件的绝对路径名称</li>
3208        <li>script_id:关联到的类对象所在文件的绝对路径ID</li>
3209        <li>line:在类对象所在的文件中的行号</li>
3210        <li>column:在类对象所在的文件中的列号</li>
3211      </ul>
3212      <h3>js_heap_trace_node表</h3>
3213      <h4>表结构</h4>
3214      <table class="fontColor">
3215        <thead>
3216          <tr>
3217            <th class="fontColor">Columns Name</th>
3218            <th class="fontColor">SQL TYPE</th>
3219          </tr>
3220        </thead>
3221        <tbody>
3222          <tr>
3223            <td>file_id</td>
3224            <td>INT</td>
3225          </tr>
3226          <tr>
3227            <td>id</td>
3228            <td>INT</td>
3229          </tr>
3230          <tr>
3231            <td>function_info_index</td>
3232            <td>INT</td>
3233          </tr>
3234          <tr>
3235            <td>count</td>
3236            <td>INT</td>
3237          </tr>
3238          <tr>
3239            <td>size</td>
3240            <td>INT</td>
3241          </tr>
3242          <tr>
3243            <td>parent_id</td>
3244            <td>INT</td>
3245          </tr>
3246        </tbody>
3247      </table>
3248      <h4>表描述</h4>
3249      <p class="fontColor">记录了timeline模式下的调用栈的信息。</p>
3250      <h4>相关字段描述</h4>
3251      <ul class="fontColor">
3252        <li>file_id:文件ID</li>
3253        <li>id:调用栈节点索引</li>
3254        <li>function_info_index:函数信息索引</li>
3255        <li>count:调用栈个数</li>
3256        <li>size:调用栈大小</li>
3257        <li>parent_id:调用栈父节点</li>
3258      </ul>
3259      <h3>app_startup表</h3>
3260      <h4>表结构</h4>
3261      <table class="fontColor">
3262        <thead>
3263          <tr>
3264            <th class="fontColor">Columns Name</th>
3265            <th class="fontColor">SQL TYPE</th>
3266          </tr>
3267        </thead>
3268        <tbody>
3269          <tr>
3270            <td>call_id</td>
3271            <td>INT</td>
3272          </tr>
3273          <tr>
3274            <td>ipid</td>
3275            <td>INT</td>
3276          </tr>
3277          <tr>
3278            <td>tid</td>
3279            <td>INT</td>
3280          </tr>
3281          <tr>
3282            <td>start_time</td>
3283            <td>INT</td>
3284          </tr>
3285          <tr>
3286            <td>end_time</td>
3287            <td>INT</td>
3288          </tr>
3289          <tr>
3290            <td>start_name</td>
3291            <td>INT</td>
3292          </tr>
3293          <tr>
3294            <td>packed_name</td>
3295            <td>INT</td>
3296          </tr>
3297        </tbody>
3298      </table>
3299      <h4>表描述</h4>
3300      <p class="fontColor">记录了应用启动的相关信息。</p>
3301      <h4>相关字段描述</h4>
3302      <ul class="fontColor">
3303        <li>call_id:调用者的ID,比如针对线程表里面的id</li>
3304        <li>ipid:内部进程号</li>
3305        <li>tid:内部线程号</li>
3306        <li>start_time:阶段开始时间</li>
3307        <li>end_time:阶段结束时间</li>
3308        <li>start_name:阶段名称</li>
3309        <li>packed_name:应用名称</li>
3310      </ul>
3311      <h3>static_intialize表</h3>
3312      <h4>表结构</h4>
3313      <table class="fontColor">
3314        <thead>
3315          <tr>
3316            <th class="fontColor">Columns Name</th>
3317            <th class="fontColor">SQL TYPE</th>
3318          </tr>
3319        </thead>
3320        <tbody>
3321          <tr>
3322            <td>call_id</td>
3323            <td>INT</td>
3324          </tr>
3325          <tr>
3326            <td>ipid</td>
3327            <td>INT</td>
3328          </tr>
3329          <tr>
3330            <td>tid</td>
3331            <td>INT</td>
3332          </tr>
3333          <tr>
3334            <td>start_time</td>
3335            <td>INT</td>
3336          </tr>
3337          <tr>
3338            <td>end_time</td>
3339            <td>INT</td>
3340          </tr>
3341          <tr>
3342            <td>so_name</td>
3343            <td>INT</td>
3344          </tr>
3345          <tr>
3346            <td>depth</td>
3347            <td>INT</td>
3348          </tr>
3349        </tbody>
3350      </table>
3351      <h4>表描述</h4>
3352      <p class="fontColor">记录了so初始化的相关信息。</p>
3353      <h4>相关字段描述</h4>
3354      <ul class="fontColor">
3355        <li>call_id:调用者的ID,比如针对线程表里面的id</li>
3356        <li>ipid:内部进程号</li>
3357        <li>tid:内部线程号</li>
3358        <li>start_time:阶段开始时间</li>
3359        <li>end_time:阶段结束时间</li>
3360        <li>so_name:so文件名称</li>
3361        <li>depth:泳道图的深度</li>
3362      </ul>
3363      <h3>live_process表</h3>
3364      <h4>表结构</h4>
3365      <table class="fontColor">
3366        <thead>
3367          <tr>
3368            <th class="fontColor">Columns Name</th>
3369            <th class="fontColor">SQL TYPE</th>
3370          </tr>
3371        </thead>
3372        <tbody>
3373          <tr>
3374            <td>ts</td>
3375            <td>INT</td>
3376          </tr>
3377          <tr>
3378            <td>dur</td>
3379            <td>INT</td>
3380          </tr>
3381          <tr>
3382            <td>cpu_time</td>
3383            <td>INT</td>
3384          </tr>
3385          <tr>
3386            <td>process_id</td>
3387            <td>INT</td>
3388          </tr>
3389          <tr>
3390            <td>process_name</td>
3391            <td>TEXT</td>
3392          </tr>
3393          <tr>
3394            <td>parent_process_id</td>
3395            <td>INT</td>
3396          </tr>
3397          <tr>
3398            <td>uid</td>
3399            <td>INT</td>
3400          </tr>
3401          <tr>
3402            <td>user_name</td>
3403            <td>TEXT</td>
3404          </tr>
3405          <tr>
3406            <td>cpu_usage</td>
3407            <td>REAL</td>
3408          </tr>
3409          <tr>
3410            <td>pss_info</td>
3411            <td>INT</td>
3412          </tr>
3413          <tr>
3414            <td>thread_num</td>
3415            <td>INT</td>
3416          </tr>
3417          <tr>
3418            <td>disk_writes</td>
3419            <td>INT</td>
3420          </tr>
3421          <tr>
3422            <td>disk_reads</td>
3423            <td>INT</td>
3424          </tr>
3425        </tbody>
3426      </table>
3427      <h4>表描述</h4>
3428      <p class="fontColor">记录了一些实时的进程中执行的一些数据(Monitor)。</p>
3429      <h4>主要字段描述</h4>
3430      <ul class="fontColor">
3431        <li>process_id:进程id</li>
3432        <li>process_name:进程名</li>
3433        <li>parent_process_id:父进程的id</li>
3434        <li>uid:用户id</li>
3435        <li>user_name:用户名</li>
3436        <li>cpu_usage:cpu使用率</li>
3437        <li>pss_info:进程信息</li>
3438        <li>thread_num:线程数量</li>
3439        <li>disk_writes:磁盘写量</li>
3440        <li>disk_reads:磁盘读量</li>
3441      </ul>
3442      <h3>log表</h3>
3443      <h4>表结构</h4>
3444      <table class="fontColor">
3445        <thead>
3446          <tr>
3447            <th class="fontColor">Columns Name</th>
3448            <th class="fontColor">SQL TYPE</th>
3449          </tr>
3450        </thead>
3451        <tbody>
3452          <tr>
3453            <td>seq</td>
3454            <td>INT</td>
3455          </tr>
3456          <tr>
3457            <td>ts</td>
3458            <td>INT</td>
3459          </tr>
3460          <tr>
3461            <td>pid</td>
3462            <td>INT</td>
3463          </tr>
3464          <tr>
3465            <td>tid</td>
3466            <td>INT</td>
3467          </tr>
3468          <tr>
3469            <td>level</td>
3470            <td>TEXT</td>
3471          </tr>
3472          <tr>
3473            <td>tag</td>
3474            <td>TEXT</td>
3475          </tr>
3476          <tr>
3477            <td>context</td>
3478            <td>TEXT</td>
3479          </tr>
3480          <tr>
3481            <td>origints</td>
3482            <td>INT</td>
3483          </tr>
3484        </tbody>
3485      </table>
3486      <h4>表描述</h4>
3487      <p class="fontColor">记录日志信息。</p>
3488      <h4>关键字段描述</h4>
3489      <ul class="fontColor">
3490        <li>Seq:日志序号,保证日志解析的准确性</li>
3491        <li>Ts:打印日志时间</li>
3492        <li>Pid:日志的进程号</li>
3493        <li>Tid:日志的线程号</li>
3494        <li>Level:日志级别</li>
3495        <li>Tag:日志标签</li>
3496        <li>Context:日志内容</li>
3497      </ul>
3498      <h3>measure表</h3>
3499      <h4>表结构</h4>
3500      <table class="fontColor">
3501        <thead>
3502          <tr>
3503            <th class="fontColor">Columns Name</th>
3504            <th class="fontColor">SQL TYPE</th>
3505          </tr>
3506        </thead>
3507        <tbody>
3508          <tr>
3509            <td>type</td>
3510            <td>TEXT</td>
3511          </tr>
3512          <tr>
3513            <td>ts</td>
3514            <td>INT</td>
3515          </tr>
3516          <tr>
3517            <td>dur</td>
3518            <td>INT</td>
3519          </tr>
3520          <tr>
3521            <td>value</td>
3522            <td>INT</td>
3523          </tr>
3524          <tr>
3525            <td>filter_id</td>
3526            <td>INT</td>
3527          </tr>
3528        </tbody>
3529      </table>
3530      <h4>表描述</h4>
3531      <p class="fontColor">记录所有的计量值。</p>
3532      <h4>关键字段描述</h4>
3533      <ul class="fontColor">
3534        <li>type:固定字段(measure)</li>
3535        <li>ts:事件时间</li>
3536        <li>dur:该值持续的时长</li>
3537        <li>value:数值</li>
3538        <li>filter_id:对应filter表中的ID</li>
3539      </ul>
3540      <h3>measure_filter表</h3>
3541      <h4>表结构</h4>
3542      <table class="fontColor">
3543        <thead>
3544          <tr>
3545            <th class="fontColor">Columns Name</th>
3546            <th class="fontColor">SQL TYPE</th>
3547          </tr>
3548        </thead>
3549        <tbody>
3550          <tr>
3551            <td>id</td>
3552            <td>INT</td>
3553          </tr>
3554          <tr>
3555            <td>type</td>
3556            <td>TEXT</td>
3557          </tr>
3558          <tr>
3559            <td>name</td>
3560            <td>TEXT</td>
3561          </tr>
3562          <tr>
3563            <td>source_arg_set_id</td>
3564            <td>INT</td>
3565          </tr>
3566        </tbody>
3567      </table>
3568      <h4>表描述</h4>
3569      <p class="fontColor">
3570        记录一个递增的filterid队列,所有其他的filter类型在获取过程中,均从此数据列表中获取下一个可用的filter_id并做记录。
3571      </p>
3572      <h4>字段详细描述</h4>
3573      <p class="fontColor">
3574        过滤分类(type),过滤名称(key2),数据ID(key1)。<br />
3575        数据ID在process_measure_filter, sys_event_filter中作为id。
3576      </p>
3577      <h3>meta表</h3>
3578      <h4>表结构</h4>
3579      <table class="fontColor">
3580        <thead>
3581          <tr>
3582            <th class="fontColor">Columns Name</th>
3583            <th class="fontColor">SQL TYPE</th>
3584          </tr>
3585        </thead>
3586        <tbody>
3587          <tr>
3588            <td>name</td>
3589            <td>TEXT</td>
3590          </tr>
3591          <tr>
3592            <td>value</td>
3593            <td>TEXT</td>
3594          </tr>
3595        </tbody>
3596      </table>
3597      <h4>表描述</h4>
3598      <p class="fontColor">
3599        此表记录了数据解析或导出时的一些现场数据,比如使用的TraceStreamer版本,
3600        工具的发布时间,数据解析的时间,数据的持续时长,以及原始数据的格式。
3601      </p>
3602      <h4>主要字段描述</h4>
3603      <ul class="fontColor">
3604        <li>Name:指定元数据的key</li>
3605        <li>Value:指定元数据的value</li>
3606      </ul>
3607      <h3>native_hook表</h3>
3608      <h4>表结构</h4>
3609      <table class="fontColor">
3610        <thead>
3611          <tr>
3612            <th class="fontColor">Columns Name</th>
3613            <th class="fontColor">SQL TYPE</th>
3614          </tr>
3615        </thead>
3616        <tbody>
3617          <tr>
3618            <td>id</td>
3619            <td>INT</td>
3620          </tr>
3621          <tr>
3622            <td>callChainId</td>
3623            <td>INT</td>
3624          </tr>
3625          <tr>
3626            <td>ipid</td>
3627            <td>INT</td>
3628          </tr>
3629          <tr>
3630            <td>itid</td>
3631            <td>INT</td>
3632          </tr>
3633          <tr>
3634            <td>event_type</td>
3635            <td>TEXT</td>
3636          </tr>
3637          <tr>
3638            <td>sub_type_id</td>
3639            <td>NUM</td>
3640          </tr>
3641          <tr>
3642            <td>start_ts</td>
3643            <td>INT</td>
3644          </tr>
3645          <tr>
3646            <td>end_ts</td>
3647            <td>INT</td>
3648          </tr>
3649          <tr>
3650            <td>dur</td>
3651            <td>INT</td>
3652          </tr>
3653          <tr>
3654            <td>addr</td>
3655            <td>INT</td>
3656          </tr>
3657          <tr>
3658            <td>heap_size</td>
3659            <td>INT</td>
3660          </tr>
3661          <tr>
3662            <td>all_heap_size</td>
3663            <td>INT</td>
3664          </tr>
3665          <tr>
3666            <td>current_size_dur</td>
3667            <td>INT</td>
3668          </tr>
3669          <tr>
3670            <td>last_lib_id</td>
3671            <td>INT</td>
3672          </tr>
3673        </tbody>
3674      </table>
3675      <h4>表描述</h4>
3676      <p class="fontColor">记录native_hook抓取的某个进程的堆内存,内存映射相关数据。</p>
3677      <h4>关键字段描述</h4>
3678      <ul class="fontColor">
3679        <li>callChainId:唯一标识一条native_hook数据</li>
3680        <li>event_type:事件类型取值范围(AllocEvent,FreeEvent,MmapEvent, MunmapEvent)</li>
3681        <li>sub_type_id:子事件类型(只有sub_type字段为MmapEvent时,该字段才会有值)</li>
3682        <li>start_ts:申请内存开始时间</li>
3683        <li>end_ts:释放内存时间</li>
3684        <li>Dur:申请内存活跃时间</li>
3685        <li>Addr:申请内存地址</li>
3686        <li>mem_size:申请或释放内存大小</li>
3687        <li>
3688          all_mem_size:从采集数据开始到当前时刻,申请并活跃的内存总量。
3689          event_type为AllocEvent或者FreeEvent时,表示活跃的堆内存总量。当event_type为MmapEvent或者MunmapEvent时,表示活跃的映射内存总量
3690        </li>
3691        <li>current_size_dur:表示当前活跃内存总量的持续时间</li>
3692        <li>last_lib_id:函数调用栈他最后一个函数所属的文件路径,除了文件名中带musl和libc++</li>
3693      </ul>
3694      <h3>native_hook_frame表</h3>
3695      <h4>表结构</h4>
3696      <table class="fontColor">
3697        <thead>
3698          <tr>
3699            <th class="fontColor">Columns Name</th>
3700            <th class="fontColor">SQL TYPE</th>
3701          </tr>
3702        </thead>
3703        <tbody>
3704          <tr>
3705            <td>id</td>
3706            <td>INT</td>
3707          </tr>
3708          <tr>
3709            <td>callchain_id</td>
3710            <td>INT</td>
3711          </tr>
3712          <tr>
3713            <td>depth</td>
3714            <td>INT</td>
3715          </tr>
3716          <tr>
3717            <td>symbol_id</td>
3718            <td>INT</td>
3719          </tr>
3720          <tr>
3721            <td>file_id</td>
3722            <td>INT</td>
3723          </tr>
3724          <tr>
3725            <td>offset</td>
3726            <td>INT</td>
3727          </tr>
3728          <tr>
3729            <td>symbol_offset</td>
3730            <td>INT</td>
3731          </tr>
3732        </tbody>
3733      </table>
3734      <h4>表描述</h4>
3735      <p class="fontColor">记录了内存的申请和释放的堆栈。</p>
3736      <h4>相关字段描述</h4>
3737      <ul class="fontColor">
3738        <li>callchain_id:标识一组调用堆栈</li>
3739        <li>depth:调用栈深度</li>
3740        <li>symbol_id:函数名</li>
3741        <li>file_id:函数所属文件</li>
3742      </ul>
3743      <h3>native_hook_statistic表</h3>
3744      <h4>表结构</h4>
3745      <table class="fontColor">
3746        <thead>
3747          <tr>
3748            <th class="fontColor">Columns Name</th>
3749            <th class="fontColor">SQL TYPE</th>
3750          </tr>
3751        </thead>
3752        <tbody>
3753          <tr>
3754            <td>id</td>
3755            <td>INT</td>
3756          </tr>
3757          <tr>
3758            <td>callchain_id</td>
3759            <td>INT</td>
3760          </tr>
3761          <tr>
3762            <td>ipid</td>
3763            <td>INT</td>
3764          </tr>
3765          <tr>
3766            <td>ts</td>
3767            <td>INT</td>
3768          </tr>
3769          <tr>
3770            <td>type</td>
3771            <td>INT</td>
3772          </tr>
3773          <tr>
3774            <td>apply_count</td>
3775            <td>INT</td>
3776          </tr>
3777          <tr>
3778            <td>release_count</td>
3779            <td>INT</td>
3780          </tr>
3781          <tr>
3782            <td>apply_size</td>
3783            <td>INT</td>
3784          </tr>
3785          <tr>
3786            <td>release_size</td>
3787            <td>INT</td>
3788          </tr>
3789        </tbody>
3790      </table>
3791      <h4>表描述</h4>
3792      <p class="fontColor">该表记录了内存申请/释放的统计信息。</p>
3793      <h4>关键字段描述</h4>
3794      <ul class="fontColor">
3795        <li>callchain_id:内存分配的回调链id</li>
3796        <li>ipid:进程id</li>
3797        <li>ts:统计数据上报时间</li>
3798        <li>type:事件类型,0代表malloc事件,1代表mmap事件</li>
3799        <li>apply_count:当前调用栈内存分配总次数</li>
3800        <li>release_count:当前调用栈内存释放总次数</li>
3801        <li>apply_size:当前调用栈累计分配总大小</li>
3802        <li>release_size:当前调用栈累计释放总大小</li>
3803      </ul>
3804      <h3>network表</h3>
3805      <h4>表结构</h4>
3806      <table class="fontColor">
3807        <thead>
3808          <tr>
3809            <th class="fontColor">Columns Name</th>
3810            <th class="fontColor">SQL TYPE</th>
3811          </tr>
3812        </thead>
3813        <tbody>
3814          <tr>
3815            <td>ts</td>
3816            <td>INT</td>
3817          </tr>
3818          <tr>
3819            <td>dur</td>
3820            <td>INT</td>
3821          </tr>
3822          <tr>
3823            <td>tx</td>
3824            <td>INT</td>
3825          </tr>
3826          <tr>
3827            <td>rx</td>
3828            <td>INT</td>
3829          </tr>
3830          <tr>
3831            <td>tx_speed</td>
3832            <td>REAL</td>
3833          </tr>
3834          <tr>
3835            <td>rx_speed</td>
3836            <td>REAL</td>
3837          </tr>
3838          <tr>
3839            <td>packet_in</td>
3840            <td>INT</td>
3841          </tr>
3842          <tr>
3843            <td>packet_in_sec</td>
3844            <td>REAL</td>
3845          </tr>
3846          <tr>
3847            <td>packet_out</td>
3848            <td>INT</td>
3849          </tr>
3850          <tr>
3851            <td>packet_out_sec</td>
3852            <td>REAL</td>
3853          </tr>
3854          <tr>
3855            <td>net_type</td>
3856            <td>TEXT</td>
3857          </tr>
3858        </tbody>
3859      </table>
3860      <h4>表描述</h4>
3861      <p class="fontColor">记录了网络数据传输相关的信息。</p>
3862      <h4>主要字段描述</h4>
3863      <ul class="fontColor">
3864        <li>tv_sec:时间,秒为单位</li>
3865        <li>tv_nsec:时间,纳秒为单位</li>
3866        <li>tx_bytes:网络数据的写入量</li>
3867        <li>rx_bytes:网络数据的读取量</li>
3868      </ul>
3869      <h3>paged_memory_sample表</h3>
3870      <h4>表结构</h4>
3871      <table class="fontColor">
3872        <thead>
3873          <tr>
3874            <th class="fontColor">Columns Name</th>
3875            <th class="fontColor">SQL TYPE</th>
3876          </tr>
3877        </thead>
3878        <tbody>
3879          <tr>
3880            <td>id</td>
3881            <td>INT</td>
3882          </tr>
3883          <tr>
3884            <td>callchain_id</td>
3885            <td>INT</td>
3886          </tr>
3887          <tr>
3888            <td>type</td>
3889            <td>INT</td>
3890          </tr>
3891          <tr>
3892            <td>ipid</td>
3893            <td>INT</td>
3894          </tr>
3895          <tr>
3896            <td>start_ts</td>
3897            <td>INT</td>
3898          </tr>
3899          <tr>
3900            <td>end_ts</td>
3901            <td>INT</td>
3902          </tr>
3903          <tr>
3904            <td>dur</td>
3905            <td>INT</td>
3906          </tr>
3907          <tr>
3908            <td>size</td>
3909            <td>INT</td>
3910          </tr>
3911          <tr>
3912            <td>addr</td>
3913            <td>TEXT</td>
3914          </tr>
3915          <tr>
3916            <td>itid</td>
3917            <td>INT</td>
3918          </tr>
3919        </tbody>
3920      </table>
3921      <h4>表描述</h4>
3922      <p class="fontColor">记录了网络数据传输相关的信息。</p>
3923      <h4>主要字段描述</h4>
3924      <ul class="fontColor">
3925        <li>callchain_id: 取值相同的一组数据,表示一个完整的调用栈</li>
3926        <li>type:事件类型</li>
3927        <li>ipid:TS内部进程号</li>
3928        <li>start_ts:开始时间</li>
3929        <li>end_ts:结束时间</li>
3930        <li>dur:持续时间</li>
3931        <li>size:操作页数</li>
3932        <li>itid:TS内部线程号</li>
3933      </ul>
3934      <h3>perf_callchain表</h3>
3935      <h4>表结构</h4>
3936      <table class="fontColor">
3937        <thead>
3938          <tr>
3939            <th class="fontColor">Columns Name</th>
3940            <th class="fontColor">SQL TYPE</th>
3941          </tr>
3942        </thead>
3943        <tbody>
3944          <tr>
3945            <td>id</td>
3946            <td>INT</td>
3947          </tr>
3948          <tr>
3949            <td>callchain_id</td>
3950            <td>INT</td>
3951          </tr>
3952          <tr>
3953            <td>depth</td>
3954            <td>INT</td>
3955          </tr>
3956          <tr>
3957            <td>vaddr_in_file</td>
3958            <td>INT</td>
3959          </tr>
3960          <tr>
3961            <td>file_id</td>
3962            <td>INT</td>
3963          </tr>
3964          <tr>
3965            <td>symbol_id</td>
3966            <td>INT</td>
3967          </tr>
3968          <tr>
3969            <td>name</td>
3970            <td>TEXT</td>
3971          </tr>
3972        </tbody>
3973      </table>
3974      <h4>表描述</h4>
3975      <p class="fontColor">记录了Hiperf采样数据的调用栈信息。</p>
3976      <h4>主要字段描述</h4>
3977      <ul class="fontColor">
3978        <li>callchain_id:标识一组调用堆栈</li>
3979        <li>depth:调用栈深度</li>
3980        <li>vaddr_in_file:函数在文件中的虚拟地址</li>
3981        <li>file_id:与PerfFiles中的file_id字段相关联</li>
3982        <li>symbol_id:与PerfFiles中的symbol_id相关联</li>
3983        <li>name:函数名</li>
3984      </ul>
3985      <h3>perf_files表</h3>
3986      <h4>表结构</h4>
3987      <table class="fontColor">
3988        <thead>
3989          <tr>
3990            <th class="fontColor">Columns Name</th>
3991            <th class="fontColor">SQL TYPE</th>
3992          </tr>
3993        </thead>
3994        <tbody>
3995          <tr>
3996            <td>id</td>
3997            <td>INT</td>
3998          </tr>
3999          <tr>
4000            <td>file_id</td>
4001            <td>INT</td>
4002          </tr>
4003          <tr>
4004            <td>serial_id</td>
4005            <td>INT</td>
4006          </tr>
4007          <tr>
4008            <td>symbol</td>
4009            <td>TEXT</td>
4010          </tr>
4011          <tr>
4012            <td>path</td>
4013            <td>TEXT</td>
4014          </tr>
4015        </tbody>
4016      </table>
4017      <h4>表描述</h4>
4018      <p class="fontColor">记录Hiperf工具采集到的函数符号表和文件名。</p>
4019      <h4>主要字段描述</h4>
4020      <ul class="fontColor">
4021        <li>file_id:文件编号</li>
4022        <li>serial_id:一个文件中可能有多个函数,serial_id表示函数的编号</li>
4023        <li>symbol:函数名</li>
4024        <li>path:文件路径</li>
4025      </ul>
4026      <h3>perf_report表</h3>
4027      <h4>表结构</h4>
4028      <table class="fontColor">
4029        <thead>
4030          <tr>
4031            <th class="fontColor">Columns Name</th>
4032            <th class="fontColor">SQL TYPE</th>
4033          </tr>
4034        </thead>
4035        <tbody>
4036          <tr>
4037            <td>id</td>
4038            <td>INT</td>
4039          </tr>
4040          <tr>
4041            <td>report_type</td>
4042            <td>TEXT</td>
4043          </tr>
4044          <tr>
4045            <td>report_value</td>
4046            <td>TEXT</td>
4047          </tr>
4048        </tbody>
4049      </table>
4050      <h4>表描述</h4>
4051      <p class="fontColor">
4052        记录Hiperf工具采集数据时的配置信息。包括:抓取的事件类型,抓取数据的命令, 抓数据时指定的进程名称。
4053      </p>
4054      <h4>主要字段描述</h4>
4055      <ul class="fontColor">
4056        <li>
4057          report_type:数据类型。取值只有三种类型:config_name(事件类型), workload(抓取的进程名),
4058          cmdline(抓取命令)
4059        </li>
4060        <li>report_value:对应类型的取值</li>
4061      </ul>
4062      <h3>perf_sample表</h3>
4063      <h4>表结构</h4>
4064      <table class="fontColor">
4065        <thead>
4066          <tr>
4067            <th class="fontColor">Columns Name</th>
4068            <th class="fontColor">SQL TYPE</th>
4069          </tr>
4070        </thead>
4071        <tbody>
4072          <tr>
4073            <td>id</td>
4074            <td>INT</td>
4075          </tr>
4076          <tr>
4077            <td>callchain_id</td>
4078            <td>INT</td>
4079          </tr>
4080          <tr>
4081            <td>timestamp</td>
4082            <td>INT</td>
4083          </tr>
4084          <tr>
4085            <td>thread_id</td>
4086            <td>INT</td>
4087          </tr>
4088          <tr>
4089            <td>event_count</td>
4090            <td>INT</td>
4091          </tr>
4092          <tr>
4093            <td>event_type_id</td>
4094            <td>INT</td>
4095          </tr>
4096          <tr>
4097            <td>timestamp_trace</td>
4098            <td>INT</td>
4099          </tr>
4100          <tr>
4101            <td>cpu_id</td>
4102            <td>INT</td>
4103          </tr>
4104          <tr>
4105            <td>thread_state</td>
4106            <td>TEXT</td>
4107          </tr>
4108        </tbody>
4109      </table>
4110      <h4>表描述</h4>
4111      <p class="fontColor">记录Hiperf工具的采样信息。</p>
4112      <h4>主要字段描述</h4>
4113      <ul class="fontColor">
4114        <li>timestamp:未进行时钟源同步的时间戳</li>
4115        <li>thread_id:线程号</li>
4116        <li>event_count:采样统计</li>
4117        <li>event_type_id:事件类型编号。与PerfReport表的id字段相关联</li>
4118        <li>timestamp_trace:时钟源同步后的时间戳</li>
4119        <li>cpu_id:cpu核编号</li>
4120        <li>
4121          thread_state:线程状态。采样对应Sched_Waking事件时,为Runing;对应Sched_Switch事件时,为Suspend。其余事件类型,为“-”
4122        </li>
4123      </ul>
4124      <h3>perf_thread表</h3>
4125      <h4>表结构</h4>
4126      <table class="fontColor">
4127        <thead>
4128          <tr>
4129            <th class="fontColor">Columns Name</th>
4130            <th class="fontColor">SQL TYPE</th>
4131          </tr>
4132        </thead>
4133        <tbody>
4134          <tr>
4135            <td>id</td>
4136            <td>INT</td>
4137          </tr>
4138          <tr>
4139            <td>thread_id</td>
4140            <td>INT</td>
4141          </tr>
4142          <tr>
4143            <td>process_id</td>
4144            <td>INT</td>
4145          </tr>
4146          <tr>
4147            <td>thread_name</td>
4148            <td>TEXT</td>
4149          </tr>
4150        </tbody>
4151      </table>
4152      <h4>表描述</h4>
4153      <p class="fontColor">记录Hiperf工具采集到的进程和线程数据。</p>
4154      <h4>主要字段描述</h4>
4155      <ul class="fontColor">
4156        <li>thread_id:线程号</li>
4157        <li>process_id:进程号</li>
4158        <li>thread_name:线程名</li>
4159      </ul>
4160      <h3>process表</h3>
4161      <h4>表结构</h4>
4162      <table class="fontColor">
4163        <thead>
4164          <tr>
4165            <th class="fontColor">Columns Name</th>
4166            <th class="fontColor">SQL TYPE</th>
4167          </tr>
4168        </thead>
4169        <tbody>
4170          <tr>
4171            <td>id</td>
4172            <td>INT</td>
4173          </tr>
4174          <tr>
4175            <td>ipid</td>
4176            <td>INT</td>
4177          </tr>
4178          <tr>
4179            <td>type</td>
4180            <td>TEXT</td>
4181          </tr>
4182          <tr>
4183            <td>pid</td>
4184            <td>INT</td>
4185          </tr>
4186          <tr>
4187            <td>name</td>
4188            <td>TEXT</td>
4189          </tr>
4190          <tr>
4191            <td>start_ts</td>
4192            <td>INT</td>
4193          </tr>
4194          <tr>
4195            <td>switch_count</td>
4196            <td>INT</td>
4197          </tr>
4198          <tr>
4199            <td>thread_count</td>
4200            <td>INT</td>
4201          </tr>
4202          <tr>
4203            <td>slice_count</td>
4204            <td>INT</td>
4205          </tr>
4206          <tr>
4207            <td>mem_count</td>
4208            <td>INT</td>
4209          </tr>
4210        </tbody>
4211      </table>
4212      <h4>表描述</h4>
4213      <p class="fontColor">记录了进程相关数据。</p>
4214      <h4>关键字段描述</h4>
4215      <ul class="fontColor">
4216        <li>id:进程在数据库重新重新定义的id,从0开始序列增长</li>
4217        <li>ipid:TS内部进程id</li>
4218        <li>type:固定取值:process</li>
4219        <li>pid:进程的真实id</li>
4220        <li>name:进程名字</li>
4221        <li>start_ts:开始时间</li>
4222        <li>switch_count:统计内部有多少个线程有切换</li>
4223        <li>thread_count:统计其线程个数</li>
4224        <li>slice_count:进程内有多个线程有slice数据</li>
4225        <li>mem_count:进程是否有内存数据</li>
4226      </ul>
4227      <h3>process_filter表</h3>
4228      <h4>表结构</h4>
4229      <table class="fontColor">
4230        <thead>
4231          <tr>
4232            <th class="fontColor">Columns Name</th>
4233            <th class="fontColor">SQL TYPE</th>
4234          </tr>
4235        </thead>
4236        <tbody>
4237          <tr>
4238            <td>id</td>
4239            <td>INT</td>
4240          </tr>
4241          <tr>
4242            <td>type</td>
4243            <td>TEXT</td>
4244          </tr>
4245          <tr>
4246            <td>name</td>
4247            <td>TEXT</td>
4248          </tr>
4249          <tr>
4250            <td>ipid</td>
4251            <td>INT</td>
4252          </tr>
4253        </tbody>
4254      </table>
4255      <h4>表描述</h4>
4256      <p class="fontColor">
4257        将进程ID作为key1,进程的内存,界面刷新,屏幕亮度等信息作为key2,唯一确定一个filter_id,
4258        filter_id同时被记录在filter表中。
4259      </p>
4260      <h4>主要字段描述</h4>
4261      <ul class="fontColor">
4262        <li>id:进程id</li>
4263        <li>type:固定取值:process_filter</li>
4264        <li>name:进程名</li>
4265        <li>ipid:该进程表中的id与process表中的id相关联</li>
4266      </ul>
4267      <h3>process_measure表</h3>
4268      <h4>表结构</h4>
4269      <table class="fontColor">
4270        <thead>
4271          <tr>
4272            <th class="fontColor">Columns Name</th>
4273            <th class="fontColor">SQL TYPE</th>
4274          </tr>
4275        </thead>
4276        <tbody>
4277          <tr>
4278            <td>type</td>
4279            <td>TEXT</td>
4280          </tr>
4281          <tr>
4282            <td>ts</td>
4283            <td>INT</td>
4284          </tr>
4285          <tr>
4286            <td>value</td>
4287            <td>NUM</td>
4288          </tr>
4289          <tr>
4290            <td>filter_id</td>
4291            <td>INT</td>
4292          </tr>
4293        </tbody>
4294      </table>
4295      <h4>表描述</h4>
4296      <p class="fontColor">保存进程的内存,堆栈值等所有计量值信息。</p>
4297      <h4>字段详细描述</h4>
4298      <ul class="fontColor">
4299        <li>ts:事件时间</li>
4300        <li>value:数值</li>
4301        <li>filter_id:对应process_measure_filter表中的ID</li>
4302      </ul>
4303      <h3>process_measure_filter表</h3>
4304      <h4>表结构</h4>
4305      <table class="fontColor">
4306        <thead>
4307          <tr>
4308            <th class="fontColor">Columns Name</th>
4309            <th class="fontColor">SQL TYPE</th>
4310          </tr>
4311        </thead>
4312        <tbody>
4313          <tr>
4314            <td>id</td>
4315            <td>INT</td>
4316          </tr>
4317          <tr>
4318            <td>type</td>
4319            <td>TEXT</td>
4320          </tr>
4321          <tr>
4322            <td>name</td>
4323            <td>TEXT</td>
4324          </tr>
4325          <tr>
4326            <td>ipid</td>
4327            <td>INT</td>
4328          </tr>
4329        </tbody>
4330      </table>
4331      <h4>表描述</h4>
4332      <p class="fontColor">
4333        将进程ID作为key1,进程的内存,界面刷新,屏幕亮度等信息作为key2,唯一确定一个filter_id,
4334        filter_id同时被记录在measure_filter表中。
4335      </p>
4336      <h4>字段详细描述</h4>
4337      <ul class="fontColor">
4338        <li>type:固定取值:process_measure_filter</li>
4339        <li>name:cpu状态名</li>
4340        <li>ipid:进程内部编号</li>
4341      </ul>
4342      <h3>raw表</h3>
4343      <h4>表结构</h4>
4344      <table class="fontColor">
4345        <thead>
4346          <tr>
4347            <th class="fontColor">Columns Name</th>
4348            <th class="fontColor">SQL TYPE</th>
4349          </tr>
4350        </thead>
4351        <tbody>
4352          <tr>
4353            <td>id</td>
4354            <td>INT</td>
4355          </tr>
4356          <tr>
4357            <td>type</td>
4358            <td>TEXT</td>
4359          </tr>
4360          <tr>
4361            <td>ts</td>
4362            <td>INT</td>
4363          </tr>
4364          <tr>
4365            <td>name</td>
4366            <td>TEXT</td>
4367          </tr>
4368          <tr>
4369            <td>cpu</td>
4370            <td>INT</td>
4371          </tr>
4372          <tr>
4373            <td>itid</td>
4374            <td>INT</td>
4375          </tr>
4376        </tbody>
4377      </table>
4378      <h4>表描述</h4>
4379      <p class="fontColor">记录了系统中的waking、wakup、cpu_idel、cpu_frequency数据。</p>
4380      <h4>相关字段描述</h4>
4381      <ul class="fontColor">
4382        <li>type:固定字段(raw)</li>
4383        <li>name:调度名称(取值:cpu_idle,sched_wakeup,sched_waking)</li>
4384        <li>cpu:事件发生在哪个CPU</li>
4385        <li>itid:时间对应哪个utid</li>
4386      </ul>
4387      <h3>sched_slice表</h3>
4388      <h4>表结构</h4>
4389      <table class="fontColor">
4390        <thead>
4391          <tr>
4392            <th class="fontColor">Columns Name</th>
4393            <th class="fontColor">SQL TYPE</th>
4394          </tr>
4395        </thead>
4396        <tbody>
4397          <tr>
4398            <td>id</td>
4399            <td>INT</td>
4400          </tr>
4401          <tr>
4402            <td>type</td>
4403            <td>TEXT</td>
4404          </tr>
4405          <tr>
4406            <td>ts</td>
4407            <td>INT</td>
4408          </tr>
4409          <tr>
4410            <td>dur</td>
4411            <td>INT</td>
4412          </tr>
4413          <tr>
4414            <td>ts_end</td>
4415            <td>INT</td>
4416          </tr>
4417          <tr>
4418            <td>cpu</td>
4419            <td>INT</td>
4420          </tr>
4421          <tr>
4422            <td>itid</td>
4423            <td>INT</td>
4424          </tr>
4425          <tr>
4426            <td>end_state</td>
4427            <td>TEXT</td>
4428          </tr>
4429          <tr>
4430            <td>priority</td>
4431            <td>INT</td>
4432          </tr>
4433        </tbody>
4434      </table>
4435      <h4>表描述</h4>
4436      <p class="fontColor">此数据结构主要作为ThreadState的上下文使用,这张表是sched_switch事件的原始记录。</p>
4437      <h4>主要字段描述</h4>
4438      <ul class="fontColor">
4439        <li>ts:事件发生事件</li>
4440        <li>type:固定字段(sched_slice)</li>
4441        <li>dur:状态持续时长</li>
4442        <li>ts_end:状态结束时长</li>
4443        <li>cpu:事件发生在哪个cpu</li>
4444        <li>itid:事件对应哪个utid</li>
4445        <li>end_state:线程的终结状态</li>
4446      </ul>
4447      <h3>smaps表</h3>
4448      <h4>表结构</h4>
4449      <table class="fontColor">
4450        <thead>
4451          <tr>
4452            <th class="fontColor">Columns Name</th>
4453            <th class="fontColor">SQL TYPE</th>
4454          </tr>
4455        </thead>
4456        <tbody>
4457          <tr>
4458            <td>id</td>
4459            <td>INT</td>
4460          </tr>
4461          <tr>
4462            <td>timestamp</td>
4463            <td>INT</td>
4464          </tr>
4465          <tr>
4466            <td>start_addr</td>
4467            <td>TEXT</td>
4468          </tr>
4469          <tr>
4470            <td>end_addr</td>
4471            <td>TEXT</td>
4472          </tr>
4473          <tr>
4474            <td>dirty</td>
4475            <td>INT</td>
4476          </tr>
4477          <tr>
4478            <td>swapper</td>
4479            <td>INT</td>
4480          </tr>
4481          <tr>
4482            <td>resident_size</td>
4483            <td>INT</td>
4484          </tr>
4485          <tr>
4486            <td>pss</td>
4487            <td>INT</td>
4488          </tr>
4489          <tr>
4490            <td>virtaul_size</td>
4491            <td>INT</td>
4492          </tr>
4493          <tr>
4494            <td>reside</td>
4495            <td>REAL</td>
4496          </tr>
4497          <tr>
4498            <td>protection_id</td>
4499            <td>INT</td>
4500          </tr>
4501          <tr>
4502            <td>path_id</td>
4503            <td>INT</td>
4504          </tr>
4505        </tbody>
4506      </table>
4507      <h4>表描述</h4>
4508      <p class="fontColor">记录进程的内存消耗的相关信息采样。</p>
4509      <h4>主要字段描述</h4>
4510      <ul class="fontColor">
4511        <li>id:状态持续时长</li>
4512        <li>timestamp:事件发生事件</li>
4513        <li>start_addr:内存段地址的起始位置</li>
4514        <li>end_addr:内存段地址的结束位置</li>
4515        <li>dirty:其他进程共享的被写的页的大小 + 已被改写的私有页面的大小</li>
4516        <li>swapper:存在于交换分区的数据大小</li>
4517        <li>resident_size:实际分配的内存大小</li>
4518        <li>pss:平摊计算后的实际物理使用内存</li>
4519        <li>virtaul_size:虚拟内存空间的大小</li>
4520        <li>reside:实际分配的内存大小与虚拟内存空间的大小的比</li>
4521        <li>protection_id:内存段的权限id与表data_dict的id字段相关联</li>
4522        <li>path_id:如果区域是从文件映射的,则这是文件的名称对应的id序号与表data_dict的id字段相关联</li>
4523      </ul>
4524      <h3>stat表</h3>
4525      <h4>表结构</h4>
4526      <table class="fontColor">
4527        <thead>
4528          <tr>
4529            <th class="fontColor">Columns Name</th>
4530            <th class="fontColor">SQL TYPE</th>
4531          </tr>
4532        </thead>
4533        <tbody>
4534          <tr>
4535            <td>event_name</td>
4536            <td>TEXT</td>
4537          </tr>
4538          <tr>
4539            <td>stat_type</td>
4540            <td>TEXT</td>
4541          </tr>
4542          <tr>
4543            <td>count</td>
4544            <td>INT</td>
4545          </tr>
4546          <tr>
4547            <td>serverity</td>
4548            <td>TEXT</td>
4549          </tr>
4550          <tr>
4551            <td>source</td>
4552            <td>TEXT</td>
4553          </tr>
4554        </tbody>
4555      </table>
4556      <h4>表描述</h4>
4557      <p class="fontColor">
4558        此结果用来统计数据解析中各类数据的数据条数,数据和合法性,数据的匹配程度(begin-end),数据的损失等,查看此结构对应的表,可对数据源有基本的了解。
4559      </p>
4560      <h4>主要字段描述</h4>
4561      <ul class="fontColor">
4562        <li>event_name:数据类型</li>
4563        <li>stat_type:数据状态</li>
4564        <li>count:数据条数</li>
4565        <li>severity:严重级别</li>
4566        <li>source:数据来源</li>
4567      </ul>
4568      <h3>symbols表</h3>
4569      <h4>表结构</h4>
4570      <table class="fontColor">
4571        <thead>
4572          <tr>
4573            <th class="fontColor">Columns Name</th>
4574            <th class="fontColor">SQL TYPE</th>
4575          </tr>
4576        </thead>
4577        <tbody>
4578          <tr>
4579            <td>id</td>
4580            <td>INT</td>
4581          </tr>
4582          <tr>
4583            <td>funcname</td>
4584            <td>TEXT</td>
4585          </tr>
4586          <tr>
4587            <td>addr</td>
4588            <td>INT</td>
4589          </tr>
4590        </tbody>
4591      </table>
4592      <h4>表描述</h4>
4593      <p class="fontColor">此表记录了被调用函数与其地址的映射关系。</p>
4594      <h4>相关字段描述</h4>
4595      <ul class="fontColor">
4596        <li>funcname:系统调用名称</li>
4597        <li>adr:系统调用地址</li>
4598      </ul>
4599      <h3>syscall表</h3>
4600      <h4>表结构</h4>
4601      <table class="fontColor">
4602        <thead>
4603          <tr>
4604            <th class="fontColor">Columns Name</th>
4605            <th class="fontColor">SQL TYPE</th>
4606          </tr>
4607        </thead>
4608        <tbody>
4609          <tr>
4610            <td>syscall_num</td>
4611            <td>INT</td>
4612          </tr>
4613          <tr>
4614            <td>type</td>
4615            <td>TEXT</td>
4616          </tr>
4617          <tr>
4618            <td>ipid</td>
4619            <td>INT</td>
4620          </tr>
4621          <tr>
4622            <td>ts</td>
4623            <td>INT</td>
4624          </tr>
4625          <tr>
4626            <td>ret</td>
4627            <td>INT</td>
4628          </tr>
4629        </tbody>
4630      </table>
4631      <h4>表描述</h4>
4632      <p class="fontColor">记录用户空间函数与内核空间函数相互调用记录。</p>
4633      <h4>相关字段描述</h4>
4634      <ul class="fontColor">
4635        <li>syscall_num:系统调用的序号</li>
4636        <li>type:固定取值:enter或者exit</li>
4637        <li>ipid:线程所属的进程ID</li>
4638        <li>ts:时间戳</li>
4639        <li>ret:返回值,在type为exit时有效</li>
4640      </ul>
4641      <h3>sys_event_filter表</h3>
4642      <h4>表结构</h4>
4643      <table class="fontColor">
4644        <thead>
4645          <tr>
4646            <th class="fontColor">Columns Name</th>
4647            <th class="fontColor">SQL TYPE</th>
4648          </tr>
4649        </thead>
4650        <tbody>
4651          <tr>
4652            <td>id</td>
4653            <td>INT</td>
4654          </tr>
4655          <tr>
4656            <td>type</td>
4657            <td>TEXT</td>
4658          </tr>
4659          <tr>
4660            <td>name</td>
4661            <td>TEXT</td>
4662          </tr>
4663        </tbody>
4664      </table>
4665      <h4>表描述</h4>
4666      <p class="fontColor">记录所有的filter。</p>
4667      <h4>相关字段描述</h4>
4668      <ul class="fontColor">
4669        <li>type:文件类型</li>
4670        <li>name:文件名</li>
4671      </ul>
4672      <h3>sys_mem_measure表</h3>
4673      <h4>表结构</h4>
4674      <table class="fontColor">
4675        <thead>
4676          <tr>
4677            <th class="fontColor">Columns Name</th>
4678            <th class="fontColor">SQL TYPE</th>
4679          </tr>
4680        </thead>
4681        <tbody>
4682          <tr>
4683            <td>type</td>
4684            <td>TEXT</td>
4685          </tr>
4686          <tr>
4687            <td>ts</td>
4688            <td>INT</td>
4689          </tr>
4690          <tr>
4691            <td>value</td>
4692            <td>INT</td>
4693          </tr>
4694          <tr>
4695            <td>filter_id</td>
4696            <td>INT</td>
4697          </tr>
4698        </tbody>
4699      </table>
4700      <h4>表描述</h4>
4701      <p class="fontColor">记录系统内存与系统虚拟内存。</p>
4702      <h4>相关字段描述</h4>
4703      <ul class="fontColor">
4704        <li>ts:事件时间</li>
4705        <li>value:数值</li>
4706        <li>filter_id:对应filter表中的ID</li>
4707      </ul>
4708      <h3>thread表</h3>
4709      <h4>表结构</h4>
4710      <table class="fontColor">
4711        <thead>
4712          <tr>
4713            <th class="fontColor">Columns Name</th>
4714            <th class="fontColor">SQL TYPE</th>
4715          </tr>
4716        </thead>
4717        <tbody>
4718          <tr>
4719            <td>id</td>
4720            <td>INT</td>
4721          </tr>
4722          <tr>
4723            <td>itid</td>
4724            <td>INT</td>
4725          </tr>
4726          <tr>
4727            <td>type</td>
4728            <td>TEXT</td>
4729          </tr>
4730          <tr>
4731            <td>tid</td>
4732            <td>INT</td>
4733          </tr>
4734          <tr>
4735            <td>name</td>
4736            <td>TEXT</td>
4737          </tr>
4738          <tr>
4739            <td>start_ts</td>
4740            <td>INT</td>
4741          </tr>
4742          <tr>
4743            <td>end_ts</td>
4744            <td>INT</td>
4745          </tr>
4746          <tr>
4747            <td>ipid</td>
4748            <td>INT</td>
4749          </tr>
4750          <tr>
4751            <td>is_main_thread</td>
4752            <td>INT</td>
4753          </tr>
4754          <tr>
4755            <td>switch_count</td>
4756            <td>INT</td>
4757          </tr>
4758        </tbody>
4759      </table>
4760      <h4>表描述</h4>
4761      <p class="fontColor">记录了线程相关数据。</p>
4762      <h4>字段详细描述</h4>
4763      <ul class="fontColor">
4764        <li>id:线程在数据库重新重新定义的id,从0开始序列增长</li>
4765        <li>itid:TS内部线程id</li>
4766        <li>type:固定字段(thread)</li>
4767        <li>tid:线程号</li>
4768        <li>name:线程名</li>
4769        <li>start_ts:开始时间</li>
4770        <li>end_ts:结束时间</li>
4771        <li>ipid:线程所属的进程id, 关联process表中的ID</li>
4772        <li>is_main_thread:是否主线程,主线程即该线程实际就是进程本身</li>
4773        <li>switch_count:当前线程的切换次数</li>
4774      </ul>
4775      <h3>thread_filter表</h3>
4776      <h4>表结构</h4>
4777      <table class="fontColor">
4778        <thead>
4779          <tr>
4780            <th class="fontColor">Columns Name</th>
4781            <th class="fontColor">SQL TYPE</th>
4782          </tr>
4783        </thead>
4784        <tbody>
4785          <tr>
4786            <td>id</td>
4787            <td>INT</td>
4788          </tr>
4789          <tr>
4790            <td>type</td>
4791            <td>TEXT</td>
4792          </tr>
4793          <tr>
4794            <td>name</td>
4795            <td>TEXT</td>
4796          </tr>
4797          <tr>
4798            <td>itid</td>
4799            <td>INT</td>
4800          </tr>
4801        </tbody>
4802      </table>
4803      <h4>表描述</h4>
4804      <p class="fontColor">
4805        将线程ID作为key1,线程的内存,界面刷新,屏幕亮度等信息作为key2,唯一确定一个filter_id,
4806        filter_id同时被记录在filter表中。
4807      </p>
4808      <h4>主要字段描述</h4>
4809      <ul class="fontColor">
4810        <li>id:线程id</li>
4811        <li>type:线程类型</li>
4812        <li>name:线程名称</li>
4813        <li>itid:该表中的tid与thread表中的tid相关联</li>
4814      </ul>
4815      <h3>thread_state表</h3>
4816      <h4>表结构</h4>
4817      <table class="fontColor">
4818        <thead>
4819          <tr>
4820            <th class="fontColor">Columns Name</th>
4821            <th class="fontColor">SQL TYPE</th>
4822          </tr>
4823        </thead>
4824        <tbody>
4825          <tr>
4826            <td>id</td>
4827            <td>INT</td>
4828          </tr>
4829          <tr>
4830            <td>type</td>
4831            <td>TEXT</td>
4832          </tr>
4833          <tr>
4834            <td>ts</td>
4835            <td>INT</td>
4836          </tr>
4837          <tr>
4838            <td>dur</td>
4839            <td>INT</td>
4840          </tr>
4841          <tr>
4842            <td>cpu</td>
4843            <td>INT</td>
4844          </tr>
4845          <tr>
4846            <td>itid</td>
4847            <td>INT</td>
4848          </tr>
4849          <tr>
4850            <td>tid</td>
4851            <td>INT</td>
4852          </tr>
4853          <tr>
4854            <td>pid</td>
4855            <td>INT</td>
4856          </tr>
4857          <tr>
4858            <td>state</td>
4859            <td>TEXT</td>
4860          </tr>
4861        </tbody>
4862      </table>
4863      <h4>表描述</h4>
4864      <p class="fontColor">记录了线程状态相关的数据。</p>
4865      <h4>字段详细描述</h4>
4866      <ul class="fontColor">
4867        <li>id:线程状态在数据库中的id,从0开始序列增长</li>
4868        <li>ts:该线程状态的起始时间</li>
4869        <li>dur:该线程状态的持续时间</li>
4870        <li>cpu:该线程在哪个cpu上执行(针对running状态的线程)</li>
4871        <li>itid:该状态所属的线程id, 关联线程表中的id</li>
4872        <li>tid:线程号</li>
4873        <li>pid:进程号</li>
4874        <li>state:线程实际的的状态值</li>
4875      </ul>
4876      <pre
4877        data-role="codeBlock"
4878        data-info=""
4879        class="fontColor light smartperf-"><code class="fontColor">'R', Runnable状态
4880"S", interruptible sleep
4881"D", uninterruptible sleep
4882"D-IO", uninterruptible io
4883"D-NIO", uninterruptible nio
4884"Runing", Runing状态
4885"T", Task stoped.
4886"t"  Traced.
4887"X", ExitedDead
4888"Z", Zombie
4889"P", Parked
4890"I", Task_Dead
4891"DK",
4892"DK-IO",
4893"DK-NIO",
4894"TK", TracedKill
4895"R+", WakeKill
4896"R+", TaskNew
4897"R-B", Task runnable binder.
4898</code></pre>
4899      <h3>clock_snapshot表</h3>
4900      <h4>表结构</h4>
4901      <table class="fontColor">
4902        <thead>
4903          <tr>
4904            <th class="fontColor">Columns Name</th>
4905            <th class="fontColor">SQL TYPE</th>
4906          </tr>
4907        </thead>
4908        <tbody>
4909          <tr>
4910            <td>clock_id</td>
4911            <td>INT</td>
4912          </tr>
4913          <tr>
4914            <td>ts</td>
4915            <td>INT</td>
4916          </tr>
4917          <tr>
4918            <td>clock_name</td>
4919            <td>TEXT</td>
4920          </tr>
4921        </tbody>
4922      </table>
4923      <h4>表描述</h4>
4924      <p class="fontColor">时钟号和时间,时钟名的映射表。</p>
4925      <h4>关键字段描述</h4>
4926      <ul class="fontColor">
4927        <li>clock_id:时钟号</li>
4928        <li>ts:时钟快照报的时间</li>
4929        <li>
4930          clock_name:时钟号对应的时钟名字<br />
4931          时钟快照是用来对齐不同时钟号的时间<br />
4932          比如,时钟号1的时间100,和时钟号2的时间200对齐<br />
4933          则时钟号为2 的250,转换为时钟号1的时间后,为150
4934        </li>
4935      </ul>
4936      <h3>datasource_clockid表</h3>
4937      <h4>表结构</h4>
4938      <table class="fontColor">
4939        <thead>
4940          <tr>
4941            <th class="fontColor">Columns Name</th>
4942            <th class="fontColor">SQL TYPE</th>
4943          </tr>
4944        </thead>
4945        <tbody>
4946          <tr>
4947            <td>data_source_name</td>
4948            <td>TEXT</td>
4949          </tr>
4950          <tr>
4951            <td>clock_id</td>
4952            <td>INT</td>
4953          </tr>
4954        </tbody>
4955      </table>
4956      <h4>表描述</h4>
4957      <p class="fontColor">数据源和时钟号的映射表。</p>
4958      <h4>关键字段描述</h4>
4959      <ul class="fontColor">
4960        <li>data_source_name:数据源的名称,和数据源的插件名保持一致</li>
4961        <li>
4962          clock_id:时钟号,对应clock_snapshot中的时钟号<br />
4963          这个表是用来告诉IDE,不同的事件源的事件,原始时钟号是多少,在数据库中保存的事件,通常是转换为boottime后的时间,但有些情况下,IDE仍然需要知道原始的时钟号是怎样的
4964        </li>
4965      </ul>
4966      <h3>frame_slice表</h3>
4967      <h3>表结构</h3>
4968      <table class="fontColor">
4969        <thead>
4970          <tr>
4971            <th class="fontColor">Columns Name</th>
4972            <th class="fontColor">SQL TYPE</th>
4973          </tr>
4974        </thead>
4975        <tbody>
4976          <tr>
4977            <td>ts</td>
4978            <td>INT</td>
4979          </tr>
4980          <tr>
4981            <td>vsync</td>
4982            <td>INT</td>
4983          </tr>
4984          <tr>
4985            <td>ipid</td>
4986            <td>INT</td>
4987          </tr>
4988          <tr>
4989            <td>itid</td>
4990            <td>INT</td>
4991          </tr>
4992          <tr>
4993            <td>callstack_id</td>
4994            <td>INT</td>
4995          </tr>
4996          <tr>
4997            <td>dur</td>
4998            <td>INT</td>
4999          </tr>
5000          <tr>
5001            <td>src</td>
5002            <td>TEXT</td>
5003          </tr>
5004          <tr>
5005            <td>dst</td>
5006            <td>INT</td>
5007          </tr>
5008          <tr>
5009            <td>type</td>
5010            <td>INT</td>
5011          </tr>
5012          <tr>
5013            <td>flag</td>
5014            <td>INT</td>
5015          </tr>
5016          <tr>
5017            <td>depth</td>
5018            <td>INT</td>
5019          </tr>
5020          <tr>
5021            <td>frame_no</td>
5022            <td>INT</td>
5023          </tr>
5024        </tbody>
5025      </table>
5026      <h4>表描述</h4>
5027      <p class="fontColor">应用的实际渲染帧和期望渲染帧的开始时间,持续时长,以及RenderService和App之间的关联关系。</p>
5028      <h4>关键字段描述</h4>
5029      <ul class="fontColor">
5030        <li>callstack_id:该帧数据对应着callstack表的调用栈所在的行数</li>
5031        <li>dur:该帧渲染时长(当数据不完整时,改行数据为空)</li>
5032        <li>src:该帧是被哪一帧(该表中对应的行数)触发的,有多个值时,用逗号分割</li>
5033        <li>dst:该帧对应的渲染帧是哪一行</li>
5034        <li>type: 0 说明该行数据是实际渲染帧, 1 说明该行数据是期望渲染帧</li>
5035        <li>
5036          flag: 空时,为不完整的数据;0 表示实际渲染帧不卡帧, 1 表示实际渲染帧卡帧(expectEndTime &lt;
5037          actualEndTime为异常), 2 表示数据不需要绘制(没有frameNum信息),3 表示rs进程与app进程起止异常(|expRsStartTime
5038          - expUiEndTime| &lt; 1ms 正常,否则异常。这里使用期待帧的时间差做判断,给实际帧打标签)
5039        </li>
5040        <li>depth:预留</li>
5041        <li>frame_no:预留</li>
5042      </ul>
5043      <h3>frame_maps表</h3>
5044      <h3>表结构</h3>
5045      <table class="fontColor">
5046        <thead>
5047          <tr>
5048            <th class="fontColor">Columns Name</th>
5049            <th class="fontColor">SQL TYPE</th>
5050          </tr>
5051        </thead>
5052        <tbody>
5053          <tr>
5054            <td>ts</td>
5055            <td>INT</td>
5056          </tr>
5057          <tr>
5058            <td>src_row</td>
5059            <td>INT</td>
5060          </tr>
5061          <tr>
5062            <td>dst_row</td>
5063            <td>INT</td>
5064          </tr>
5065        </tbody>
5066      </table>
5067      <h4>表描述</h4>
5068      <p class="fontColor">该表记录了app到RenderService的帧的映射关系,同frame_slice表中的src映射到dst的关系。</p>
5069      <h4>关键字段描述</h4>
5070      <ul class="fontColor">
5071        <li>src_row:frame_slice表中app的帧所在的行</li>
5072        <li>dst_row:frame_slice表中RenderService的帧所在的行</li>
5073      </ul>
5074      <h3>gpu_slice表</h3>
5075      <h3>表结构</h3>
5076      <table class="fontColor">
5077        <thead>
5078          <tr>
5079            <th class="fontColor">Columns Name</th>
5080            <th class="fontColor">SQL TYPE</th>
5081          </tr>
5082        </thead>
5083        <tbody>
5084          <tr>
5085            <td>frame_row</td>
5086            <td>INT</td>
5087          </tr>
5088          <tr>
5089            <td>dur</td>
5090            <td>INT</td>
5091          </tr>
5092        </tbody>
5093      </table>
5094      <h4>表描述</h4>
5095      <p class="fontColor">该表记录了每一帧数据在GPU上的渲染时长。</p>
5096      <h4>关键字段描述</h4>
5097      <ul class="fontColor">
5098        <li>frame_row:frame_slice表中渲染帧所在的行</li>
5099        <li>dur:帧渲染时长</li>
5100      </ul>
5101      <h3>trace_range表</h3>
5102      <h4>表结构</h4>
5103      <table class="fontColor">
5104        <thead>
5105          <tr>
5106            <th class="fontColor">Columns Name</th>
5107            <th class="fontColor">SQL TYPE</th>
5108          </tr>
5109        </thead>
5110        <tbody>
5111          <tr>
5112            <td>start_ts</td>
5113            <td>INT</td>
5114          </tr>
5115          <tr>
5116            <td>end_ts</td>
5117            <td>INT</td>
5118          </tr>
5119        </tbody>
5120      </table>
5121      <h4>表描述</h4>
5122      <p class="fontColor">该表记录了解析开始时间以及结束时间。</p>
5123      <h4>关键字段描述</h4>
5124      <ul class="fontColor">
5125        <li>start_ts:trace的开始时间,纳秒为单位</li>
5126        <li>end_ts:trace的结束时间,纳秒为单位</li>
5127      </ul>
5128      <h3>task_pool表</h3>
5129      <h4>表结构</h4>
5130      <table class="fontColor">
5131        <thead>
5132          <tr>
5133            <th class="fontColor">Columns Name</th>
5134            <th class="fontColor">SQL TYPE</th>
5135          </tr>
5136        </thead>
5137        <tbody>
5138          <tr>
5139            <td>id</td>
5140            <td>INT</td>
5141          </tr>
5142          <tr>
5143            <td>allocation_task_row</td>
5144            <td>INT</td>
5145          </tr>
5146          <tr>
5147            <td>execute_task_row</td>
5148            <td>INT</td>
5149          </tr>
5150          <tr>
5151            <td>return_task_row</td>
5152            <td>INT</td>
5153          </tr>
5154          <tr>
5155            <td>allocation_itid</td>
5156            <td>INT</td>
5157          </tr>
5158          <tr>
5159            <td>execute_itid</td>
5160            <td>INT</td>
5161          </tr>
5162          <tr>
5163            <td>return_itid</td>
5164            <td>INT</td>
5165          </tr>
5166          <tr>
5167            <td>execute_id</td>
5168            <td>INT</td>
5169          </tr>
5170          <tr>
5171            <td>priority</td>
5172            <td>INT</td>
5173          </tr>
5174          <tr>
5175            <td>execute_state</td>
5176            <td>INT</td>
5177          </tr>
5178          <tr>
5179            <td>return_state</td>
5180            <td>INT</td>
5181          </tr>
5182          <tr>
5183            <td>timeout_row</td>
5184            <td>INT</td>
5185          </tr>
5186        </tbody>
5187      </table>
5188      <h4>表描述</h4>
5189      <p class="fontColor">该表记录了任务池相关数据,与callstack表关联。</p>
5190      <h4>关键字段描述</h4>
5191      <ul class="fontColor">
5192        <li>allocation_task_row:与callstack表id号相关联</li>
5193        <li>execute_task_row:与callstack表id号相关联</li>
5194        <li>return_task_row:与callstack表id号相关联</li>
5195        <li>allocation_itid:任务分发的itid</li>
5196        <li>execute_itid:任务执行的itid</li>
5197        <li>return_itid:任务返回的itid</li>
5198        <li>execute_id:任务执行id</li>
5199        <li>priority:任务分发独有的,优先级{HIGH : 0,MEDIUM : 1,LOW : 2}</li>
5200        <li>execute_state:任务执行独有的执行状态{NOT_FOUND : 0,WAITING : 1,RUNNING : 2,CANCELED : 3}</li>
5201        <li>return_state:任务返回独有的任务返回状态[IsCanceled DeserializeFailed Successful Unsuccessful]</li>
5202        <li>timeout_row:任务执行超时时更新此列,将对应的 callstack 表行号存于对应的任务行</li>
5203      </ul>
5204      <h3>animation表</h3>
5205      <h4>表结构</h4>
5206      <table class="fontColor">
5207        <thead>
5208          <tr>
5209            <th class="fontColor">Columns Name</th>
5210            <th class="fontColor">SQL TYPE</th>
5211          </tr>
5212        </thead>
5213        <tbody>
5214          <tr>
5215            <td>id</td>
5216            <td>INT</td>
5217          </tr>
5218          <tr>
5219            <td>input_time</td>
5220            <td>INT</td>
5221          </tr>
5222          <tr>
5223            <td>start_point</td>
5224            <td>INT</td>
5225          </tr>
5226          <tr>
5227            <td>end_point</td>
5228            <td>INT</td>
5229          </tr>
5230        </tbody>
5231      </table>
5232      <h4>表描述</h4>
5233      <p class="fontColor">该表记录动效的响应时延和完成时延等信息。</p>
5234      <h4>关键字段描述</h4>
5235      <ul class="fontColor">
5236        <li>input_time:输入时间点</li>
5237        <li>start_point:开始时间点</li>
5238        <li>end_point:结束时间点</li>
5239      </ul>
5240      <h3>dynamic_frame表</h3>
5241      <h4>表结构</h4>
5242      <table class="fontColor">
5243        <thead>
5244          <tr>
5245            <th class="fontColor">Columns Name</th>
5246            <th class="fontColor">SQL TYPE</th>
5247          </tr>
5248        </thead>
5249        <tbody>
5250          <tr>
5251            <td>id</td>
5252            <td>INT</td>
5253          </tr>
5254          <tr>
5255            <td>x</td>
5256            <td>INT</td>
5257          </tr>
5258          <tr>
5259            <td>y</td>
5260            <td>INT</td>
5261          </tr>
5262          <tr>
5263            <td>width</td>
5264            <td>INT</td>
5265          </tr>
5266          <tr>
5267            <td>height</td>
5268            <td>INT</td>
5269          </tr>
5270          <tr>
5271            <td>alpha</td>
5272            <td>TEXT</td>
5273          </tr>
5274          <tr>
5275            <td>name</td>
5276            <td>INT</td>
5277          </tr>
5278          <tr>
5279            <td>end_time</td>
5280            <td>INT</td>
5281          </tr>
5282        </tbody>
5283      </table>
5284      <h4>表描述</h4>
5285      <p class="fontColor">该表记录动效帧的坐标、分辨率、结束时间等信息。</p>
5286      <h4>关键字段描述</h4>
5287      <ul class="fontColor">
5288        <li>x:坐标x</li>
5289        <li>y:坐标y</li>
5290        <li>width:宽</li>
5291        <li>height:高</li>
5292        <li>alpha:透明度</li>
5293        <li>name:当前动效帧名字</li>
5294        <li>end_time:结束时间</li>
5295      </ul>
5296      <h3>device_info表</h3>
5297      <h4>表结构</h4>
5298      <table class="fontColor">
5299        <thead>
5300          <tr>
5301            <th class="fontColor">Columns Name</th>
5302            <th class="fontColor">SQL TYPE</th>
5303          </tr>
5304        </thead>
5305        <tbody>
5306          <tr>
5307            <td>id</td>
5308            <td>INT</td>
5309          </tr>
5310          <tr>
5311            <td>physical_width</td>
5312            <td>INT</td>
5313          </tr>
5314          <tr>
5315            <td>physical_height</td>
5316            <td>INT</td>
5317          </tr>
5318          <tr>
5319            <td>physical_frame_rate</td>
5320            <td>INT</td>
5321          </tr>
5322        </tbody>
5323      </table>
5324      <h4>表描述</h4>
5325      <p class="fontColor">该表记录设备分辨率和帧率等信息。</p>
5326      <h4>关键字段描述</h4>
5327      <ul class="fontColor">
5328        <li>physical_width:设备宽</li>
5329        <li>physical_height:设备高</li>
5330        <li>physical_frame_rate:设备帧率</li>
5331      </ul>
5332      <h3>device_state表</h3>
5333      <h4>表结构</h4>
5334      <table class="fontColor">
5335        <thead>
5336          <tr>
5337            <th class="fontColor">Columns Name</th>
5338            <th class="fontColor">SQL TYPE</th>
5339          </tr>
5340        </thead>
5341        <tbody>
5342          <tr>
5343            <td>id</td>
5344            <td>INT</td>
5345          </tr>
5346          <tr>
5347            <td>brightness</td>
5348            <td>INT</td>
5349          </tr>
5350          <tr>
5351            <td>bt_state</td>
5352            <td>INT</td>
5353          </tr>
5354          <tr>
5355            <td>location</td>
5356            <td>INT</td>
5357          </tr>
5358          <tr>
5359            <td>wifi</td>
5360            <td>INT</td>
5361          </tr>
5362          <tr>
5363            <td>stream_default</td>
5364            <td>INT</td>
5365          </tr>
5366          <tr>
5367            <td>voice_call</td>
5368            <td>INT</td>
5369          </tr>
5370          <tr>
5371            <td>music</td>
5372            <td>INT</td>
5373          </tr>
5374          <tr>
5375            <td>stream_ring</td>
5376            <td>INT</td>
5377          </tr>
5378          <tr>
5379            <td>media</td>
5380            <td>INT</td>
5381          </tr>
5382          <tr>
5383            <td>voice_assistant</td>
5384            <td>INT</td>
5385          </tr>
5386          <tr>
5387            <td>system</td>
5388            <td>INT</td>
5389          </tr>
5390          <tr>
5391            <td>alarm</td>
5392            <td>INT</td>
5393          </tr>
5394          <tr>
5395            <td>notification</td>
5396            <td>INT</td>
5397          </tr>
5398          <tr>
5399            <td>bt_sco</td>
5400            <td>INT</td>
5401          </tr>
5402          <tr>
5403            <td>enforced_audible</td>
5404            <td>INT</td>
5405          </tr>
5406          <tr>
5407            <td>stream_dtmf</td>
5408            <td>INT</td>
5409          </tr>
5410          <tr>
5411            <td>stream_tts</td>
5412            <td>INT</td>
5413          </tr>
5414          <tr>
5415            <td>accessibility</td>
5416            <td>INT</td>
5417          </tr>
5418          <tr>
5419            <td>recording</td>
5420            <td>INT</td>
5421          </tr>
5422          <tr>
5423            <td>stream_all</td>
5424            <td>INT</td>
5425          </tr>
5426        </tbody>
5427      </table>
5428      <h4>表描述</h4>
5429      <p class="fontColor">该表记录设备屏幕亮度,蓝牙,位置,wifi,音乐,媒体等信息。</p>
5430      <h4>关键字段描述</h4>
5431      <ul class="fontColor">
5432        <li>brightness:屏幕亮度</li>
5433        <li>bt_state:蓝牙状态</li>
5434        <li>location:位置信息</li>
5435        <li>wifi:无线网络状态</li>
5436        <li>voice_call:语音通话</li>
5437        <li>music:音乐播放</li>
5438        <li>media:多媒体</li>
5439        <li>voice_assistant:语音助手</li>
5440        <li>system:系统</li>
5441        <li>alarm:闹钟</li>
5442        <li>notification:消息通知</li>
5443        <li>bt_sco:蓝牙语音</li>
5444        <li>accessibility:访问权限</li>
5445        <li>recording:录音</li>
5446      </ul>
5447      <h3>trace_config表</h3>
5448      <h4>表结构</h4>
5449      <table class="fontColor">
5450        <thead>
5451          <tr>
5452            <th class="fontColor">Columns Name</th>
5453            <th class="fontColor">SQL TYPE</th>
5454          </tr>
5455        </thead>
5456        <tbody>
5457          <tr>
5458            <td>id</td>
5459            <td>INT</td>
5460          </tr>
5461          <tr>
5462            <td>trace_source</td>
5463            <td>INT</td>
5464          </tr>
5465          <tr>
5466            <td>key</td>
5467            <td>INT</td>
5468          </tr>
5469          <tr>
5470            <td>value</td>
5471            <td>INT</td>
5472          </tr>
5473        </tbody>
5474      </table>
5475      <h4>表描述</h4>
5476      <p class="fontColor">该表记录trace数据源,proto的事件-plugin与其process_name(目前只有HisysEvent事件在用)。</p>
5477      <h4>关键字段描述</h4>
5478      <ul class="fontColor">
5479        <li>trace_source:事件源</li>
5480        <li>key:事件需要关注的信息名</li>
5481        <li>value:事件需要关注的信息名对应的信息值</li>
5482      </ul>
5483      <h3>memory_ashmem表</h3>
5484      <h4>表结构</h4>
5485      <table class="fontColor">
5486        <thead>
5487          <tr>
5488            <th class="fontColor">Columns Name</th>
5489            <th class="fontColor">SQL TYPE</th>
5490          </tr>
5491        </thead>
5492        <tbody>
5493          <tr>
5494            <td>id</td>
5495            <td>INT</td>
5496          </tr>
5497          <tr>
5498            <td>ts</td>
5499            <td>INT</td>
5500          </tr>
5501          <tr>
5502            <td>ipid</td>
5503            <td>INT</td>
5504          </tr>
5505          <tr>
5506            <td>adj</td>
5507            <td>INT</td>
5508          </tr>
5509          <tr>
5510            <td>fd</td>
5511            <td>INT</td>
5512          </tr>
5513          <tr>
5514            <td>ashmem_name_id</td>
5515            <td>INT</td>
5516          </tr>
5517          <tr>
5518            <td>size</td>
5519            <td>INT</td>
5520          </tr>
5521          <tr>
5522            <td>pss</td>
5523            <td>INT</td>
5524          </tr>
5525          <tr>
5526            <td>ashmem_id</td>
5527            <td>INT</td>
5528          </tr>
5529          <tr>
5530            <td>time</td>
5531            <td>INT</td>
5532          </tr>
5533          <tr>
5534            <td>ref_count</td>
5535            <td>INT</td>
5536          </tr>
5537          <tr>
5538            <td>purged</td>
5539            <td>INT</td>
5540          </tr>
5541          <tr>
5542            <td>flag</td>
5543            <td>INT</td>
5544          </tr>
5545        </tbody>
5546      </table>
5547      <h4>表描述</h4>
5548      <p class="fontColor">该表记录trace数据源,proto的事件-plugin与其process_name(目前只有HisysEvent事件在用)。</p>
5549      <h4>关键字段描述</h4>
5550      <ul class="fontColor">
5551        <li>ts:时间戳</li>
5552        <li>ipid:内部进程号</li>
5553        <li>fd:共享内存文件描述符</li>
5554        <li>ashmem_name_id:共享内存名</li>
5555        <li>size:共享内存大小</li>
5556        <li>pss:PSS内存大小</li>
5557        <li>ashmem_id:共享内存ID</li>
5558        <li>ref_count:引用计数</li>
5559        <li>flag:去重标记,0表示正常,1表示进程内部重复数据,2表示进程间重复数据</li>
5560      </ul>
5561      <h3>memory_dma表</h3>
5562      <h4>表结构</h4>
5563      <table class="fontColor">
5564        <thead>
5565          <tr>
5566            <th class="fontColor">Columns Name</th>
5567            <th class="fontColor">SQL TYPE</th>
5568          </tr>
5569        </thead>
5570        <tbody>
5571          <tr>
5572            <td>id</td>
5573            <td>INT</td>
5574          </tr>
5575          <tr>
5576            <td>ts</td>
5577            <td>INT</td>
5578          </tr>
5579          <tr>
5580            <td>ipid</td>
5581            <td>INT</td>
5582          </tr>
5583          <tr>
5584            <td>fd</td>
5585            <td>INT</td>
5586          </tr>
5587          <tr>
5588            <td>size</td>
5589            <td>INT</td>
5590          </tr>
5591          <tr>
5592            <td>ino</td>
5593            <td>INT</td>
5594          </tr>
5595          <tr>
5596            <td>exp_pid</td>
5597            <td>INT</td>
5598          </tr>
5599          <tr>
5600            <td>exp_task_comm_id</td>
5601            <td>INT</td>
5602          </tr>
5603          <tr>
5604            <td>buf_name_id</td>
5605            <td>INT</td>
5606          </tr>
5607          <tr>
5608            <td>exp_name_id</td>
5609            <td>INT</td>
5610          </tr>
5611          <tr>
5612            <td>flag</td>
5613            <td>INT</td>
5614          </tr>
5615        </tbody>
5616      </table>
5617      <h4>表描述</h4>
5618      <p class="fontColor">该表记录trace数据源,proto的事件-plugin与其process_name(目前只有HisysEvent事件在用)。</p>
5619      <h4>关键字段描述</h4>
5620      <ul class="fontColor">
5621        <li>ts:时间戳</li>
5622        <li>ipid:内部进程号</li>
5623        <li>fd:dma内存文件描述符</li>
5624        <li>size:dma内存大小</li>
5625        <li>exp_pid:申请者的进程号</li>
5626        <li>buf_name_id:dma内存名</li>
5627        <li>exp_name_id:申请者进程名</li>
5628        <li>flag:去重标记,0表示正常,1表示进程内部重复数据,2表示进程间重复数据</li>
5629      </ul>
5630      <h3>memory_process_gpu表</h3>
5631      <h4>表结构</h4>
5632      <table class="fontColor">
5633        <thead>
5634          <tr>
5635            <th class="fontColor">Columns Name</th>
5636            <th class="fontColor">SQL TYPE</th>
5637          </tr>
5638        </thead>
5639        <tbody>
5640          <tr>
5641            <td>id</td>
5642            <td>INT</td>
5643          </tr>
5644          <tr>
5645            <td>ts</td>
5646            <td>INT</td>
5647          </tr>
5648          <tr>
5649            <td>gpu_name_id</td>
5650            <td>INT</td>
5651          </tr>
5652          <tr>
5653            <td>all_gpu_size</td>
5654            <td>INT</td>
5655          </tr>
5656          <tr>
5657            <td>addr</td>
5658            <td>TEXT</td>
5659          </tr>
5660          <tr>
5661            <td>ipid</td>
5662            <td>INT</td>
5663          </tr>
5664          <tr>
5665            <td>itid</td>
5666            <td>INT</td>
5667          </tr>
5668          <tr>
5669            <td>used_gpu_size</td>
5670            <td>INT</td>
5671          </tr>
5672        </tbody>
5673      </table>
5674      <h4>表描述</h4>
5675      <p class="fontColor">该表记录trace数据源,proto的事件-plugin与其process_name(目前只有HisysEvent事件在用)。</p>
5676      <h4>关键字段描述</h4>
5677      <ul class="fontColor">
5678        <li>ts:时间戳</li>
5679        <li>gpu_name_id:gpu内存名称</li>
5680        <li>all_gpu_size:进程占用gpu总大小</li>
5681        <li>addr:gpu内存地址</li>
5682        <li>ipid:内部进程号</li>
5683        <li>itid:内部线程号</li>
5684        <li>used_gpu_size:已使用的gpu大小</li>
5685      </ul>
5686      <h3>memory_window_gpu表</h3>
5687      <h4>表结构</h4>
5688      <table class="fontColor">
5689        <thead>
5690          <tr>
5691            <th class="fontColor">Columns Name</th>
5692            <th class="fontColor">SQL TYPE</th>
5693          </tr>
5694        </thead>
5695        <tbody>
5696          <tr>
5697            <td>id</td>
5698            <td>INT</td>
5699          </tr>
5700          <tr>
5701            <td>ts</td>
5702            <td>INT</td>
5703          </tr>
5704          <tr>
5705            <td>window_name_id</td>
5706            <td>INT</td>
5707          </tr>
5708          <tr>
5709            <td>window_id</td>
5710            <td>INT</td>
5711          </tr>
5712          <tr>
5713            <td>module_name_id</td>
5714            <td>INT</td>
5715          </tr>
5716          <tr>
5717            <td>category_name_id</td>
5718            <td>INT</td>
5719          </tr>
5720          <tr>
5721            <td>size</td>
5722            <td>INT</td>
5723          </tr>
5724          <tr>
5725            <td>count</td>
5726            <td>INT</td>
5727          </tr>
5728          <tr>
5729            <td>purgeable_size</td>
5730            <td>INT</td>
5731          </tr>
5732        </tbody>
5733      </table>
5734      <h4>表描述</h4>
5735      <p class="fontColor">该表记录trace数据源,proto的事件-plugin与其process_name(目前只有HisysEvent事件在用)。</p>
5736      <h4>关键字段描述</h4>
5737      <ul class="fontColor">
5738        <li>ts:时间戳</li>
5739        <li>window_name_id:窗口名</li>
5740        <li>window_id:窗口id</li>
5741        <li>module_name_id:模块名</li>
5742        <li>category_name_id:目录名</li>
5743        <li>size:内存大小</li>
5744        <li>count:内存申请个数</li>
5745      </ul>
5746      <h3>static_initalize表</h3>
5747      <h4>表结构</h4>
5748      <table class="fontColor">
5749        <thead>
5750          <tr>
5751            <th class="fontColor">Columns Name</th>
5752            <th class="fontColor">SQL TYPE</th>
5753          </tr>
5754        </thead>
5755        <tbody>
5756          <tr>
5757            <td>id</td>
5758            <td>INT</td>
5759          </tr>
5760          <tr>
5761            <td>ipid</td>
5762            <td>INT</td>
5763          </tr>
5764          <tr>
5765            <td>tid</td>
5766            <td>INT</td>
5767          </tr>
5768          <tr>
5769            <td>call_id</td>
5770            <td>INT</td>
5771          </tr>
5772          <tr>
5773            <td>start_time</td>
5774            <td>INT</td>
5775          </tr>
5776          <tr>
5777            <td>end_time</td>
5778            <td>INT</td>
5779          </tr>
5780          <tr>
5781            <td>so_name</td>
5782            <td>TEXT</td>
5783          </tr>
5784          <tr>
5785            <td>depth</td>
5786            <td>INT</td>
5787          </tr>
5788        </tbody>
5789      </table>
5790      <h4>表描述</h4>
5791      <p class="fontColor">该表记录了so初始化相关数据。</p>
5792      <h4>关键字段描述</h4>
5793      <ul class="fontColor">
5794        <li>ipid:内部进程号</li>
5795        <li>tid:内部线程号</li>
5796        <li>call_id:调用者的ID,对应线程表里面的itid</li>
5797        <li>start_time:阶段开始时间</li>
5798        <li>end_time:阶段结束时间</li>
5799        <li>so_name:so文件名称</li>
5800        <li>depth:泳道图的深度</li>
5801      </ul>
5802    </div>
5803
5804    <script>
5805      window.onload = () => {
5806        let isDark = window.location.search;
5807        if (isDark.indexOf('?') !== -1) {
5808          isDark = isDark.substr(1, isDark.length - 1);
5809        }
5810        if (isDark === 'true') {
5811          document.getElementById('body').setAttribute('style', 'background-color:#272C34;');
5812          let header = document.getElementsByClassName('fontColor');
5813          for (let i = 0; i < header.length; i++) {
5814            header[i].style.color = '#fff';
5815          }
5816          let lightBackGround = document.getElementsByClassName('light');
5817          for (let i = 0; i < lightBackGround.length; i++) {
5818            lightBackGround[i].style.backgroundColor = '#32373F';
5819          }
5820        }
5821      };
5822    </script>
5823  </body>
5824</html>
5825