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 && 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 && 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 < 5065 actualEndTime为异常), 2 表示数据不需要绘制(没有frameNum信息),3 5066 表示rs进程与app进程起止异常(|expRsStartTime - expUiEndTime| < 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>