| (window.webpackJsonp=window.webpackJsonp||[]).push([[1253],{1814:function(e,s,t){"use strict";t.r(s);var r=t(69),n=Object(r.a)({},(function(){var e=this,s=e.$createElement,t=e._self._c||s;return t("ContentSlotsDistributor",{attrs:{"slot-key":e.$parent.slotKey}},[t("h1",{attrs:{id:"性能追踪工具"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#性能追踪工具"}},[e._v("#")]),e._v(" 性能追踪工具")]),e._v(" "),t("p",[e._v("IoTDB 支持使用 "),t("code",[e._v("TRACING")]),e._v(" 语句来启用/禁用对查询语句的性能追踪，默认处于禁用状态。用户可以使用性能追踪工具来分析某些查询中存在的潜在性能问题。性能分析的日志文件默认存储在 "),t("code",[e._v("./data/tracing")]),e._v(" 目录下。")]),e._v(" "),t("p",[e._v("启用 Tracing：")]),e._v(" "),t("p",[t("code",[e._v("IoTDB> TRACING ON")])]),e._v(" "),t("p",[e._v("禁用 Tracing：")]),e._v(" "),t("p",[t("code",[e._v("IoTDB> TRACING OFF")])]),e._v(" "),t("p",[e._v("由于一个 IoTDB 查询时间主要取决于查询的时间序列数、涉及访问的 Tsfile 文件数、需要扫描的 chunk 总数以及平均每个 chunk 的大小（指该 chunk 中包含的数据点的个数）。因此，目前性能分析包括的内容如下：")]),e._v(" "),t("ul",[t("li",[e._v("Start time")]),e._v(" "),t("li",[e._v("Query statement")]),e._v(" "),t("li",[e._v("Number of series paths")]),e._v(" "),t("li",[e._v("Number of tsfiles")]),e._v(" "),t("li",[e._v("Number of sequence files")]),e._v(" "),t("li",[e._v("Number of unsequence files")]),e._v(" "),t("li",[e._v("Number of chunks")]),e._v(" "),t("li",[e._v("Average size of chunks")]),e._v(" "),t("li",[e._v("End time")])]),e._v(" "),t("h2",{attrs:{id:"example"}},[t("a",{staticClass:"header-anchor",attrs:{href:"#example"}},[e._v("#")]),e._v(" Example")]),e._v(" "),t("p",[e._v("例如执行 "),t("code",[e._v("select * from root")]),e._v("，则 tracing 日志文件的内容会包括以下内容：")]),e._v(" "),t("div",{staticClass:"language- line-numbers-mode"},[t("pre",{pre:!0,attrs:{class:"language-text"}},[t("code",[e._v("Query Id: 2 - Start time: 2020-06-28 10:53:54.727\nQuery Id: 2 - Query Statement: select * from root\nQuery Id: 2 - Number of series paths: 3\nQuery Id: 2 - Number of tsfiles: 2\nQuery Id: 2 - Number of sequence files: 2\nQuery Id: 2 - Number of unsequence files: 0\nQuery Id: 2 - Number of chunks: 3\nQuery Id: 2 - Average size of chunks: 4113\nQuery Id: 2 - End time: 2020-06-28 10:54:44.059\n")])]),e._v(" "),t("div",{staticClass:"line-numbers-wrapper"},[t("span",{staticClass:"line-number"},[e._v("1")]),t("br"),t("span",{staticClass:"line-number"},[e._v("2")]),t("br"),t("span",{staticClass:"line-number"},[e._v("3")]),t("br"),t("span",{staticClass:"line-number"},[e._v("4")]),t("br"),t("span",{staticClass:"line-number"},[e._v("5")]),t("br"),t("span",{staticClass:"line-number"},[e._v("6")]),t("br"),t("span",{staticClass:"line-number"},[e._v("7")]),t("br"),t("span",{staticClass:"line-number"},[e._v("8")]),t("br"),t("span",{staticClass:"line-number"},[e._v("9")]),t("br")])]),t("p",[e._v("为了避免多个查询同时执行导致输出信息乱序，在每条输出信息前均增加了该次查询的 Query Id，用户可以使用 "),t("code",[e._v('grep "Query Id: 2" tracing.txt')]),e._v(" 来提取某次查询的所有追踪信息。")])])}),[],!1,null,null,null);s.default=n.exports}}]); |