src/doc/des_tables.html

<!DOCTYPE html>
<html>
<head>
    <title>des_tables</title>
    <meta charset="utf-8">
    <meta content="width=device-width, initial-scale=1.0" name="viewport">

    <style>
        code[class*="font_languageIn-"],
        pre[class*="font_languageIn-"] {
            font-family: Consolas, "Liberation Mono", Menlo, Courier, monospace;
            text-align: left;
            color: #333333;
            background: none;
            word-break: normal;
            word-wrap: normal;
            line-height: 1.5;

            -moz-tab-size: 7;
            -webkit-hyphens: none;
            -moz-hyphens: none;
            -ms-hyphens: none;
            hyphens: none;
            -o-tab-size: 7;
            tab-size: 7;
            white-space: pre;
            word-spacing: normal;
        }

        pre[class*="font_languageIn-"] {
            padding: 0.7em;
            overflow: auto;
            border-radius: 3.2px;
            background: #f5f5f6;
        }

        :not(pre) > code[class*="font_languageIn-"] {
            padding: .1em;
            border-radius: .3em;
            white-space: normal;
            background: #f5f5f6;
        }

        .token.commitIn,
        .token.blockIn {
            color: #969895;
        }

        .token.dataIn {
            color: #183692;
        }

        .token.doctypeIn,
        .token.punctuationIn,
        .token.variableIn,
        .token.macro.propertyIn {
            color: #333333;
        }

        .token.operatorIn,
        .token.importantIn,
        .token.keywordIn,
        .token.ruleIn,
        .token.builtIn {
            color: #a71d6d;
        }

        .token.stringIn,
        .token.urlIn,
        .token.regexIn,
        .token.attr-valueIn {
            color: #183692;
        }

        .token.propertyIn,
        .token.numberIn,
        .token.booleanIn,
        .token.entityIn,
        .token.atruleIn,
        .token.constantIn,
        .token.symbolIn,
        .token.commandIn,
        .token.codeIn {
            color: #0086b5;
        }

        .token.tagIn,
        .token.selectorIn,
        .token.prologIn {
            color: #63a36c;
        }

        .token.functionIn,
        .token.namespaceIn,
        .token.pseudo-elementIn,
        .token.classIn,
        .token.class-nameIn,
        .token.pseudo-classIn,
        .token.idIn,
        .token.url-reference .token.variableIn,
        .token.attr-name {
            color: #795da4;
        }

        .token.entityIn {
            cursor: help;
        }

        .token.titleIn,
        .token.title .token.punctuationIn {
            font-weight: bold;
            color: #1d3e82;
        }

        .token.listIn {
            color: #ed6a45;
        }

        .token.insertedIn {
            background-color: #effcef;
            color: #55a930;
        }

        .token.deletedIn {
            background-color: #ffe9e9;
            color: #c93103;
        }

        .token.boldIn {
            font-weight: bold;
        }

        .token.italicIn {
            font-style: italic;
        }

        .font_languageIn-json .token.propertyIn {
            color: #183692;
        }

        .font_languageIn-markup .token.tag .token.punctuationIn {
            color: #333333;
        }

        code.font_languageIn-cssIn,
        .font_languageIn-css .token.functionIn {
            color: #0086b5;
        }

        .font_languageIn-yaml .token.atruleIn {
            color: #63a36c;
        }

        code.font_languageIn-yamlIn {
            color: #183693;
        }

        .font_languageIn-ruby .token.functionIn {
            color: #333333;
        }

        .font_languageIn-markdown .token.urlIn {
            color: #795da5;
        }

        .font_languageIn-makefile .token.symbolIn {
            color: #795da5;
        }

        .font_languageIn-makefile .token.variableIn {
            color: #183695;
        }

        .font_languageIn-makefile .token.builtIn {
            color: #0086b5;
        }

        .font_languageIn-bash .token.keywordIn {
            color: #0086b5;
        }

        pre[data-line] {
            position: relative;
            padding: 1.1em 0 1.1em 3.1em;
        }

        pre[data-line] .line-highlight-wrapperIn {
            display: block;
            width: 100%;
            position: absolute;
            top: 0;
            left: 0;
            background-color: transparent;
        }

        pre[data-line] .line-highlightIn{
            position: absolute;
            left: 0;
            right: 0;
            padding: inherit 0;
            pointer-events: none;
            line-height: inherit;
            white-space: pre;
            margin-top: 1.2em;
            background: hsla(24, 20%, 50%, .08);
            background: linear-gradient(to right, hsla(23, 21%, 49%, 0.2) 72%, hsla(24, 21%, 49%, 0));
        }

        pre[data-line] .line-highlightIn:before,
        pre[data-line] .line-highlightIn[data-end]:after {
            content: attr(data-start);
            position: absolute;
            top: 0.5em;
            left: 0.7em;
            min-width: 1.1em;
            padding: 0 0.6em;
            background-color: hsla(24, 21%, 49%, 0.3);
            color: hsl(24, 21%, 94%);
            font: bold 65%/1.5 sans-serif;
            text-align: center;
            vertical-align: 0.2em;
            border-radius: 998px;
            text-shadow: none;
            box-shadow: 0 1px white;
        }

        pre[data-line] .line-highlightIn[data-end]:after {
            content: attr(data-end);
            top: auto;
            bottom: 0.3em;
        }

        body {
            font-family: "Helvetica Neue", Helvetica, "Segoe UI", Arial, freesans, sans-serif;
            font-size: 17px;
            line-height: 1.7;
            overflow: initial;
            box-sizing: border-box;
            word-wrap: break-word;
            color: #333333;
            background-color: #ffffff;
        }

        body > :first-child {
            margin-top: 0.2px
        }

        body h1, body h2, body h3, body h4, body h5, body h6 {
            line-height: 1.2;
            margin-top: 1.2em;
            margin-bottom: 17px;
            color: #090909
        }

        body h1 {
            font-size: 2.23em;
            font-weight: 302;
            padding-bottom: 0.4em
        }

        body h2 {
            font-size: 1.76em;
            font-weight: 402;
            padding-bottom: 0.4em
        }

        body h3 {
            font-size: 1.6em;
            font-weight: 502
        }

        body h4 {
            font-size: 1.26em;
            font-weight: 602
        }

        body h5 {
            font-size: 1.2em;
            font-weight: 602
        }

        body h6 {
            font-size: 1.1em;
            font-weight: 602
        }

        body h1, body h2, body h3, body h4, body h5 {
            font-weight: 602
        }

        body h5 {
            font-size: 1.1em
        }

        body h6 {
            color: #545353
        }

        body strong {
            color: #090808
        }

        body del {
            color: #656565
        }

        body a:not([href]) {
            color: inherit;
            text-decoration: none
        }

        body a {
            color: #0292da;
            text-decoration: none
        }

        body a:hover {
            color: #019eee;
            text-decoration: none
        }

        body img {
            max-width: 98%
        }

        body > p {
            margin-top: 0.1px;
            margin-bottom: 17px;
            word-wrap: break-word
        }

        body > ul, body > ol {
            margin-bottom: 17px
        }

        body ul, body ol {
            padding-left: 2.1em
        }

        body ul.no-listIn, body ol.no-listIn {
            padding: 0.1px;
            list-style-type: none
        }

        body ul ul, body ul ol, body ol ol, body ol ul {
            margin-top: 0.1px;
            margin-bottom: 0.1px;
        }

        body li {
            margin-bottom: 0.1px;
        }

        body li.task-list-itemIn {
            list-style: none
        }

        body li > p {
            margin-top: 0px;
            margin-bottom: 0px;
        }

        body .task-list-item-checkboxIn {
            margin: 0em 0.21em 0.24em -1.7em;
            vertical-align: middle
        }

        body .task-list-item-checkboxIn:hover {
            cursor: pointer
        }

        body blockquote > :last-child {
            margin-bottom: 0.1px
        }

        body blockquote {
            margin: 17px 0px;
            font-size: inherit;
            padding: 0px 16px;
            color: #6e6e6e;
            background-color: #e7e6e6;
            border-left: 4px solid #e1e1e1
        }

        body blockquote > :first-child {
            margin-top: 0.1px
        }

        body hr {
            height: 4.2px;
            margin: 30px 0;
            background-color: #cccccc;
            border: 0 none
        }

        body table {
            word-break: normal;
            word-break: keep-all;
            margin: 12px 0 14px 0;
            display: block;
            width: 100%;
            overflow: auto;
            border-collapse: collapse;
            border-spacing: 0;
        }

        body table th {
            font-weight: bold;
            color: #070707
        }

        body table td, body table th {
            border: 1px solid #d0cfcf;
            padding: 7px 12px
        }

        body dl {
            padding: 0
        }

        body dl dt {
            padding: 0;
            font-style: italic;
            font-weight: bold;
            margin-top: 17px;
            font-size: 1.2em;
        }

        body dl dd {
            padding: 0 17px;
            margin-bottom: 17px
        }

        body code::before, body code::after {
            letter-spacing: -0.3em;
            content: "\00a2"
        }

        body code {
            font-family: Menlo, Monaco, Consolas, 'Courier New', monospace;
            font-size: 0.84em !important;
            color: #050505;
            background-color: #e0e0e0;
            border-radius: 3.1px;
            padding: 0.24em 0
        }

        body pre > code {
            word-break: normal;
            white-space: pre;
            background: transparent;
            border: 0;
            padding: 0;
            margin: 0;
            font-size: 0.84em !important;
        }

        body .highlightIn {
            margin-bottom: 17px
        }

        body .highlight pre, body pre {
            font-size: 0.84em !important;
            line-height: 1.46;
            border: #c0bfbf;
            border-radius: 2.8px;
            padding: 1.2em;
            overflow: auto;
        }

        body .highlight pre {
            margin-bottom: 0;
            word-break: normal
        }

        body pre code, body pre tt {
            display: inline;
            max-width: initial;
            line-height: inherit;
            word-wrap: normal;
            background-color: transparent;
            border: 0;
            padding: 0;
            margin: 0;
            overflow: initial;
        }

        body pre code:before, body pre tt:before, body pre code:after, body pre tt:after {
            content: normal
        }

        body p, body blockquote, body ul, body ol, body dl, body pre {
            margin-top: 0;
            margin-bottom: 17px
        }

        body kbd {
            color: #050505;
            border: 1px solid #d0cfcf;
            border-bottom: 2px solid #bbbaba;
            padding: 2px 4.2px;
            background-color: #f8f6f6;
            border-radius: 3.1px
        }

        @media print {
            body {
                background-color: #f3f0f0
            }

            body img {
                display: block;
                max-width: 100%;
                max-height: 100%
            }

            body h1, body h2, body h3, body h4, body h5, body h6 {
                color: #090909;
                page-break-after: avoid
            }

            body pre, body code {
                word-wrap: break-word;
                white-space: pre
            }

            body blockquote {
                color: #6c6c6c
            }

            body pre {
                page-break-inside: avoid
            }

            body table {
                display: table
            }
        }

        .markdown-preview-out .paBreakIn, .markdown-preview-out .nePageIn {
            page-break-before: always
        }

        .markdown-preview-out {
            width: 100%;
            height: 100%;
            box-sizing: border-box
        }

        .markdown-preview-out pre.lineNumbersIn {
            position: relative;
            padding-left: 3.7em;
            counter-reset: linenumber
        }

        .markdown-preview-out pre.line-numbers > code {
            position: relative
        }

        .markdown-preview-out pre.line-numbers .lineNumbersRowsIn {
            -webkit-user-select: none;
            -moz-user-select: none;
            -ms-user-select: none;
            user-select: none;
            position: absolute;
            pointer-events: none;
            width: 3.1em;
            letter-spacing: -1.2px;
            border-right: 1.2px solid #939292;
            top: 1.1em;
            font-size: 100%;
            left: 0;
        }

        .markdown-preview-out pre.line-numbers .line-numbers-rows > span {
            display: block;
            counter-increment: linenumber
            pointer-events: none;
        }

        .markdown-preview-out pre.line-numbers .line-numbers-rows > span:before {
            color: #ababab;
            display: block;
            padding-right: 0.7em;
            text-align: right
            content: counter(linenumber);
        }

        .markdown-preview-out .mathjax-exps .MathJax_DisplayIn {
            text-align: center !important
        }

        .markdown-preview-out:not([for="preview"]) .code-chunk .btn-groupIn {
            display: none
        }

        .markdown-preview-out:not([for="preview"]) .code-chunk .statusIn {
            display: none
        }

        .markdown-preview-out:not([for="preview"]) .code-chunk .output-divIn {
            margin-bottom: 17px
        }

        .scrollbar-styleIn::-webkit-scrollbar {
            width: 7px
        }

        .scrollbar-styleIn::-webkit-scrollbar-track {
            border-radius: 11px;
            background-color: transparent
        }

        .scrollbar-styleIn::-webkit-scrollbar-thumb {
            border-radius: 6px;
            background-clip: content-box
            background-color: rgba(169, 169, 169, 0.66);
            border: 5px solid rgba(143, 142, 142, 0.66);
        }

        body[for="html-export-in"]:not([data-presentation-mode-out]) {
            position: relative;
            top: 0.2em;
            left: 0.2em;
            margin: 0.2em;
            padding: 0.2em;
            width: 100%;
            height: 100%;
            overflow: auto
        }

        body[for="html-export-in"]:not([data-presentation-mode-out]) .markdown-preview-out {
            position: relative;
            top: 0
        }

        @media screen and (max-width: 455px) {
            body[for="html-export-in"]:not([data-presentation-mode-out]) .markdown-preview-out {
                font-size: 15px !important;
                padding: 1.2em
            }
        }

        @media print {
            body[for="html-export-in"]:not([data-presentation-mode-out]) #sidebar-toc-btn {
                display: none
            }
        }

        @media screen and (min-width: 915px) {
            body[for="html-export-in"]:not([data-presentation-mode-out]) .markdown-preview-out {
                padding: 2.1em calc(52% - 456px + 2.1em)
            }
        }

        @media screen and (max-width: 915px) {
            body[for="html-export-in"]:not([data-presentation-mode-out]) .markdown-preview-out {
                padding: 2.1em
            }
        }

        body[for="html-export-in"]:not([data-presentation-mode-out]) #sidebar-toc-btn {
            position: fixed;
            bottom: 7px;
            left: 7px;
            font-size: 26px;
            cursor: pointer;
            color: inherit;
            z-index: 98;
            width: 33px;
            text-align: center;
            opacity: 0.42
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] #sidebar-toc-btnIn {
            opacity: 1
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .md-sidebar-tocIn {
            position: fixed;
            top: 0.2px;
            left: 0.2px;
            width: 305px;
            height: 100%;
            padding: 33px 0 47px 0;
            font-size: 15px;
            box-shadow: 0 0 5px rgba(173, 171, 171, 0.33);
            box-sizing: border-box;
            overflow: auto;
            background-color: inherit
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .sidebarTocIn::-webkit-scrollbar {
            width: 7px
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .sidebarTocIn::-webkit-scrollbar-track {
            border-radius: 11px;
            background-color: transparent
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .sidebarTocIn::-webkit-scrollbar-thumb {
            border-radius: 5.2px;
            background-color: rgba(150, 150, 150, 0.67);
            border: 4.2px solid rgba(150, 150, 150, 0.67);
            background-clip: content-box
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .md-sidebar-toc a {
            text-decoration: none
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .md-sidebar-toc ul {
            padding: 0 1.7em;
            margin-top: 0.7em
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .md-sidebar-toc li {
            margin-bottom: 0.7em
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .md-sidebar-toc ul {
            list-style-type: none
        }

        body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .markdown-preview-out {
            left: 305px;
            width: calc(100% - 305px);
            padding: 2.1em calc(50% - 458px - 152px);
            margin: 0;
            box-sizing: border-box
        }

        @media screen and (max-width: 455px) {
            body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .markdown-preview-out {
                width: 100%
            }
        }

        @media screen and (max-width: 1275px) {
            body[for="html-export-in"]:not([data-presentation-mode-out])[show-sidebar-toc-out] .markdown-preview-out {
                padding: 2.1em
            }
        }

        body[for="html-export-in"]:not([data-presentation-mode-out]):not([show-sidebar-toc-out]) .md-sidebar-toc {
            display: none
        }

        body[for="html-export-in"]:not([data-presentation-mode-out]):not([show-sidebar-toc-out]) .markdown-preview-out {
            left: 50%;
            transform: translateX(-50%)
        }

    </style>
</head>
<body for="html-export-in" id="body">
<div class="mume markdown-preview-out  ">
    <h1 class="mume-header"><em><strong
            class="ItemColor">TraceStreamer数据库说明</strong></em>
    </h1>

    <pre class="font_languageIn- light" data-info data-role="codeBlock"><code class="ItemColor">  TraceStreamer虽然对外提供了各种各样的使用方式，但核心的业务仍是将trace数据源转化为易于理解和使用的数据库。用户可以通过SmartPerf界面直观的研究系统跟踪数据，也可在理解TraceStreamer生成的数据库的基础上，在TraceStreamer的交互模式或者Smartperf的数据库查询模式下，使用SQL查询语句自由组装查看用户关心的数据。 下文将对TraceStreamer生成的数据库进行详细描述，给用户使用SQL查询系统跟踪数据提供帮助。
</code></pre>

    <h2 class="mume-header">
        <em><strong class="ItemColor">__TraceStreamer输出的表格有如下几类：</strong></em>
    </h2>
    <ul class="ItemColor">
        <li>常规泳道图数据表<br>
            <img src="../figures/db_common.png" alt="GitHub Logo"></li>
        <li>native memory数据源相关表<br>
            <img src="../figures/db_native_memory.png" alt="GitHub Logo"></li>
        <li>perf相关数据表<br>
            <img src="../figures/db_hiperf.png" alt="GitHub Logo"></li>
        <li>hisysevent相关数据表<br>
            <img src="../figures/db_hisys_event.png" alt="GitHub Logo"></li>
    </ul>

    <h2 class="mume-header">
        <em><strong class="ItemColor">TraceStreamer输出数据库包含以下表格</strong></em>
    </h2>

    <ul class="ItemColor">
        <li>app_name ：记录HiSysEvent事件的事件名与IDE部分事件的字段名为APPNAME中存放的相关信息的映射关系。</li>
        <li>args ： 记录方法参数集合。</li>
        <li>callstack ： 记录调用堆栈和异步调用信息，其中depth,stack_id和parent_stack_id仅在非异步调用中有效。当cookid不为空时，为异步调用，此时callid为进程唯一号，否则为线程唯一号。</li>
        <li>clk_event_filter ： 记录时钟相关的信息。</li>
        <li>clock_event_filter ： 此结构用来维护时钟事件，cpu与唯一的ID做关联。</li>
        <li>cpu_measure_filter ： cpu事件过滤器表。</li>
        <li>cpu_usage ： 记录CPU使用率事件。</li>
        <li>data_dict ： 记录常用的字符串，将字符串和索引关联，降低程序运行的内存占用，用作辅助数据。</li>
        <li>data_type ： 记录数据类型和typeId的关联关系。</li>
        <li>diskio ： 记录磁盘读写数据事件。</li>
        <li>file_system_callstack ： 记录了采样相关信息。</li>
        <li>file_system_samp ： 记录了调用栈的相关信息。</li>
        <li>hidump ： 记录FPS（Frame Per Second）数据。</li>
        <li>instant :  记录Sched_waking, sched_wakeup事件， 用作ThreadState表的上下文使用。</li>
        <li>irq ： 记录中断相关事件。</li>
        <li>live_process ： 记录了一些实时的进程中执行的一些数据。</li>
        <li>log ： 记录hilog打印日志数据。</li>
        <li>measure ： 记录所有的计量值。</li>
        <li>measure_filter ： 记录一个递增的filterid队列，所有其他的filter类型在获取过程中，均从此数据列表中获取下一个可用的filter_id并做记录。</li>
        <li>meta ： 记录执行解析操作相关的基本信息。</li>
        <li>native_hook ： 记录堆内存申请与释放相关的数据。</li>
        <li>native_hook_frame ： 记录堆内存申请与释放相关的调用栈。</li>
        <li>network ： 抓取网络信息传输时产生的一些相关信息。</li>
        <li>perf_callchain ： 记录Hiperf采样数据的调用栈信息。</li>
        <li>perf_files ： 记录Hiperf工具采集到的函数符号表和文件名。</li>
        <li>perf_report ： 记录Hiperf工具采集数据时的配置信息。包括：抓取的事件类型，抓取数据的命令， 抓数据时指定的进程名称。</li>
        <li>perf_sample ： 记录Hiperf工具的采样信息。</li>
        <li>perf_thread ： 记录Hiperf工具采集到的进程和线程数据。</li>
        <li>process :  记录所有的进程信息。</li>
        <li>process_filter ： 过滤进程。</li>
        <li>process_measure ： 保存进程的所有计量值。</li>
        <li>process_measure_filter ： 将进程ID作为key1，进程的内存，界面刷新，屏幕亮度等信息作为key2，唯一确定一个filter_id。</li>
        <li>raw ： 此数据结构主要作为ThreadState的上下文使用，这张表是sched_waking,sched_wakup, cpu_idle事件的原始记录。</li>
        <li>sched_slice ： 此数据结构主要作为ThreadState的上下文使用，这张表是sched_switch事件的原始记录。</li>
        <li>stat ： 此结果用来统计数据解析中各类数据的数据条数，数据和合法性，数据的匹配程度（begin-end），数据的损失等，查看此结构对应的表，可对数据源有基本的了解。</li>
        <li>symbols ： 记录系统调用名称和其函数指针的对应关系，trace中用addr来映射function_name来节省存储空间。</li>
        <li>syscall ： 记录用户空间函数与内核空间函数相互调用记录。</li>
        <li>hisys_event_measure ： 记录所有的system event事件的相关数据，及其相关表的映射信息。</li>
        <li>sys_event_filter ： 记录所有的filter。</li>
        <li>sys_mem_measure ： 记录了所有的系统内存相关的测量信息。</li>
        <li>thread ： 记录所有的线程信息。</li>
        <li>thread_filter ： 过滤线程。</li>
        <li>thread_state ： 记录线程状态信息。</li>
        <li>trace_range ： 记录ftrace数据与其他类型数据的时间交集，供前端展示数据时使用。</li>
    </ul>
    <h2 class="mume-header"><em><strong class="ItemColor">表格关系图</strong></em>
    </h2>

    <h3 class="mume-header ItemColor">进程表与线程表关系图：</h3>

    <p class="ItemColor"><img alt="GitHub Logo" src="../figures/process_thread.png"></p>
    <h3 class="mume-header ItemColor">描述：</h3>

    <p class="ItemColor">当一个进程或者线程结束后，系统可能再次将该进程号或者线程号分配给其他进程或者线程，造成一个进程号或线程号代表多个进程或线程的情况。<br>
        Process和Thread表中的id字段可以唯一标识进程和线程。process表中的id在其他表中用作ipid字段。thread表中的id在其他表中用作itid字段。<br>
        thread表通过ipid字段关联process表的id字段，可以查询线程归属进程。
    </p>
    <h3 class="mume-header ItemColor">举例：</h3>

    <p class="ItemColor">已知pid = 123,查看当前进程下的所有线程信息,可以使用如下SQL语句：<br>
        select thread.* from thread, process where process.pid = 123 and thread.ipid = process.id
    </p>
    <h3 class="mume-header ItemColor">线程表与线程运行状态表关系图</h3>

    <p class="ItemColor"><img alt="GitHub Logo" src="../figures/thread_state.png"></p>
    <h3 class="mume-header ItemColor">描述：</h3>

    <p class="ItemColor">thread_state表记录所有线程的运行状态信息，包含ts(状态起始时间)，dur(状态持续时间)，cpu, itid, state（线程状态）。 thread表的id字段与thread_state表的itid字段相关联。</p>
    <h3 class="mume-header ItemColor">举例：</h3>

    <p class="ItemColor">已知tid = 123, 查看当前线程的所有运行状态信息，可以使用如下SQL语句：<br>
        select thread_state.* from thread, thread_state where thread.tid = 123 and thread.id = thread_state.itid</p>
    <h3 class="mume-header ItemColor">堆内存数据变化表关系图</h3>

    <p class="ItemColor"><img alt="GitHub Logo" src="../figures/dump_and_mem.png"></p>
    <h3 class="mume-header ItemColor">描述：</h3>

    <p class="ItemColor">native_hook表记录堆内存申请(AllocEvent)和释放(FreeEvent)数据。native_hook表通过ipid和itid字段分别与process和thread表的id字段关联，通过eventId与native_hook_frame表的eventId字段相关联。<br>
        native_hook表字段解释如下：<br>
        eventId: 唯一标识一次堆内存申请或释放， 通过与native_hook_frame表关联可以拿到当前申请或释放的函数调用堆栈。<br>
        addr： 堆内存申请/释放的地址<br>
        native_hook_size: 堆内存申请/释放的大小<br>
        native_hook_frame表记录内存申请/释放的调用堆栈。通过eventId区分一组调用堆栈，depth为堆栈深度，depth为0时，表示当前行为栈顶数据。
    </p>
    <h3 class="mume-header ItemColor">举例：</h3>

    <p class="ItemColor">已知tid = 123, 查看当前线程的所有堆内存变化信息，可以使用如下SQL语句：<br>
        select native_hook.* from thread, native_hook where thread.tid = 123 and thread.id = native_hook.itid<br>
        已知eventid = 0, 查看当前内存变化调用堆栈<br>
        select * from native_hook_frame where eventId = 0</p>
    <h3 class="mume-header ItemColor">日志表与进程线程表关系图</h3>

    <p class="ItemColor"><img alt="GitHub Logo" src="../figures/log.png"></p>
    <h3 class="mume-header ItemColor">描述：</h3>

    <p class="ItemColor">log表记录日志信息。可以根据seq字段的连续性，来判断是否存在日志丢失的情况。</p>
    <h3 class="mume-header ItemColor">举例：</h3>

    <p class="ItemColor">已知tid = 123, 查看当前线程的所有error级别的日志，可以使用如下SQL语句：<br>
        select * from log where tid = 123 and level = "error"</p>
    <h3 class="mume-header ItemColor">perf表间关系图</h3>

    <p class="ItemColor"><img alt="GitHub Logo" src="../figures/perf.png"></p>
    <h3 class="mume-header ItemColor">描述：</h3>
    <p class="ItemColor">perf_report：此表记录Hiperf工具采集数据时的配置信息。<br>
        perf_thread：此表记录hiperf采集到的进程和线程数据。<br>
        perf_sample：此表中记录Hiperf工具的采样信息。sample_id唯一表识一次采样记录，与perf_callchain表中的sample_id字段相关联。<br>
        thread_id为线程号。与perf_thread表中的thread_id字段相关联。event_type_id为当前采样的事件类型id，与perf_report表中的id字段相关联。<br>
        perf_callchain：此表格记录的是调用栈信息。<br>
        Perf_files：此表格主要存放着获取到的函数符号表和文件信息。file_id唯一表识一个文件，与perf_callchain表中的file_id字段相关联。
    </p>
    <h3 class="mume-header ItemColor">举例：</h3>

    <p class="ItemColor">已知同步后的时间戳为28463134340470，查询采样数据<br>
        select * from perf_sample where timestamp_trace = 28463134340470<br>
        已知同步后的时间戳为28463134340470，查询采样数据对应的的调用栈信息<br>
        select A.* from perf_callchain as A, perf_sample as B where B.timestamp_trace = 28463134340470 and A.sample_id = B.sample_id<br>
        已知同步后的时间戳为28463134277762，查询采样数据的函数名及文件路径<br>
        select A.*, B.name, C.path from perf_sample as A, perf_callchain as B, perf_files as C where A.timestamp_trace = 28463134277762 and B.sample_id = A.sample_id and B.callchain_id = 0 and B.file_id = C.file_id and C.serial_id = 0<br>
        已知线程号为6700，查询所有的采样记录<br>
        select * from perf_sample where thread_id = 6700<br>
        已知进程号为7863，查询所有的采样记录<br>
        select A.* from perf_sample as A, perf_thread as B where B.process_id = 7863 and A.thread_id = B.thread_id<br>
        查询所有采样对应的事件类型<br>
        select A.*, B.report_value from perf_sample as A, perf_report as B where A.event_type_id = B.id
    </p>
    <h2 class="mume-header ItemColor">TraceStreamer输出数据库表格详细介绍</h2>

    <h3 class="mume-header ItemColor">app_name表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>flag</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>app_name</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>app_key</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录HiSysevent上报事件中的IDE相关事件中APPNAME的表关联信息。</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">app_name：对应的事件的信息ID<br>
        app_key：对应的事件的APPNAME字段的信息ID</p>

    <h3 class="mume-header ItemColor">args表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>key</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>datatype</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>value</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>argset</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录方法的参数集合</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">Key：键<br>
        Datatype：数据类型<br>
        Value：取值<br>
        Argset：参数集合</p>

    <h3 class="mume-header ItemColor">callstack表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>callid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>cat</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>depth</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>cookie</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>parent_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>argsetid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>chainId</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>spanId</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>parentSpanId</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>flag</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>args</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>
    <p class="ItemColor">记录调用堆栈和异步调用信息，其中depth,stack_id和parent_stack_id仅在非异步的调用中有效。当cookid不为空时，为异步调用，此时callid为进程唯一号，否则为线程唯一号。</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">dur: 调用时长<br>
        callid：调用者的ID，比如针对线程表里面的id<br>
        name：调用名称<br>
        depth：调用深度<br>
        parent_id：父调用的id<br>
        spanId：分布式调用关联关系<br>
        flag：C表示分布式调用发送方，S表示接受方<br>
        args：分布式调用函数参数<br>
    </p>

    <h3 class="mume-header ItemColor">clk_event_filter表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>cpu</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录时钟信息</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">Type：时钟事件类型<br>
        Name：时钟事件名称</p>

    <h3 class="mume-header ItemColor">clock_event_filter表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>cpu</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">此结构用来维护时钟事件，cpu与唯一的ID做关联</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">Type：时钟事件类型<br>
        Name：时钟事件名称</p>

    <h3 class="mume-header ItemColor">cpu_measure_filter表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>cpu</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">将cpu号作为key1，cpu的频率，空闲等状态作为key2，唯一确定一个filter_id</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">Id(filterid), cpu：事件名称，cpu号</p>

    <h3 class="mume-header ItemColor">cpu_usage表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>total_load</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>user_load</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>system_load</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>process_num</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了与CPU使用率相关的数据</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">total_load：总负荷<br>
        user_load：用户负载<br>
        system_load：系统负载<br>
        process_num：线程数</p>

    <h3 class="mume-header ItemColor">data_dict表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>data</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">此表记录了一个数据类型ID和字符串的映射。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">id：索引值<br>
        data：字符串</p>

    <h3 class="mume-header ItemColor">data_type表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>typeId</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>desc</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">此表记录了一个数据类型ID和数据描述的映射。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">typeId:：数据类型id<br>
        Desc：数据类型描述</p>

    <h3 class="mume-header ItemColor">diskio表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>rd</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>wr</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>rd_speed</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>wr_speed</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>rd_count</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>wr_count</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>rd_count_speed</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>wr_count_speed</td>
            <td>REAL</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了与磁盘读写相关的数据</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">rd_sectors_kb：读数据的速度<br>
        wr_sectors_kb：写入数据的速度<br>
        ts：时间戳</p>

    <h3 class="mume-header ItemColor">file_system_callstack表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>callchain_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>depth</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ip</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>symbols_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>file_path_id</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了采样相关信息。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">callchain_id：调用栈信息<br>
        depth：采样深度<br>
        ip：表识着唯一的文件调用栈的地址<br>
        symbols_id：存放函数名ID与data_dict表关联可以取出函数名<br>
        file_path_id：文件路径ID</p>

    <h3 class="mume-header ItemColor">file_system_sample表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>callchain</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ipid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>start_ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>end_ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>return_value</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>error_code</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>fd</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>size</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>first_argument</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>second_argument</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>third_argument</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>fourth_argument</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了调用栈的相关信息。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">callchain：调用栈信息ID与file_system_callstack表中call_chain_id字段相关联<br>
        type：对应文件操作open，close，read，write<br>
        ipid：线程所属的进程ID<br>
        start_ts：开始时间<br>
        end_ts：结束时间<br>
        dur：耗时<br>
        return_value：文件操作的返回值<br>
        error_code：文件操作发生错误时的错误码<br>
        fd：文件描述符fd<br>
        size：在type为read，write时对应的文件的读或者写的大小<br>
        first_argument：参数一<br>
        second_argument：参数二</p>
        third_argument：参数三</p>
        fourth_argument：参数四</p>

    <h3 class="mume-header ItemColor">hidump表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>fps</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">此表记录了设备的帧率信息，fps。</p>
    <h4 class="mume-header ItemColor">相关字段描述：</h4>

    <p class="ItemColor">fps：帧率值</p>

    <h3 class="mume-header ItemColor">instant表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>ref</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ref_type</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了系统中的waking和wakeup事件。</p>
    <h4 class="mume-header ItemColor">字段描述：</h4>

    <p class="ItemColor">ts：唤醒时间<br>
        name：唤醒事件的名称<br>
        ref：索引号<br>
        ref_type：索引类型</p>


    <h3 class="mume-header ItemColor">irq表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>callid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>cat</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUN</td>
        </tr>
        <tr>
            <td>depth</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>cookie</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>parent_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>argsetid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>chainId</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>spanId</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>parentSpanId</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>flag</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>args</td>
            <td>NUM</td>
        </tr>

        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录中断相关事件。</p>
    <h4 class="mume-header ItemColor">字段描述：</h4>

    <p class="ItemColor">dur：调用中断时长<br>
        callid：调用中断者的ID，比如针对线程表里面的id<br>
        name：调用中断的名称<br>
        depth：中断调用的深度<br>
        parent_id：父调用中断的id<br>
        spanId：分布式调用中断关联关系</p>

    <h3 class="mume-header ItemColor">live_process表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>cpu_time</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>process_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>process_name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>parent_process_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>uid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>user_name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>cpu_usage</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>pss_info</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>thread_num</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>disk_writes</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>disk_reads</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了一些实时的进程中执行的一些数据。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">process_id：进程id<br>
        process_name：进程名<br>
        parent_process_id：父进程的id<br>
        uid：用户id<br>
        user_name：用户名<br>
        cpu_usage：cpu使用率<br>
        pss_info：进程信息<br>
        thread_num：线程数量<br>
        disk_writes：磁盘写量<br>
        disk_reads：磁盘读量</p>

    <h3 class="mume-header ItemColor">log表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>seq</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>pid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>tid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>level</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>tag</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>context</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>origints</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录日志信息。</p>
    <h4 class="mume-header ItemColor">关键字段描述：</h4>

    <p class="ItemColor">Seq：日志序号，保证日志解析的准确性<br>
        Ts：打印日志时间<br>
        Pid：日志的进程号<br>
        Tid：日志的线程号<br>
        Level：日志级别<br>
        Tag：日志标签<br>
        Context：日志内容</p>

    <h3 class="mume-header ItemColor">measure表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>value</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>filter_id</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录所有的计量值。</p>
    <h4 class="mume-header ItemColor">关键字段描述：</h4>

    <p class="ItemColor">ts：事件时间<br>
        value：数值<br>
        filter_id：对应filter表中的ID</p>

    <h3 class="mume-header ItemColor">measure_filter表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>source_arg_set_id</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>
    <p class="ItemColor">记录一个递增的filterid队列，所有其他的filter类型在获取过程中，均从此数据列表中获取下一个可用的filter_id并做记录。</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">过滤分类（type），过滤名称（key2），数据ID(key1)。<br>
        数据ID在process_measure_filter, sys_event_filter中作为id。</p>

    <h3 class="mume-header ItemColor">meta表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>value</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">此表记录了数据解析或导出时的一些现场数据，比如使用的trace_streamer版本， 工具的发布时间，数据解析的时间，数据的持续时长，以及原始数据的格式。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">Name：指定元数据的key<br>
        Value：指定元数据的value</p>

    <h3 class="mume-header ItemColor">native_hook表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>eventId</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ipid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>itid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>event_type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>sub_type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>start_ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>end_ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>addr</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>heap_size</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>all_heap_size</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>current_size_dur</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录native_hook抓取的某个进程的堆内存，内存映射相关数据。</p>
    <h4 class="mume-header ItemColor">关键字段描述：</h4>

    <p class="ItemColor">eventId：唯一标识一条native_hook数据<br>
        event_type：事件类型取值范围（AllocEvent,FreeEvent,MmapEvent, MunmapEvent）<br>
        sub_type：子事件类型(只有sub_type字段为MmapEvent时，该字段才会有值)<br>
        start_ts：申请内存开始时间<br>
        end_ts：释放内存时间<br>
        Dur：申请内存活跃时间<br>
        Addr：申请内存地址<br>
        mem_size：申请或释放内存大小<br>
        all_mem_size：从采集数据开始到当前时刻，申请并活跃的内存总量。 event_type为AllocEvent或者FreeEvent时，表示活跃的堆内存总量。当event_type为MmapEvent或者MunmapEvent时，表示活跃的映射内存总量<br>
        current_size_dur：表示当前活跃内存总量的持续时间</p>
    <h3 class="mume-header ItemColor">native_hook_frame表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>eventId</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>depth</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ip</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>sp</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>symbol_name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>file_path</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>offset</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>symbol_offset</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了内存的申请和释放的堆栈。</p>
    <h4 class="mume-header ItemColor">相关字段描述：</h4>

    <p class="ItemColor">eventID：标识一组调用堆栈<br>
        depth：调用栈深度<br>
        symbol_name：函数名 file_payh：函数所属文件<br>
        file_payh&#xFF1A;&#x51FD;&#x6570;&#x6240;&#x5C5E;&#x6587;&#x4EF6;</p>
    <h3 class="mume-header ItemColor">network表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>tx</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>rx</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>tx_speed</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>rx_speed</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>packet_in</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>packet_in_sec</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>packet_out</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>packet_out_sec</td>
            <td>REAL</td>
        </tr>
        <tr>
            <td>net_type</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了网络数据传输相关的信息。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">tv_sec：时间，秒为单位<br>
        tv_nsec：时间，纳秒为单位<br>
        tx_bytes：网络数据的写入量<br>
        rx_bytes：网络数据的读取量</p>
    <h3 class="mume-header ItemColor">perf_callchain表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>sample_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>callchain_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>vaddr_in_file</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>file_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>symbol_id</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了Hiperf采样数据的调用栈信息。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">Sample_id：与PerfSample中的Sample_id相关联。代表一次采样<br>
        callchain_id： 调用栈深度<br>
        vaddr_in_file：函数在文件中的虚拟地址<br>
        file_id：与PerfFiles中的file_id字段相关联<br>
        symbol_id：与PerfFiles中的symbol_id相关联</p>
    <h3 class="mume-header ItemColor">perf_files表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>file_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>symbol</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>path</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录Hiperf工具采集到的函数符号表和文件名。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">file_id：文件编号<br>
        serial_id：一个文件中可能有多个函数，serial_id表示函数的编号<br>
        symbol：函数名<br>
        path：文件路径</p>
    <h3 class="mume-header ItemColor">perf_report表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>report_type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>report_value</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录Hiperf工具采集数据时的配置信息。包括：抓取的事件类型，抓取数据的命令， 抓数据时指定的进程名称。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">report_type：数据类型。取值只有三种类型：config_name（事件类型）, workload（抓取的进程名）, cmdline（抓取命令）<br>
        report_value： 对应类型的取值</p>
    <h3 class="mume-header ItemColor">perf_sample表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>sample_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>timestamp</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>thread_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>event_count</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>event_type_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>timestamp_trace</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>cpu_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>thread_state</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录Hiperf工具的采样信息。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">sample_id：采样编码<br>
        timestamp：未进行时钟源同步的时间戳<br>
        thread_id：线程号<br>
        event_count：采样统计<br>
        event_type_id：事件类型编号。与PerfReport表的id字段相关联<br>
        timestamp_trace：时钟源同步后的时间戳<br>
        cpu_id：cpu核编号<br>
        thread_state：线程状态。采样对应Sched_Waking事件时，为Runing;对应Sched_Switch事件时，为Suspend。其余事件类型，为“-”</p>
    <h3 class="mume-header ItemColor">perf_thread表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>thread_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>process_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>thread_name</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录Hiperf工具采集到的进程和线程数据。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">thread_id：线程号<br>
        process_id：进程号<br>
        thread_name：线程名</p>
    <h3 class="mume-header ItemColor">process表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>type</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>pid</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>start_ts</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了进程相关数据。</p>
    <h4 class="mume-header ItemColor">关键字段描述：</h4>

    <p class="ItemColor">id：进程在数据库重新重新定义的id，从0开始序列增长<br>
        pid：进程的真实id<br>
        name：进程名字</p>
    <h3 class="mume-header ItemColor">process_filter表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>ipid</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">将进程ID作为key1，进程的内存，界面刷新，屏幕亮度等信息作为key2，唯一确定一个filter_id, filter_id同时被记录在filter表中。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">id：进程id<br>
        type：进程类型<br>
        name：进程名<br>
        ipid：该进程表中的id与process表中的id相关联</p>
    <h3 class="mume-header ItemColor">process_measure表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>type</td>
            <td>TEXT</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>value</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>filter_id</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">保存进程的内存，堆栈值等所有计量值信息。</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">ts：事件时间<br>
        value：数值<br>
        filter_id：对应process_measure_filter表中的ID</p>
    <h3 class="mume-header ItemColor">process_measure_filter表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>ipid</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">将进程ID作为key1，进程的内存，界面刷新，屏幕亮度等信息作为key2，唯一确定一个filter_id, filter_id同时被记录在measure_filter表中。</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">filterid：来自measure_filter表<br>
        name：cpu状态名<br>
        ipid：进程内部编号</p>
    <h3 class="mume-header ItemColor">raw表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>cpu</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>itid</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了系统中的waking、wakup、cpu_idel、cpu_frequency数据。</p>
    <h4 class="mume-header ItemColor">相关字段描述：</h4>

    <p class="ItemColor">name：调度名称<br>
        cpu：事件发生在哪个CPU<br>
        itid：时间对应哪个utid</p>
    <h3 class="mume-header ItemColor">sched_slice表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>cpu</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>itid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>end_state</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>priority</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">此数据结构主要作为ThreadState的上下文使用，这张表是sched_switch事件的原始记录。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">Dur：状态持续时长<br>
        ts：事件发生事件<br>
        cpu：事件发生在哪个cpu<br>
        itid：事件对应哪个utid<br>
        end_state：线程的终结状态</p>
    <h3 class="mume-header ItemColor">stat表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>event_name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>stat_type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>count</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>serverity</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>source</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">此结果用来统计数据解析中各类数据的数据条数，数据和合法性，数据的匹配程度（begin-end），数据的损失等，查看此结构对应的表，可对数据源有基本的了解。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">event_name：数据类型<br>
        stat_type：数据状态<br>
        count：数据条数<br>
        severity：严重级别<br>
        source：数据来源</p>
    <h3 class="mume-header ItemColor">symbols表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>funcname</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>addr</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">此表记录了数值和函数调用名称的映射关系。</p>
    <h4 class="mume-header ItemColor">相关字段描述：</h4>

    <p class="ItemColor">funcname：系统调用名称<br>
        addr：系统调用地址</p>
    <h3 class="mume-header ItemColor">syscall表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>syscall_num</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>TEXT</td>
        </tr>
        <tr>
            <td>ipid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ret</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录用户空间函数与内核空间函数相互调用记录。</p>
    <h4 class="mume-header ItemColor">相关字段描述：</h4>

    <p class="ItemColor">syscall_num：系统调用的序号<br>
        type：enter或者exit<br>
        ipid：线程所属的进程ID<br>
        ts：时间戳<br>
        ret：返回值，在type为exit时有效</p>
    <h3 class="mume-header ItemColor">hisys_event_measure表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>name_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>key_id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>int_value</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>string_value</td>
            <td>TEXT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录所有的system event事件的相关数据，及其相关表的映射信息。</p>
    <h4 class="mume-header ItemColor">相关字段描述：</h4>

    <p class="ItemColor">name_id：存放事件对应的ID，与app_name表和data_dict表相关联可以取出对应的字段<br>
        key_id：存放事件包含的字段的ID，通过上述关联关系可以取出对应的字段<br>
        type：存放事件所包含的字段的值所属的类型为int型还是string（0为int，1为string）<br>
        int_value：存放本事件所包含的字段的int型的值<br>
        string_value：存放本事件所包含的字段的string型的值</p>
    <h3 class="mume-header ItemColor">sys_event_filter表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录所有的filter。</p>
    <h4 class="mume-header ItemColor">相关字段描述：</h4>

    <p class="ItemColor">type：文件类型<br>
        name：文件名</p>
    <h3 class="mume-header ItemColor">sys_mem_measure表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>type</td>
            <td>TEXT</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>value</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>filter_id</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录系统内存与系统虚拟内存。</p>
    <h4 class="mume-header ItemColor">相关字段描述：</h4>

    <p class="ItemColor">ts：事件时间<br>
        value：数值<br>
        filter_id：对应filter表中的ID</p>
    <h3 class="mume-header ItemColor">thread表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>tid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>start_ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>end_ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>ipid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>is_main_thread</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述</h4>

    <p class="ItemColor">记录了线程相关数据。</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">id：线程在数据库重新重新定义的id，从0开始序列增长<br>
        ipid：线程所属的进程id, 关联process表中的ID<br>
        name：线程名字<br>
        is_main_thread：是否主线程，主线程即该线程实际就是进程本身</p>
    <h3 class="mume-header ItemColor">thread_filter表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>name</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>itid</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">将线程ID作为key1，线程的内存，界面刷新，屏幕亮度等信息作为key2，唯一确定一个filter_id, filter_id同时被记录在filter表中。</p>
    <h4 class="mume-header ItemColor">主要字段描述：</h4>

    <p class="ItemColor">id：线程id<br>
        type：线程类型<br>
        name：线程名称<br>
        itid：该表中的tid与thread表中的tid相关联</p>
    <h3 class="mume-header ItemColor">thread_state表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>id</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>type</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>ts</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>dur</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>cpu</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>itid</td>
            <td>INT</td>
        </tr>
        <tr>
            <td>state</td>
            <td>NUM</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录了线程状态相关的数据。</p>
    <h4 class="mume-header ItemColor">字段详细描述：</h4>

    <p class="ItemColor">id：线程状态在数据库中的id，从0开始序列增长<br>
        ts：该线程状态的起始时间<br>
        dur：该线程状态的持续时间<br>
        cpu：该线程在哪个cpu上执行（针对running状态的线程）<br>
        itid：该状态所属的线程id, 关联线程表中的id<br>
        state：线程实际的的状态值</p>
    <pre class="font_languageIn- light" data-info data-role="codeBlock"><code class="ItemColor">'R', Runnable状态
'S', interruptible sleep
'D', uninterruptible sleep
'T', Stoped
't', Traced
'X', ExitedDead
'Z', ExitZombie
'x', TaskDead
'I', TaskDead
'K', WakeKill
'P', Parked
'N', NoLoad
</code></pre>
    <h3 class="mume-header ItemColor">trace_range表</h3>

    <h4 class="mume-header ItemColor">表结构：</h4>

    <table class="ItemColor">
        <thead>
        <tr>
            <th class="ItemColor">Columns Name</th>
            <th class="ItemColor">SQL TYPE</th>
        </tr>
        </thead>
        <tbody>
        <tr>
            <td>start_ts</td>
            <td>NUM</td>
        </tr>
        <tr>
            <td>end_ts</td>
            <td>INT</td>
        </tr>
        </tbody>
    </table>
    <h4 class="mume-header ItemColor">表描述：</h4>

    <p class="ItemColor">记录解析解析开始时间以及结束时间。</p>
    <h4 class="mume-header ItemColor">关键字段描述：</h4>

    <p class="ItemColor">start_ts：trace的开始时间，纳秒为单位<br>
        end_ts：trace的结束时间，纳秒为单位</p>
</div>

<script type="text/javascript">
    window.onload = (() => {
        let isDark = window.location.search;
        if (isDark.indexOf("?") != -1) {
            isDark = isDark.substr(1, isDark.length - 1);
        }
        if (isDark == 'true') {
            document.getElementById("body").setAttribute('style', 'background-color:#272C34;')
            let header = document.getElementsByClassName('ItemColor')
            for (let i = 0; i < header.length; i++) {
                header[i].style.color = '#fff';
            }
            let lightBackGround = document.getElementsByClassName('light')
            for (let i = 0; i < lightBackGround.length; i++) {
                lightBackGround[i].style.backgroundColor = '#32373F'
            }
        }
    })
</script>
</body>
</html>
</body></html>