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