| import{_ as a,c as n,b as t,o as s}from"./app-Bhq43HqP.js";const o={};function r(i,e){return s(),n("div",null,e[0]||(e[0]=[t(`<h1 id="performance-tracing-tool" tabindex="-1"><a class="header-anchor" href="#performance-tracing-tool"><span>Performance Tracing Tool</span></a></h1><p>IoTDB supports the use of the <code>TRACING</code> clause to enable performance tracing of executed query statements. Users can use the performance tracing tool to analyze potential performance problems in some statements.</p><p>The current performance analysis includes the following contents:</p><ol><li>The elapsed time of each stage of the execution process.</li><li>Statistics related to performance analysis, it includes the number of time series queried, the number of Tsfile files accessed, the total number of chunks to be scanned, and the average number of data points contained in the chunk, the total number of pages read, and the number of overlapped pages.</li></ol><p>For example, execute <code>tracing select * from root</code>, will display the following contents:</p><div class="language-text line-numbers-mode" data-highlighter="prismjs" data-ext="text" data-title="text"><pre><code><span class="line">Tracing Activties:</span> |
| <span class="line">+------------------------------------------------------+------------+</span> |
| <span class="line">| Activity|Elapsed Time|</span> |
| <span class="line">+------------------------------------------------------+------------+</span> |
| <span class="line">|Start to execute statement: tracing select * from root| 0|</span> |
| <span class="line">| Parse SQL to physical plan| 4|</span> |
| <span class="line">| Create and cache dataset| 16|</span> |
| <span class="line">| * Num of series paths: 3| |</span> |
| <span class="line">| * Num of sequence files read: 2| |</span> |
| <span class="line">| * Num of unsequence files read: 1| |</span> |
| <span class="line">| * Num of sequence chunks: 6, avg points: 100.0| |</span> |
| <span class="line">| * Num of unsequence chunks: 3, avg points: 100.0| |</span> |
| <span class="line">| * Num of Pages: 9, overlapped pages: 0 (0.0%)| |</span> |
| <span class="line">| Request complete| 20|</span> |
| <span class="line">+------------------------------------------------------+------------+</span> |
| <span class="line"></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div>`,6)]))}const c=a(o,[["render",r],["__file","Tracing-Tool.html.vue"]]),p=JSON.parse('{"path":"/UserGuide/V0.13.x/Query-Data/Tracing-Tool.html","title":"Performance Tracing Tool","lang":"en-US","frontmatter":{"description":"Performance Tracing Tool IoTDB supports the use of the TRACING clause to enable performance tracing of executed query statements. Users can use the performance tracing tool to a...","head":[["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/V0.13.x/Query-Data/Tracing-Tool.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/V0.13.x/Query-Data/Tracing-Tool.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"Performance Tracing Tool"}],["meta",{"property":"og:description","content":"Performance Tracing Tool IoTDB supports the use of the TRACING clause to enable performance tracing of executed query statements. Users can use the performance tracing tool to a..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2023-07-10T03:11:17.000Z"}],["meta",{"property":"article:modified_time","content":"2023-07-10T03:11:17.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"Performance Tracing Tool\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2023-07-10T03:11:17.000Z\\",\\"author\\":[]}"]]},"headers":[],"git":{"createdTime":1688958677000,"updatedTime":1688958677000,"contributors":[{"name":"CritasWang","email":"critas@outlook.com","commits":1}]},"readingTime":{"minutes":1,"words":299},"filePathRelative":"UserGuide/V0.13.x/Query-Data/Tracing-Tool.md","localizedDate":"July 10, 2023","autoDesc":true}');export{c as comp,p as data}; |
