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