| <!doctype html> |
| <html lang="en-US" dir="ltr" class="docs-wrapper docs-doc-page docs-version-2.0 plugin-docs plugin-id-default docs-doc-id-query/query-analysis/query-profile" data-has-hydrated="false"> |
| <head> |
| <meta charset="UTF-8"> |
| <meta name="viewport" content="width=device-width,initial-scale=1,minimum-scale=1,maximum-scale=1,user-scalable=no"> |
| <meta name="generator" content="Docusaurus v2.4.3"> |
| <link rel="alternate" type="application/rss+xml" href="/blog/rss.xml" title="Apache Doris RSS Feed"> |
| <link rel="alternate" type="application/atom+xml" href="/blog/atom.xml" title="Apache Doris Atom Feed"> |
| |
| <link rel="preconnect" href="https://www.google-analytics.com"> |
| <link rel="preconnect" href="https://www.googletagmanager.com"> |
| <script async src="https://www.googletagmanager.com/gtag/js?id=G-DT7W9E9722"></script> |
| <script>function gtag(){dataLayer.push(arguments)}window.dataLayer=window.dataLayer||[],gtag("js",new Date),gtag("config","G-DT7W9E9722",{anonymize_ip:!0})</script> |
| |
| |
| |
| <link rel="preconnect" href="https://analytics.apache.org/"> |
| <script>var _paq=window._paq=window._paq||[];_paq.push(["setRequestMethod","POST"]),_paq.push(["trackPageView"]),_paq.push(["enableLinkTracking"]),_paq.push(["enableHeartBeatTimer"]),function(){var e="https://analytics.apache.org/";_paq.push(["setRequestMethod","POST"]),_paq.push(["setTrackerUrl",e+"matomo.php"]),_paq.push(["setSiteId","43"]);var a=document,t=a.createElement("script"),p=a.getElementsByTagName("script")[0];t.type="text/javascript",t.async=!0,t.src=e+"matomo.js",p.parentNode.insertBefore(t,p)}()</script> |
| |
| |
| |
| <link rel="icon" href="/images/logo-only.png"> |
| <link rel="manifest" href="/manifest.json"> |
| <meta name="theme-color" content="#FFFFFF"> |
| <meta name="apple-mobile-web-app-capable" content="yes"> |
| <meta name="apple-mobile-web-app-status-bar-style" content="#000"> |
| <link rel="apple-touch-icon" href="/img/docusaurus.png"> |
| <link rel="mask-icon" href="/img/docusaurus.svg" color="rgb(37, 194, 160)"> |
| <meta name="msapplication-TileImage" content="/img/docusaurus.png"> |
| <meta name="msapplication-TileColor" content="#000"> |
| |
| |
| |
| <link rel="stylesheet" href="https://cdn-font.hyperos.mi.com/font/css?family=MiSans:100,200,300,400,450,500,600,650,700,900:Chinese_Simplify,Latin&display=swap"> |
| <link rel="stylesheet" href="https://cdn-font.hyperos.mi.com/font/css?family=MiSans_Latin:100,200,300,400,450,500,600,650,700,900:Latin&display=swap"> |
| <script src="/js/custom-script.js"></script><title data-rh="true">Statistics of query execution - Apache Doris</title><meta data-rh="true" name="viewport" content="width=device-width,initial-scale=1"><meta data-rh="true" name="twitter:card" content="summary_large_image"><meta data-rh="true" property="og:url" content="https://doris.apache.org/docs/2.0/query/query-analysis/query-profile"><meta data-rh="true" name="docusaurus_locale" content="en"><meta data-rh="true" name="docsearch:language" content="en"><meta data-rh="true" name="docusaurus_version" content="2.0"><meta data-rh="true" name="docusaurus_tag" content="docs-default-2.0"><meta data-rh="true" name="docsearch:version" content="2.0"><meta data-rh="true" name="docsearch:docusaurus_tag" content="docs-default-2.0"><meta data-rh="true" property="og:title" content="Statistics of query execution - Apache Doris"><meta data-rh="true" name="description" content="<!--"><meta data-rh="true" property="og:description" content="<!--"><link data-rh="true" rel="icon" href="/images/favicon.ico"><link data-rh="true" rel="canonical" href="https://doris.apache.org/docs/2.0/query/query-analysis/query-profile"><link data-rh="true" rel="alternate" href="https://doris.apache.org/docs/2.0/query/query-analysis/query-profile" hreflang="en-US"><link data-rh="true" rel="alternate" href="https://doris.apache.org/zh-CN/docs/2.0/query/query-analysis/query-profile" hreflang="zh-Hans-CN"><link data-rh="true" rel="alternate" href="https://doris.apache.org/docs/2.0/query/query-analysis/query-profile" hreflang="x-default"><link rel="stylesheet" href="https://cdnd.selectdb.com/assets/css/styles.2bd95c40.css"> |
| <link rel="preload" href="https://cdnd.selectdb.com/assets/js/runtime~main.eb208fba.js" as="script"> |
| <link rel="preload" href="https://cdnd.selectdb.com/assets/js/main.fa7fcb85.js" as="script"> |
| </head> |
| <body class="navigation-with-keyboard"> |
| <script>!function(){function t(t){document.documentElement.setAttribute("data-theme",t)}var e=function(){var t=null;try{t=new URLSearchParams(window.location.search).get("docusaurus-theme")}catch(t){}return t}()||function(){var t=null;try{t=localStorage.getItem("theme")}catch(t){}return t}();t(null!==e?e:"light")}(),document.documentElement.setAttribute("data-announcement-bar-initially-dismissed",function(){try{return"true"===localStorage.getItem("docusaurus.announcement.dismiss")}catch(t){}return!1}())</script><div id="__docusaurus"> |
| <div role="region" aria-label="Skip to main content"><a class="skipToContent_fXgn" href="#__docusaurus_skipToContent_fallback">Skip to main content</a></div><div class="announcementBar_s0pr" style="background-color:#3C2FD4;color:#FFFFFF" role="banner"><div class="announcementBarPlaceholder_qxfj"></div><div class="announcementBarContent_dpRF"><a href="https://github.com/apache/doris" target="_blank" style="display: flex; width: 100%; align-items: center; justify-content: center; margin-left: 4px; text-decoration: none; color: white">Do you ❤️ Doris? Give us a 🌟 on GitHub |
| <img style="width: 1.2rem; height: 1.2rem; margin-left: 0.4rem;" src="/images/github-white-icon.svg"> |
| </a></div><button type="button" class="clean-btn close announcementBarClose_iXyO" aria-label="Close"><svg viewBox="0 0 15 15" width="14" height="14" style="color:white"><g stroke="currentColor" stroke-width="3.1"><path d="M.75.75l13.5 13.5M14.25.75L.75 14.25"></path></g></svg></button></div><nav aria-label="Main" class="navbar navbar--fixed-top"><div class="navbar__inner" style="padding:"><div class="navbar__items"><div class="navbar-left"><div class="navbar-logo-wrapper flex items-center"><a class="navbar__brand" href="/"><div class="navbar__logo"><img src="https://cdnd.selectdb.com/images/logo.svg" alt="Apache Doris" class="themedImage_ToTc themedImage--light_HNdA"><img src="https://cdnd.selectdb.com/images/logo.svg" alt="Apache Doris" class="themedImage_ToTc themedImage--dark_i4oU"></div><b class="navbar__title text--truncate"></b></a></div><a class="navbar__item navbar__link" style="text-align:center" href="/docs/get-starting/quick-start">Docs</a><a class="navbar__item navbar__link" style="text-align:center" href="/blog">Blog</a><a class="navbar__item navbar__link" style="text-align:center" href="/users">Users</a><a href="https://github.com/apache/doris/discussions" target="_blank" rel="noopener noreferrer" class="navbar__item navbar__link" style="text-align:center">Discussions</a><a class="navbar__item navbar__link" style="text-align:center" href="/ecosystem/cluster-management">Ecosystem</a><a class="navbar__item navbar__link" style="text-align:center" href="/community/join-community">Community</a></div></div><div class="navbar__items navbar__items--right"><button aria-label="Toggle navigation bar" aria-expanded="false" class="navbar__toggle clean-btn" type="button"><svg width="30" height="30" viewBox="0 0 30 30" aria-hidden="true"><path stroke="currentColor" stroke-linecap="round" stroke-miterlimit="10" stroke-width="2" d="M4 7h22M4 15h22M4 23h22"></path></svg></button><div class="docs-search searchBox_H2mL"><div class="navbar__search searchBarContainer_PzyC"><input placeholder="Search" aria-label="Search" class="navbar__search-input navbarSearchInput_tb6T"><div class="loadingRing__K5d searchBarLoadingRing_e2f0"><div></div><div></div><div></div><div></div></div><div class="searchHintContainer_m7ml"><kbd class="searchHint_zuPL">ctrl</kbd><kbd class="searchHint_zuPL">K</kbd></div></div></div><div class="custom-navbar-item navbar__item dropdown dropdown--hoverable dropdown--right"><a href="#" aria-haspopup="true" aria-expanded="false" role="button" class="navbar__link"><svg class="icon-language" xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 16 16" fill="none"><path d="M7.75756 14.3L10.5816 6.91667H11.8759L14.7 14.3H13.4057L12.7501 12.4167H9.74113L9.06873 14.3H7.75756ZM10.1109 11.35H12.3467L11.254 8.3H11.2036L10.1109 11.35ZM2.84908 12.45L1.97498 11.5833L5.11841 8.48333C4.72618 8.05 4.38439 7.60267 4.09302 7.14133C3.80165 6.68044 3.54389 6.19444 3.31976 5.68333H4.61412C4.80463 6.06111 5.00635 6.39711 5.21927 6.69133C5.43219 6.986 5.68434 7.29444 5.97571 7.61667C6.43519 7.12778 6.81621 6.62511 7.11879 6.10867C7.42137 5.59178 7.67352 5.03889 7.87523 4.45H1V3.23333H5.33694V2H6.58087V3.23333H10.9178V4.45H9.11916C8.89503 5.18333 8.59805 5.89155 8.22824 6.57467C7.85842 7.25822 7.39895 7.90555 6.84983 8.51667L8.3459 10.0167L7.87523 11.2833L5.95891 9.38333L2.84908 12.45Z" fill="#4C576C"></path></svg></a><ul class="dropdown__menu"><li><a href="/docs/2.0/query/query-analysis/query-profile" target="_self" rel="noopener noreferrer" class="dropdown__link dropdown__link--active" style="text-align:center">English</a></li><li><a href="/zh-CN/docs/2.0/query/query-analysis/query-profile" target="_self" rel="noopener noreferrer" class="dropdown__link" style="text-align:center">中文</a></li></ul></div><div class="custom-navbar-item navbar__item dropdown dropdown--hoverable dropdown--right"><a class="navbar__link" aria-haspopup="true" aria-expanded="false" role="button" href="/docs/2.0/get-starting/what-is-apache-doris"><span class="text-sm">Versions: <!-- -->2.0</span></a><ul class="dropdown__menu"><li><a class="dropdown__link" style="text-align:center" href="/docs/dev/query/query-analysis/query-profile">Dev</a></li><li><a class="dropdown__link" style="text-align:center" href="/docs/query/query-analysis/query-profile">2.1</a></li><li><a aria-current="page" class="dropdown__link dropdown__link--active" style="text-align:center" href="/docs/2.0/query/query-analysis/query-profile">2.0</a></li><li><a class="dropdown__link" style="text-align:center" href="/docs/1.2/get-starting/">1.2</a></li></ul></div><a class="navbar__item navbar__link header-right-button-primary navbar-download-mobile" style="text-align:center" href="/download">Download</a><a href="https://github.com/apache/doris" target="_blank" rel="noopener noreferrer" class="github-btn desktop header-right-button-github"></a><a href="https://join.slack.com/t/apachedoriscommunity/shared_invite/zt-2kl08hzc0-SPJe4VWmL_qzrFd2u2XYQA" target="_blank" rel="noopener noreferrer" class="slack-btn desktop header-right-button-slack"></a><a class="header-right-button-primary navbar-download-desktop" href="/download">Download</a></div></div><div class="navbar__bottom"></div><div role="presentation" class="navbar-sidebar__backdrop"></div></nav><div id="__docusaurus_skipToContent_fallback" class="main-wrapper mainWrapper_z2l0"><div role="region" aria-label="Skip to main content"><a class="skipToContent_fXgn" href="#__docusaurus_skipToContent_fallback">Skip to main content</a></div><div class="main-wrapper docsWrapper_BCFX"><button aria-label="Scroll back to top" class="clean-btn theme-back-to-top-button backToTopButton_sjWU" type="button"></button><div class="docPage__5DB"><aside class="theme-doc-sidebar-container docSidebarContainer_b6E3"><div class="sidebarViewport_Xe31"><div class="sidebar"><nav aria-label="Docs sidebar" class="menu custom-scrollbar menu_Y1UP menuWithAnnouncementBar_fPny"><ul class="theme-doc-sidebar-menu menu__list"><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/get-starting/what-is-apache-doris">Getting Started</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/install/source-install/compilation-with-docker">Installation and Deployment</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/db-connect/database-connect">Database Connection</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/table-design/data-type">Data Table Design</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/data-operate/import/load-manual">Data Manipulation</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret menu__link--active" aria-expanded="true" href="/docs/2.0/query/query-data/mysql-compatibility">Data Queries</a></div><ul style="display:block;overflow:visible;height:auto" class="menu__list menu__list_level_2"><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/query-data/mysql-compatibility">Quering Data</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/query-variables/variables">Quering Variables</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/nereids/">Cost-Based Optimizer</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/pipeline/pipeline-execution-engine">Pipeline Execution Engine</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/query-cache/">Caches</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/view-materialized-view/create-view">View and Materialize View</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/join-optimization/doris-join-optimization">Join Queries</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/duplicate/orthogonal-bitmap-manual">Duplicating Query Results</a></div></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-2 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/2.0/query/high-concurrent-point-query">High-Concurrency Point Query</a></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret menu__link--active" aria-expanded="true" tabindex="0" href="/docs/2.0/query/query-analysis/query-profile">Analyzing Query</a></div><ul style="display:block;overflow:visible;height:auto" class="menu__list"><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link menu__link--active" aria-current="page" tabindex="0" href="/docs/2.0/query/query-analysis/query-profile">Statistics of query execution</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/2.0/query/query-analysis/">Query Analysis</a></li><li class="theme-doc-sidebar-item-link theme-doc-sidebar-item-link-level-3 menu__list-item"><a class="menu__link" tabindex="0" href="/docs/2.0/query/query-analysis/import-analysis">Import Analysis</a></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-2 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a class="menu__link menu__link_level_2 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" tabindex="0" href="/docs/2.0/query/udf/java-user-defined-function">User Defined Functions</a></div></li></ul></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/lakehouse/lakehouse-overview">Lakehouse</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/admin-manual/cluster-management/upgrade">Managing Doris</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/ecosystem/spark-doris-connector">Ecosystem</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/sql-manual/sql-functions/array-functions/array">SQL Reference</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/benchmark/ssb">Benchmark</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/faq/install-faq">FAQ</a></div></li><li class="theme-doc-sidebar-item-category theme-doc-sidebar-item-category-level-1 menu__list-item menu__list-item--collapsed"><div class="menu__list-item-collapsible"><a id="menu__group" class="menu__link menu__link_level_1 menu__link--sublist menu__link--sublist-caret" aria-expanded="false" href="/docs/2.0/releasenotes/release-2.0.11">Release notes</a></div></li></ul></nav></div></div></aside><main class="docMainContainer_gTbr"><div class="container padding-top--md padding-bottom--lg"><div class="row"><div class="col docItemCol_z5aJ"><div class="docItemContainer_c0TR"><article><nav class="theme-doc-breadcrumbs breadcrumbsContainer_Z_bl" aria-label="Breadcrumbs"><ul class="breadcrumbs" itemscope="" itemtype="https://schema.org/BreadcrumbList"><li class="breadcrumbs__item"><a aria-label="Home page" class="breadcrumbs__link" href="/"><svg viewBox="0 0 24 24" class="breadcrumbHomeIcon_YNFT"><path d="M10 19v-5h4v5c0 .55.45 1 1 1h3c.55 0 1-.45 1-1v-7h1.7c.46 0 .68-.57.33-.87L12.67 3.6c-.38-.34-.96-.34-1.34 0l-8.36 7.53c-.34.3-.13.87.33.87H5v7c0 .55.45 1 1 1h3c.55 0 1-.45 1-1z" fill="currentColor"></path></svg></a></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Data Queries</span><meta itemprop="position" content="1"></li><li class="breadcrumbs__item"><span class="breadcrumbs__link">Analyzing Query</span><meta itemprop="position" content="2"></li><li itemscope="" itemprop="itemListElement" itemtype="https://schema.org/ListItem" class="breadcrumbs__item breadcrumbs__item--active"><span class="breadcrumbs__link" itemprop="name">Statistics of query execution</span><meta itemprop="position" content="3"></li></ul></nav><div class="tocCollapsible_ETCw theme-doc-toc-mobile tocMobile_ITEo"><button type="button" class="clean-btn tocCollapsibleButton_TO0P">On this page</button></div><div class="theme-doc-markdown markdown"><header><h1>Statistics of query execution</h1></header><h1>Statistics of query execution</h1><p>This document focuses on introducing the <strong>Running Profile</strong> which recorded runtime status of Doris in query execution. Using these statistical information, we can understand the execution of fragment to become a expert of Doris's <strong>debugging and tuning</strong>.</p><p>You can also refer to following statements to view profile in command line:</p><ul><li><a href="/docs/2.0/sql-manual/sql-reference/Show-Statements/SHOW-QUERY-PROFILE">SHOW QUERY PROFILE</a></li><li><a href="/docs/2.0/sql-manual/sql-reference/Show-Statements/SHOW-LOAD-PROFILE">SHOW LOAD PROFILE</a></li></ul><h2 class="anchor anchorWithStickyNavbar_LWe7" id="noun-interpretation">Noun Interpretation<a href="#noun-interpretation" class="hash-link" aria-label="Direct link to Noun Interpretation" title="Direct link to Noun Interpretation"></a></h2><ul><li><p><strong>FE</strong>: Frontend, frontend node of Doris. Responsible for metadata management and request access.</p></li><li><p><strong>BE</strong>: Backend, backend node of Doris. Responsible for query execution and data storage.</p></li><li><p><strong>Fragment</strong>: FE will convert the execution of specific SQL statements into corresponding fragments and distribute them to BE for execution. BE will execute corresponding fragments and gather the result of RunningProfile to send back FE.</p></li></ul><h2 class="anchor anchorWithStickyNavbar_LWe7" id="basic-concepts">Basic concepts<a href="#basic-concepts" class="hash-link" aria-label="Direct link to Basic concepts" title="Direct link to Basic concepts"></a></h2><p>FE splits the query plan into fragments and distributes them to BE for task execution. BE records the statistics of <strong>Running State</strong> when executing fragment. BE print the outputs statistics of fragment execution into the log. FE can also collect these statistics recorded by each fragment and print the results on FE's web page.</p><h2 class="anchor anchorWithStickyNavbar_LWe7" id="specific-operation">Specific operation<a href="#specific-operation" class="hash-link" aria-label="Direct link to Specific operation" title="Direct link to Specific operation"></a></h2><p>Turn on the report switch on FE through MySQL command</p><div class="codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#F8F8F2;--prism-background-color:#282A36"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-text codeBlock_bY9V thin-scrollbar"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#F8F8F2"><span class="token plain">mysql> set enable_profile=true; </span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div><p>After executing the corresponding SQL statement(<code>is_report_success</code> in old versions), we can see the report information of the corresponding SQL statement on the FE web page like the picture below. |
| <img loading="lazy" alt="image.png" src="https://cdnd.selectdb.com/assets/images/running_profile-1496d45e3d65b8b860eb3f4874d711a9.png" width="2950" height="878" class="img_ev3q"></p><p>The latest <strong>100 statements</strong> executed will be listed here. We can view detailed statistics of RunningProfile.</p><div class="codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#F8F8F2;--prism-background-color:#282A36"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-text codeBlock_bY9V thin-scrollbar"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#F8F8F2"><span class="token plain">Query:</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Summary:</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Query ID: 9664061c57e84404-85ae111b8ba7e83a</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Start Time: 2020-05-02 10:34:57</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> End Time: 2020-05-02 10:35:08</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Total: 10s323ms</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Query Type: Query</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Query State: EOF</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Doris Version: trunk</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> User: root</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Default Db: default_cluster:test</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Sql Statement: select max(Bid_Price) from quotes group by Symbol</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div><p>Here is a detailed list of <code>query ID, execution time, execution statement</code> and other summary information. The next step is to print the details of each fragment collected from be.</p><div class="codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#F8F8F2;--prism-background-color:#282A36"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-text codeBlock_bY9V thin-scrollbar"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Fragment 0:</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> Instance 9664061c57e84404-85ae111b8ba7e83d (host=TNetworkAddress(hostname:192.168.0.1, port:9060)):(Active: 10s270ms, % non-child: 0.14%)</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - MemoryLimit: 2.00 GB</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - BytesReceived: 168.08 KB</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - PeakUsedReservation: 0.00 </span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - SendersBlockedTimer: 0ns</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - DeserializeRowBatchTimer: 501.975us</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - PeakMemoryUsage: 577.04 KB</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsProduced: 8.322K (8322)</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> EXCHANGE_NODE (id=4):(Active: 10s256ms, % non-child: 99.35%)</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - ConvertRowBatchTime: 180.171us</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - PeakMemoryUsage: 0.00 </span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsReturned: 8.322K (8322)</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - MemoryUsed: 0.00 </span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsReturnedRate: 811</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div><p>The fragment ID is listed here; <code>hostname</code> show the be node executing the fragment; <code>active: 10s270ms</code>show the total execution time of the node; <code>non child: 0.14%</code> means the execution time of the execution node itself (not including the execution time of child nodes) as a percentage of the total time. </p><p><code>PeakMemoryUsage</code> indicates the peak memory usage of <code>EXCHANGE_NODE</code>; <code>RowsReturned</code> indicates the number of rows returned by <code>EXCHANGE_NODE</code>; <code>RowsReturnedRate</code>=<code>RowsReturned</code>/<code>ActiveTime</code>; the meaning of these three statistics in other <code>NODE</code> the same.</p><p>Subsequently, the statistics of the child nodes will be printed in turn. <strong>here you can distinguish the parent-child relationship by intent</strong>.</p><h2 class="anchor anchorWithStickyNavbar_LWe7" id="profile-statistic-analysis">Profile statistic analysis<a href="#profile-statistic-analysis" class="hash-link" aria-label="Direct link to Profile statistic analysis" title="Direct link to Profile statistic analysis"></a></h2><p>There are many statistical information collected at BE. so we list the corresponding meanings of profile are below:</p><h4 class="anchor anchorWithStickyNavbar_LWe7" id="fragment"><code>Fragment</code><a href="#fragment" class="hash-link" aria-label="Direct link to fragment" title="Direct link to fragment"></a></h4><ul><li>AverageThreadTokens: Number of threads used to execute fragment, excluding the usage of thread pool</li><li>PeakReservation: Peak memory used by buffer pool</li><li>MemoryLimit: Memory limit at query</li><li>PeakMemoryUsage: Peak memory usage of instance</li><li>RowsProduced: Number of rows that process</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="blockmgr"><code>BlockMgr</code><a href="#blockmgr" class="hash-link" aria-label="Direct link to blockmgr" title="Direct link to blockmgr"></a></h4><ul><li>BlocksCreated: Number of Block be created by BlockMgr</li><li>BlocksRecycled: Number of Block be recycled by BlockMgr</li><li>BytesWritten: How many bytes be written to spill to disk</li><li>MaxBlockSize: Max size of one Block</li><li>TotalReadBlockTime: Total time read block from disk</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="datastreamsender"><code>DataStreamSender</code><a href="#datastreamsender" class="hash-link" aria-label="Direct link to datastreamsender" title="Direct link to datastreamsender"></a></h4><ul><li>BytesSent: Total bytes data sent</li><li>IgnoreRows: Rows filtered</li><li>LocalBytesSent: The amount bytes of local node send to it's self during Exchange</li><li>OverallThroughput: Total throughput = BytesSent / Time</li><li>SerializeBatchTime: Sending data serialization time</li><li>UncompressedRowBatchSize: Size of rowbatch before sending data compression</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="odbc_table_sink"><code>ODBC_TABLE_SINK</code><a href="#odbc_table_sink" class="hash-link" aria-label="Direct link to odbc_table_sink" title="Direct link to odbc_table_sink"></a></h4><ul><li>NumSentRows: Total number of rows written to ODBC table</li><li>TupleConvertTime: Time consuming of sending data serialization to insert statement</li><li>ResultSendTime: Time consuming of writing through ODBC driver</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="exchange_node"><code>EXCHANGE_NODE</code><a href="#exchange_node" class="hash-link" aria-label="Direct link to exchange_node" title="Direct link to exchange_node"></a></h4><ul><li>BytesReceived: Size of bytes received by network</li><li>DataArrivalWaitTime: Total waiting time of sender to push data </li><li>MergeGetNext: When there is a sort in the lower level node, exchange node will perform a unified merge sort and output an ordered result. This indicator records the total time consumption of merge sorting, including the time consumption of MergeGetNextBatch.</li><li>MergeGetNextBatch: It takes time for merge node to get data. If it is single-layer merge sort, the object to get data is network queue. For multi-level merge sorting, the data object is child merger.</li><li>ChildMergeGetNext: When there are too many senders in the lower layer to send data, single thread merge will become a performance bottleneck. Doris will start multiple child merge threads to do merge sort in parallel. The sorting time of child merge is recorded, which is the cumulative value of multiple threads.</li><li>ChildMergeGetNextBatch: It takes time for child merge to get data, If the time consumption is too large, the bottleneck may be the lower level data sending node.</li><li>FirstBatchArrivalWaitTime: The time waiting for the first batch come from sender</li><li>DeserializeRowBatchTimer: Time consuming to receive data deserialization</li><li>SendersBlockedTotalTimer(*): When the DataStreamRecv's queue buffer is full, wait time of sender</li><li>ConvertRowBatchTime: Time taken to transfer received data to RowBatch</li><li>RowsReturned: Number of receiving rows</li><li>RowsReturnedRate: Rate of rows received</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="sort_node"><code>SORT_NODE</code><a href="#sort_node" class="hash-link" aria-label="Direct link to sort_node" title="Direct link to sort_node"></a></h4><ul><li>InMemorySortTime: In memory sort time</li><li>InitialRunsCreated: Number of initialize sort run</li><li>MergeGetNext: Time cost of MergeSort from multiple sort_run to get the next batch (only show spilled disk)</li><li>MergeGetNextBatch: Time cost MergeSort one sort_run to get the next batch (only show spilled disk)</li><li>SortDataSize: Total sorted data</li><li>TotalMergesPerformed: Number of external sort merges</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="aggregation_node"><code>AGGREGATION_NODE</code><a href="#aggregation_node" class="hash-link" aria-label="Direct link to aggregation_node" title="Direct link to aggregation_node"></a></h4><ul><li>PartitionsCreated: Number of partition split by aggregate</li><li>GetResultsTime: Time to get aggregate results from each partition</li><li>HTResizeTime: Time spent in resizing hashtable</li><li>HTResize: Number of times hashtable resizes</li><li>HashBuckets: Number of buckets in hashtable</li><li>HashBucketsWithDuplicate: Number of buckets with duplicate node in hashtable</li><li>HashCollisions: Number of hash conflicts generated </li><li>HashDuplicateNodes: Number of duplicate nodes with the same buckets in hashtable</li><li>HashFailedProbe: Number of failed probe operations</li><li>HashFilledBuckets: Number of buckets filled data</li><li>HashProbe: Number of hashtable probe</li><li>HashTravelLength: The number of steps moved when hashtable queries</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="hash_join_node"><code>HASH_JOIN_NODE</code><a href="#hash_join_node" class="hash-link" aria-label="Direct link to hash_join_node" title="Direct link to hash_join_node"></a></h4><ul><li>ExecOption: The way to construct a HashTable for the right child (synchronous or asynchronous), the right child in Join may be a table or a subquery, the same is true for the left child</li><li>BuildBuckets: The number of Buckets in HashTable</li><li>BuildRows: the number of rows of HashTable</li><li>BuildTime: Time-consuming to construct HashTable</li><li>LoadFactor: Load factor of HashTable (ie the number of non-empty buckets)</li><li>ProbeRows: Traverse the number of rows of the left child for Hash Probe</li><li>ProbeTime: Time consuming to traverse the left child for Hash Probe, excluding the time consuming to call GetNext on the left child RowBatch</li><li>PushDownComputeTime: The calculation time of the predicate pushdown condition</li><li>PushDownTime: The total time consumed by the predicate push down. When Join, the right child who meets the requirements is converted to the left child's in query</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="cross_join_node"><code>CROSS_JOIN_NODE</code><a href="#cross_join_node" class="hash-link" aria-label="Direct link to cross_join_node" title="Direct link to cross_join_node"></a></h4><ul><li>ExecOption: The way to construct RowBatchList for the right child (synchronous or asynchronous)</li><li>BuildRows: The number of rows of RowBatchList (ie the number of rows of the right child)</li><li>BuildTime: Time-consuming to construct RowBatchList</li><li>LeftChildRows: the number of rows of the left child</li><li>LeftChildTime: The time it takes to traverse the left child and find the Cartesian product with the right child, not including the time it takes to call GetNext on the left child RowBatch</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="union_node"><code>UNION_NODE</code><a href="#union_node" class="hash-link" aria-label="Direct link to union_node" title="Direct link to union_node"></a></h4><ul><li>MaterializeExprsEvaluateTime: When the field types at both ends of the Union are inconsistent, the time spent to evaluates type conversion exprs and materializes the results </li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="analytic_eval_node"><code>ANALYTIC_EVAL_NODE</code><a href="#analytic_eval_node" class="hash-link" aria-label="Direct link to analytic_eval_node" title="Direct link to analytic_eval_node"></a></h4><ul><li>EvaluationTime: Analysis function (window function) calculation total time</li><li>GetNewBlockTime: It takes time to apply for a new block during initialization. Block saves the cache line window or the entire partition for analysis function calculation</li><li>PinTime: the time it takes to apply for a new block later or reread the block written to the disk back to the memory</li><li>UnpinTime: the time it takes to flush the data of the block to the disk when the memory pressure of the block that is not in use or the current operator is high</li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="olap_scan_node"><code>OLAP_SCAN_NODE</code><a href="#olap_scan_node" class="hash-link" aria-label="Direct link to olap_scan_node" title="Direct link to olap_scan_node"></a></h4><p>The <code>OLAP_SCAN_NODE</code> is responsible for specific data scanning tasks. One <code>OLAP_SCAN_NODE</code> will generate one or more <code>OlapScanner</code>. Each Scanner thread is responsible for scanning part of the data.</p><p>Some or all of the predicate conditions in the query will be pushed to <code>OLAP_SCAN_NODE</code>. Some of these predicate conditions will continue to be pushed down to the storage engine in order to use the storage engine's index for data filtering. The other part will be kept in <code>OLAP_SCAN_NODE</code> to filter the data returned from the storage engine.</p><p>The profile of the <code>OLAP_SCAN_NODE</code> node is usually used to analyze the efficiency of data scanning. It is divided into three layers: <code>OLAP_SCAN_NODE</code>, <code>OlapScanner</code>, and <code>SegmentIterator</code> according to the calling relationship.</p><p>The profile of a typical <code>OLAP_SCAN_NODE</code> is as follows. Some indicators will have different meanings depending on the storage format (V1 or V2).</p><div class="codeBlockContainer_Ckt0 theme-code-block" style="--prism-color:#F8F8F2;--prism-background-color:#282A36"><div class="codeBlockContent_biex"><pre tabindex="0" class="prism-code language-text codeBlock_bY9V thin-scrollbar"><code class="codeBlockLines_e6Vv"><span class="token-line" style="color:#F8F8F2"><span class="token plain">OLAP_SCAN_NODE (id=0):(Active: 1.2ms,% non-child: 0.00%)</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - BytesRead: 265.00 B # The amount of data read from the data file. Assuming that 10 32-bit integers are read, the amount of data is 10 * 4B = 40 Bytes. This data only represents the fully expanded size of the data in memory, and does not represent the actual IO size.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - NumDiskAccess: 1 # The number of disks involved in this ScanNode node.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - NumScanners: 20 # The number of Scanners generated by this ScanNode.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - PeakMemoryUsage: 0.00 # Peak memory usage during query, not used yet</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsRead: 7 # The number of rows returned from the storage engine to the Scanner, excluding the number of rows filtered by the Scanner.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsReturned: 7 # The number of rows returned from ScanNode to the upper node.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsReturnedRate: 6.979K /sec # RowsReturned/ActiveTime</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - TabletCount: 20 # The number of Tablets involved in this ScanNode.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - TotalReadThroughput: 74.70 KB/sec # BytesRead divided by the total time spent in this node (from Open to Close). For IO bounded queries, this should be very close to the total throughput of all the disks</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - ScannerBatchWaitTime: 426.886us # To count the time the transfer thread waits for the scanner thread to return rowbatch. In pipeline, this value is always 0.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - ScannerWorkerWaitTime: 17.745us # To count the time that the scanner thread waits for the available worker threads in the thread pool.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> OlapScanner:</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - BlockConvertTime: 8.941us # The time it takes to convert a vectorized Block into a RowBlock with a row structure. The vectorized Block is VectorizedRowBatch in V1 and RowBlockV2 in V2.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - BlockFetchTime: 468.974us # Rowset Reader gets the time of the Block.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - ReaderInitTime: 5.475ms # The time when OlapScanner initializes Reader. V1 includes the time to form MergeHeap. V2 includes the time to generate various Iterators and read the first group of blocks.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsDelFiltered: 0 # Including the number of rows filtered out according to the Delete information in the Tablet, and the number of rows filtered for marked deleted rows under the unique key model.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsPushedCondFiltered: 0 # Filter conditions based on the predicates passed down, such as the conditions passed from BuildTable to ProbeTable in Join calculation. This value is not accurate, because if the filtering effect is poor, it will no longer be filtered.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - ScanTime: 39.24us # The time returned from ScanNode to the upper node.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - ShowHintsTime_V1: 0ns # V2 has no meaning. Read part of the data in V1 to perform ScanRange segmentation.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> SegmentIterator:</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - InvertedIndexFilterTimer: 779ns # Use inverted index to filter data time-consuming.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - BlockLoadTime: 415.925us # SegmentReader(V1) or SegmentIterator(V2) gets the time of the block.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - BlockSeekCount: 12 # The number of block seeks when reading Segment.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - BlockSeekTime: 222.556us # It takes time to block seek when reading Segment.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - BlocksLoad: 6 # read the number of blocks</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - CachedPagesNum: 30 # In V2 only, when PageCache is enabled, the number of Pages that hit the Cache.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - CompressedBytesRead: 0.00 # In V1, the size of the data read from the file before decompression. In V2, the pre-compressed size of the read page that did not hit the PageCache.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - DecompressorTimer: 0ns # Data decompression takes time.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - IOTimer: 0ns # IO time for actually reading data from the operating system.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - IndexLoadTime_V1: 0ns # Only in V1, it takes time to read Index Stream.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - NumSegmentFiltered: 0 # When generating Segment Iterator, the number of Segments that are completely filtered out through column statistics and query conditions.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - NumSegmentTotal: 6 # Query the number of all segments involved.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RawRowsRead: 7 # The number of raw rows read in the storage engine. See below for details.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsInvertedIndexFiltered: 0 # Only in V2, the number of rows filtered by the Inverted index.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsBloomFilterFiltered: 0 # Only in V2, the number of rows filtered by BloomFilter index.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsKeyRangeFiltered: 0 # In V2 only, the number of rows filtered out by SortkeyIndex index.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsStatsFiltered: 0 # In V2, the number of rows filtered by the ZoneMap index, including the deletion condition. V1 also contains the number of rows filtered by BloomFilter.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsConditionsFiltered: 0 # Only in V2, the number of rows filtered by various column indexes.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - RowsVectorPredFiltered: 0 # The number of rows filtered by the vectorized condition filtering operation.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - TotalPagesNum: 30 # Only in V2, the total number of pages read.</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - UncompressedBytesRead: 0.00 # V1 is the decompressed size of the read data file (if the file does not need to be decompressed, the file size is directly counted). In V2, only the decompressed size of the Page that missed PageCache is counted (if the Page does not need to be decompressed, the Page size is directly counted)</span><br></span><span class="token-line" style="color:#F8F8F2"><span class="token plain"> - VectorPredEvalTime: 0ns # Time-consuming of vectorized condition filtering operation.</span><br></span></code></pre><div class="buttonGroup__atx"><button type="button" aria-label="Copy code to clipboard" title="Copy" class="clean-btn"><span class="copyButtonIcons_eSgA" aria-hidden="true"><svg viewBox="0 0 24 24" class="copyButtonIcon_y97N"><path fill="currentColor" d="M19,21H8V7H19M19,5H8A2,2 0 0,0 6,7V21A2,2 0 0,0 8,23H19A2,2 0 0,0 21,21V7A2,2 0 0,0 19,5M16,1H4A2,2 0 0,0 2,3V17H4V3H16V1Z"></path></svg><svg viewBox="0 0 24 24" class="copyButtonSuccessIcon_LjdS"><path fill="currentColor" d="M21,7L9,19L3.5,13.5L4.91,12.09L9,16.17L19.59,5.59L21,7Z"></path></svg></span></button></div></div></div><p>The predicate push down and index usage can be inferred from the related indicators of the number of data rows in the profile. The following only describes the profile in the reading process of segment V2 format data. In segment V1 format, the meaning of these indicators is slightly different.</p><ul><li>When reading a segment V2, if the query has key_ranges (the query range composed of prefix keys), first filter the data through the SortkeyIndex index, and the number of filtered rows is recorded in <code>RowsKeyRangeFiltered</code>.</li><li>After that, use the Inverted index to perform precise filtering on the columns containing the inverted index in the query condition, and the number of filtered rows is recorded in <code>RowsInvertedIndexFiltered</code>.</li><li>After that, according to the equivalent (eq, in, is) condition in the query condition, use the BloomFilter index to filter the data and record it in <code>RowsBloomFilterFiltered</code>. The value of <code>RowsBloomFilterFiltered</code> is the difference between the total number of rows of the Segment (not the number of rows filtered by the Inverted index) and the number of remaining rows after BloomFilter, so the data filtered by BloomFilter may overlap with the data filtered by inverted index.</li><li>After that, use the ZoneMap index to filter the data according to the query conditions and delete conditions and record it in <code>RowsStatsFiltered</code>.</li><li><code>RowsConditionsFiltered</code> is the number of rows filtered by various indexes, including the values of <code>RowsBloomFilterFiltered</code> and <code>RowsStatsFiltered</code>.</li><li>So far, the Init phase is completed, and the number of rows filtered by the condition to be deleted in the Next phase is recorded in <code>RowsDelFiltered</code>. Therefore, the number of rows actually filtered by the delete condition are recorded in <code>RowsStatsFiltered</code> and <code>RowsDelFiltered</code> respectively.</li><li><code>RawRowsRead</code> is the final number of rows to be read after the above filtering.</li><li><code>RowsRead</code> is the number of rows finally returned to Scanner. <code>RowsRead</code> is usually smaller than <code>RawRowsRead</code>, because returning from the storage engine to the Scanner may go through a data aggregation. If the difference between <code>RawRowsRead</code> and <code>RowsRead</code> is large, it means that a large number of rows are aggregated, and aggregation may be time-consuming.</li><li><code>RowsReturned</code> is the number of rows finally returned by ScanNode to the upper node. <code>RowsReturned</code> is usually smaller than <code>RowsRead</code>. Because there will be some predicate conditions on the Scanner that are not pushed down to the storage engine, filtering will be performed once. If the difference between <code>RowsRead</code> and <code>RowsReturned</code> is large, it means that many rows are filtered in the Scanner. This shows that many highly selective predicate conditions are not pushed to the storage engine. The filtering efficiency in Scanner is worse than that in storage engine.</li></ul><p>Through the above indicators, you can roughly analyze the number of rows processed by the storage engine and the size of the final filtered result row. Through the <code>Rows***Filtered</code> group of indicators, it is also possible to analyze whether the query conditions are pushed down to the storage engine, and the filtering effects of different indexes. In addition, a simple analysis can be made through the following aspects.</p><ul><li>Many indicators under <code>OlapScanner</code>, such as <code>IOTimer</code>, <code>BlockFetchTime</code>, etc., are the accumulation of all Scanner thread indicators, so the value may be relatively large. And because the Scanner thread reads data asynchronously, these cumulative indicators can only reflect the cumulative working time of the Scanner, and do not directly represent the time consumption of the ScanNode. The time-consuming ratio of ScanNode in the entire query plan is the value recorded in the <code>Active</code> field. Sometimes it appears that <code>IOTimer</code> has tens of seconds, but <code>Active</code> is actually only a few seconds. This situation is usually due to:<ul><li><code>IOTimer</code> is the accumulated time of multiple Scanners, and there are more Scanners.</li><li>The upper node is time-consuming. For example, the upper node takes 100 seconds, while the lower ScanNode only takes 10 seconds. The field reflected in <code>Active</code> may be only a few milliseconds. Because while the upper layer is processing data, ScanNode has performed data scanning asynchronously and prepared the data. When the upper node obtains data from ScanNode, it can obtain the prepared data, so the Active time is very short.</li></ul></li><li><code>NumScanners</code> represents the number of Tasks submitted by the Scanner to the thread pool. It is scheduled by the thread pool in <code>RuntimeState</code>. The two parameters <code>doris_scanner_thread_pool_thread_num</code> and <code>doris_scanner_thread_pool_queue_size</code> control the size of the thread pool and the queue length respectively. Too many or too few threads will affect query efficiency. At the same time, some summary indicators can be divided by the number of threads to roughly estimate the time consumption of each thread.</li><li><code>TabletCount</code> indicates the number of tablets to be scanned. Too many may mean a lot of random read and data merge operations.</li><li><code>UncompressedBytesRead</code> indirectly reflects the amount of data read. If the value is large, it means that there may be a lot of IO operations.</li><li><code>CachedPagesNum</code> and <code>TotalPagesNum</code> can check the hitting status of PageCache. The higher the hit rate, the less time-consuming IO and decompression operations. </li></ul><h4 class="anchor anchorWithStickyNavbar_LWe7" id="buffer-pool"><code>Buffer pool</code><a href="#buffer-pool" class="hash-link" aria-label="Direct link to buffer-pool" title="Direct link to buffer-pool"></a></h4><ul><li>AllocTime: Memory allocation time</li><li>CumulativeAllocationBytes: Cumulative amount of memory allocated</li><li>CumulativeAllocations: Cumulative number of memory allocations</li><li>PeakReservation: Peak of reservation</li><li>PeakUnpinnedBytes: Amount of memory data of unpin</li><li>PeakUsedReservation: Peak usage of reservation</li><li>ReservationLimit: Limit of reservation of bufferpool</li></ul></div></article><nav class="pagination-nav docusaurus-mt-lg" aria-label="Docs pages"><a class="pagination-nav__link pagination-nav__link--prev" href="/docs/2.0/query/high-concurrent-point-query"><div class="pagination-nav__sublabel">Previous</div><div class="pagination-nav__label">High-Concurrency Point Query</div></a><a class="pagination-nav__link pagination-nav__link--next" href="/docs/2.0/query/query-analysis/"><div class="pagination-nav__sublabel">Next</div><div class="pagination-nav__label">Query Analysis</div></a></nav></div></div><div class="col col--3"><div class="tableOfContents_jeP5 thin-scrollbar theme-doc-toc-desktop"><a href="https://github.com/apache/doris/discussions" target="_blank" rel="noopener noreferrer" class="ml-4 mb-8 flex items-center hover:no-underline"><span class="pr-2">Join Discussion</span><svg viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="8500" id="mx_n_1711090272569" width="16" height="16"><path d="M522.24 896.512c-25.6 4.608-51.712 7.168-78.336 7.168-79.36 0-157.696-21.504-225.792-62.464l-18.432-10.752-103.936 28.16c-28.672 7.68-54.784-18.432-47.104-47.104l28.16-103.936c-10.752-17.92-17.408-30.208-20.992-36.864C20.992 607.232 3.072 536.064 3.584 463.36c0-243.2 197.12-440.32 440.32-440.32 221.696 0 405.504 164.352 435.712 377.856 90.112 55.808 144.896 154.112 144.896 260.096 0 51.2-12.8 100.352-36.352 144.384-2.048 4.096-6.144 10.752-11.776 20.48l17.408 64c7.68 28.672-18.432 54.784-47.104 47.104l-64-17.408-7.68 4.608c-47.616 28.672-101.888 43.52-157.184 43.52-71.68-0.512-140.8-25.088-195.584-71.168z m95.232-28.672c31.232 15.36 65.536 23.04 100.352 23.04 41.472 0 82.432-11.264 117.76-32.768 2.56-1.536 9.728-5.632 22.016-12.8 8.704-5.12 19.456-6.656 29.184-3.584l14.848 4.096-4.096-14.848c-2.56-10.24-1.536-20.48 4.096-29.696 6.144-10.24 12.288-20.992 18.432-31.232 17.92-33.28 27.136-70.656 27.136-108.544 0-59.904-23.552-117.76-65.536-160.256-13.312 164.352-118.272 303.616-264.192 366.592z m-462.848-155.648l-14.848 54.784 54.784-14.848c9.728-2.56 20.48-1.536 29.184 4.096 18.432 10.752 29.184 16.896 32.768 19.456 56.32 33.792 120.832 51.712 186.88 51.712 200.704 0 363.52-162.816 363.52-363.52s-162.816-363.52-363.52-363.52-363.52 162.816-363.52 363.52c0 60.928 14.848 119.296 43.008 171.52 3.584 7.168 13.312 23.04 27.648 47.616 5.632 8.704 6.656 19.456 4.096 29.184z m448.512-382.976c20.992 0 38.4 16.896 38.4 38.4 0 20.992-16.896 38.4-38.4 38.4H284.16c-20.992 0-38.4-16.896-38.4-38.4 0-20.992 16.896-38.4 38.4-38.4h318.976z m-153.088 191.488c20.992 0 38.4 16.896 38.4 38.4 0 20.992-16.896 38.4-38.4 38.4H284.16c-20.992 0-38.4-16.896-38.4-38.4 0-20.992 16.896-38.4 38.4-38.4h165.888z m0 0" p-id="8501" fill="currentColor"></path></svg></a><span class="ml-4">On This Page</span><ul class="table-of-contents table-of-contents__left-border"><li><a href="#noun-interpretation" class="table-of-contents__link toc-highlight">Noun Interpretation</a></li><li><a href="#basic-concepts" class="table-of-contents__link toc-highlight">Basic concepts</a></li><li><a href="#specific-operation" class="table-of-contents__link toc-highlight">Specific operation</a></li><li><a href="#profile-statistic-analysis" class="table-of-contents__link toc-highlight">Profile statistic analysis</a></li></ul></div></div></div></div></main></div></div></div><div class="footer pt-16 pb-10"><div class="container"><div class="footer-box"><div class="left"><img src="/images/asf_logo_apache.svg" alt="" class="themedImage_ToTc themedImage--light_HNdA footer__logo"><img src="/images/asf_logo_apache.svg" alt="" class="themedImage_ToTc themedImage--dark_i4oU footer__logo"><div class="row footer__links"><div class="col footer__col"><div class="footer__title">ASF</div><ul class="footer__items clean-list"><li class="footer__item"><a href="https://www.apache.org/" target="_blank" rel="noopener noreferrer" class="footer__link-item">Foundation<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://www.apache.org/licenses/" target="_blank" rel="noopener noreferrer" class="footer__link-item">License<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://www.apache.org/events/current-event" target="_blank" rel="noopener noreferrer" class="footer__link-item">Events<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://www.apache.org/foundation/sponsorship.html" target="_blank" rel="noopener noreferrer" class="footer__link-item">Sponsorship<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://privacy.apache.org/policies/privacy-policy-public.html" target="_blank" rel="noopener noreferrer" class="footer__link-item">Privacy<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://www.apache.org/security/" target="_blank" rel="noopener noreferrer" class="footer__link-item">Security<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://www.apache.org/foundation/thanks.html" target="_blank" rel="noopener noreferrer" class="footer__link-item">Thanks<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li></ul></div><div class="col footer__col"><div class="footer__title">Resources</div><ul class="footer__items clean-list"><li class="footer__item"><a class="footer__link-item" href="/download">Download</a></li><li class="footer__item"><a class="footer__link-item" href="/docs/get-starting/quick-start">Docs</a></li><li class="footer__item"><a class="footer__link-item" href="/blog">Blog</a></li><li class="footer__item"><a class="footer__link-item" href="/ecosystem/cluster-management">Ecosystem</a></li><li class="footer__item"><a class="footer__link-item" href="/users">Users</a></li><li class="footer__item"><a href="https://github.com/apache/doris/discussions" target="_blank" rel="noopener noreferrer" class="footer__link-item">Discussions<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li></ul></div><div class="col footer__col"><div class="footer__title">Community</div><ul class="footer__items clean-list"><li class="footer__item"><a class="footer__link-item" href="/community/how-to-contribute/">How to contribute</a></li><li class="footer__item"><a href="https://github.com/apache/doris/" target="_blank" rel="noopener noreferrer" class="footer__link-item">Source code<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a href="https://cwiki.apache.org/confluence/display/DORIS/Doris+Improvement+Proposals" target="_blank" rel="noopener noreferrer" class="footer__link-item">Improvement proposal<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li><li class="footer__item"><a class="footer__link-item" href="/community/team">Doris team</a></li><li class="footer__item"><a href="https://github.com/apache/doris/issues/30669" target="_blank" rel="noopener noreferrer" class="footer__link-item">Roadmap<svg width="13.5" height="13.5" aria-hidden="true" viewBox="0 0 24 24" class="iconExternalLink_nPIU"><path fill="currentColor" d="M21 13v10h-21v-19h12v2h-10v15h17v-8h2zm3-12h-10.988l4.035 4-6.977 7.07 2.828 2.828 6.977-7.07 4.125 4.172v-11z"></path></svg></a></li></ul></div></div></div><div class="right"><div class="footer__title">Join the community</div><div class="social-list"><div class="social"><a href="mailto:dev@doris.apache.org" target="_blank" title="mail" class="item"><svg xmlns="http://www.w3.org/2000/svg" width="2em" height="2em" viewBox="0 0 32 32" fill="none"><path d="M5.6003 6H26.3997C27.8186 6 28.982 7.10964 29 8.46946L16.0045 15.454L3.01202 8.47829C3.02405 7.11258 4.1784 6 5.6003 6ZM3.01202 11.1508L3 23.5011C3 24.8756 4.16938 26 5.6003 26H26.3997C27.8306 26 29 24.8756 29 23.5011V11.145L16.3111 17.8028C16.1157 17.9058 15.8813 17.9058 15.6889 17.8028L3.01202 11.1508Z" fill="currentColor"></path></svg></a><a href="https://github.com/apache/doris" target="_blank" title="github" class="item"><svg width="2em" height="2em" viewBox="0 0 32 32" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M16.0001 2.66675C8.63342 2.66675 2.66675 8.63341 2.66675 16.0001C2.66524 18.7991 3.54517 21.5276 5.1817 23.7983C6.81824 26.0691 9.12828 27.7668 11.7841 28.6508C12.4508 28.7668 12.7001 28.3668 12.7001 28.0161C12.7001 27.7001 12.6828 26.6508 12.6828 25.5334C9.33342 26.1508 8.46675 24.7174 8.20008 23.9668C8.04942 23.5828 7.40008 22.4001 6.83342 22.0828C6.36675 21.8334 5.70008 21.2161 6.81608 21.2001C7.86675 21.1828 8.61608 22.1668 8.86675 22.5668C10.0668 24.5828 11.9841 24.0161 12.7494 23.6668C12.8668 22.8001 13.2161 22.2174 13.6001 21.8841C10.6334 21.5508 7.53342 20.4001 7.53342 15.3001C7.53342 13.8494 8.04942 12.6507 8.90008 11.7161C8.76675 11.3827 8.30008 10.0161 9.03342 8.18275C9.03342 8.18275 10.1494 7.83342 12.7001 9.55075C13.7855 9.2495 14.907 9.09787 16.0334 9.10008C17.1668 9.10008 18.3001 9.24942 19.3668 9.54942C21.9161 7.81608 23.0334 8.18408 23.0334 8.18408C23.7668 10.0174 23.3001 11.3841 23.1668 11.7174C24.0161 12.6507 24.5334 13.8334 24.5334 15.3001C24.5334 20.4174 21.4174 21.5508 18.4508 21.8841C18.9334 22.3001 19.3508 23.1001 19.3508 24.3508C19.3508 26.1334 19.3334 27.5668 19.3334 28.0174C19.3334 28.3668 19.5841 28.7828 20.2508 28.6494C22.8975 27.7558 25.1973 26.0547 26.8266 23.7856C28.4559 21.5165 29.3327 18.7936 29.3334 16.0001C29.3334 8.63341 23.3668 2.66675 16.0001 2.66675V2.66675Z" fill="currentColor"></path></svg></a><a href="https://twitter.com/doris_apache" target="_blank" title="twitter" class="item"><svg xmlns="http://www.w3.org/2000/svg" width="2em" height="2em" viewBox="0 0 32 32" fill="none"><path d="M4.625 4.625H11.2809L27.375 27.375H20.7191L4.625 4.625ZM7.52549 6.10639L21.5236 25.8936H24.4746L10.4764 6.10639H7.52549Z" fill="currentColor"></path><path d="M14.4268 18.4803L6.53447 27.375H4.625L13.5581 17.2525L14.4268 18.4803ZM18.1299 14.3066L26.7203 4.625H24.7017L17.2525 13.0662L18.1299 14.3066Z" fill="currentColor"></path></svg></a><a href="https://join.slack.com/t/apachedoriscommunity/shared_invite/zt-2kl08hzc0-SPJe4VWmL_qzrFd2u2XYQA" title="slack" target="_blank" class="item"><svg width="2em" height="2em" viewBox="0 0 32 32" fill="none" xmlns="http://www.w3.org/2000/svg"><g clip-path="url(#clip0_125_278)"><path d="M12.5875 16.6906C11.0844 16.6906 9.86562 17.9094 9.86562 19.4125V26.2375C9.86562 26.9594 10.1524 27.6517 10.6628 28.1622C11.1733 28.6726 11.8656 28.9594 12.5875 28.9594C13.3094 28.9594 14.0017 28.6726 14.5122 28.1622C15.0226 27.6517 15.3094 26.9594 15.3094 26.2375V19.4531C15.3094 17.9094 14.0906 16.6906 12.5875 16.6906ZM3 19.4531C3 20.175 3.28677 20.8673 3.79722 21.3778C4.30767 21.8882 4.99999 22.175 5.72187 22.175C6.44376 22.175 7.13608 21.8882 7.64653 21.3778C8.15698 20.8673 8.44375 20.175 8.44375 19.4531V16.7312H5.7625C4.25938 16.6906 3 17.9094 3 19.4531ZM12.5875 3C11.8656 3 11.1733 3.28677 10.6628 3.79722C10.1524 4.30767 9.86562 4.99999 9.86562 5.72187C9.86562 6.44376 10.1524 7.13608 10.6628 7.64653C11.1733 8.15698 11.8656 8.44375 12.5875 8.44375H15.3094V5.72187C15.3094 4.21875 14.0906 3 12.5875 3ZM5.72187 15.3094H12.5469C13.2688 15.3094 13.9611 15.0226 14.4715 14.5122C14.982 14.0017 15.2688 13.3094 15.2688 12.5875C15.2688 11.8656 14.982 11.1733 14.4715 10.6628C13.9611 10.1524 13.2688 9.86562 12.5469 9.86562H5.72187C4.99999 9.86562 4.30767 10.1524 3.79722 10.6628C3.28677 11.1733 3 11.8656 3 12.5875C3 13.3094 3.28677 14.0017 3.79722 14.5122C4.30767 15.0226 4.99999 15.3094 5.72187 15.3094ZM26.2375 9.86562C24.7344 9.86562 23.5156 11.0844 23.5156 12.5875V15.3094H26.2375C26.9594 15.3094 27.6517 15.0226 28.1622 14.5122C28.6726 14.0017 28.9594 13.3094 28.9594 12.5875C28.9594 11.8656 28.6726 11.1733 28.1622 10.6628C27.6517 10.1524 26.9594 9.86562 26.2375 9.86562ZM16.6906 5.72187V12.5875C16.6906 13.3094 16.9774 14.0017 17.4878 14.5122C17.9983 15.0226 18.6906 15.3094 19.4125 15.3094C20.1344 15.3094 20.8267 15.0226 21.3372 14.5122C21.8476 14.0017 22.1344 13.3094 22.1344 12.5875V5.72187C22.1344 4.99999 21.8476 4.30767 21.3372 3.79722C20.8267 3.28677 20.1344 3 19.4125 3C18.6906 3 17.9983 3.28677 17.4878 3.79722C16.9774 4.30767 16.6906 4.99999 16.6906 5.72187ZM22.1344 26.2781C22.1344 24.775 20.9156 23.5562 19.4125 23.5562H16.6906V26.2781C16.6906 27 16.9774 27.6923 17.4878 28.2028C17.9983 28.7132 18.6906 29 19.4125 29C20.1344 29 20.8267 28.7132 21.3372 28.2028C21.8476 27.6923 22.1344 27 22.1344 26.2781ZM26.2781 16.6906H19.4125C18.6906 16.6906 17.9983 16.9774 17.4878 17.4878C16.9774 17.9983 16.6906 18.6906 16.6906 19.4125C16.6906 20.1344 16.9774 20.8267 17.4878 21.3372C17.9983 21.8476 18.6906 22.1344 19.4125 22.1344H26.2375C27.7406 22.1344 28.9594 20.9156 28.9594 19.4125C29 17.9094 27.7812 16.6906 26.2781 16.6906Z" fill="currentColor"></path></g><defs><clipPath id="clip0_125_278"><rect width="26" height="26" fill="currentColor" transform="translate(3 3)"></rect></clipPath></defs></svg></a></div><div class="social"><a href="https://www.youtube.com/@apachedoris/channels" title="youtube" target="_blank" class="item"><svg xmlns="http://www.w3.org/2000/svg" width="2em" height="2em" viewBox="0 0 32 32" fill="none"><path d="M28.5167 7.83429C28.9436 8.25423 29.2532 8.77539 29.4154 9.34742C29.8205 11.5462 30.0159 13.7775 29.999 16.0121C30.0144 18.2382 29.819 20.4609 29.4154 22.6515C29.2532 23.2235 28.9436 23.7446 28.5167 24.1645C28.0898 24.5845 27.5601 24.889 26.9785 25.0486C24.7728 25.625 16.0124 25.625 16.0124 25.625C16.0124 25.625 7.22652 25.625 5.04638 25.0486C4.46489 24.889 3.9351 24.5845 3.5082 24.1645C3.08132 23.7446 2.77176 23.2235 2.60948 22.6515C2.19736 20.4617 1.9934 18.239 2.00025 16.0121C1.9918 13.7767 2.19577 11.5455 2.60948 9.34742C2.77176 8.77539 3.08132 8.25423 3.5082 7.83429C3.9351 7.41436 4.46489 7.10985 5.04638 6.95021C7.25103 6.36354 16.0124 6.37502 16.0124 6.37502C16.0124 6.37502 24.796 6.37502 26.9785 6.95021C27.5601 7.10985 28.0898 7.41436 28.5167 7.83429ZM12.5 21.25L21.25 16.008L12.5 10.75V21.25Z" fill="currentColor"></path></svg></a><a href="https://www.linkedin.com/company/doris-apache/" title="linkedin" target="_blank" class="item"><svg width="2rem" height="2rem" viewBox="0 0 32 32" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M4.29925 26.9996H9.66738V11.6781H4.29925V26.9996ZM22.1628 11.1949C19.9409 11.1949 18.7157 11.9388 17.3054 13.7407V11.6777H11.9459V26.9996H17.305V18.6738C17.305 16.9168 18.145 15.1982 20.1535 15.1982C22.162 15.1982 22.6559 16.9164 22.6559 18.632V27H28V18.2902C28 12.2386 24.3854 11.1949 22.1628 11.1949ZM6.99325 4C5.3395 4 4 5.21047 4 6.7046C4 8.19759 5.3395 9.40617 6.99325 9.40617C8.6455 9.40617 9.985 8.19722 9.985 6.7046C9.985 5.21047 8.6455 4 6.99325 4Z" fill="white"></path></svg></a><a href="https://medium.com/@ApacheDoris" title="medium" target="_blank" class="item"><svg width="2em" height="2em" viewBox="0 0 32 32" fill="none" xmlns="http://www.w3.org/2000/svg"><g id="Frame"><path id="Vector" d="M17.7967 16.5385C17.8029 18.53 16.9746 20.4425 15.4937 21.8559C14.0128 23.2693 12.0004 24.0681 9.89836 24.0769C7.79633 24.0681 5.78391 23.2693 4.30302 21.8559C2.82212 20.4425 1.99383 18.53 2.00003 16.5385C1.99383 14.5469 2.82212 12.6344 4.30302 11.221C5.78391 9.80759 7.79633 9.00878 9.89836 9C12.0004 9.00878 14.0128 9.80759 15.4937 11.221C16.9746 12.6344 17.8029 14.5469 17.7967 16.5385ZM26.4533 16.5385C26.4533 20.4514 24.6917 23.6348 22.51 23.6348C20.3283 23.6348 18.555 20.4514 18.555 16.5385C18.555 12.6255 20.3283 9.44214 22.51 9.44214C24.6917 9.44214 26.4533 12.6255 26.4533 16.5385ZM30 16.5385C30 20.0424 29.3817 22.8942 28.6117 22.8942C27.8417 22.8942 27.2233 20.0424 27.2233 16.5385C27.2233 13.0345 27.8417 10.1827 28.6117 10.1827C29.3817 10.1827 30 13.0345 30 16.5385Z" fill="currentColor"></path></g></svg></a><a class="item wechat"><svg width="2em" height="2em" viewBox="0 0 32 32" fill="none" xmlns="http://www.w3.org/2000/svg"><path d="M20.7578 11.5169C21.0708 11.5169 21.3795 11.5398 21.6851 11.573C20.8524 7.73517 16.7052 4.88306 11.9718 4.88306C6.67951 4.88306 2.34412 8.45283 2.34412 12.9854C2.34412 15.6013 3.78679 17.7498 6.19667 19.4161L5.2339 22.2827L8.59917 20.6122C9.80411 20.8478 10.7698 21.0906 11.9718 21.0906C12.2738 21.0906 12.5728 21.0759 12.8703 21.0523C12.682 20.4159 12.5728 19.7485 12.5728 19.0566C12.5728 14.8947 16.1847 11.5169 20.7578 11.5169ZM15.5822 8.9335C16.3072 8.9335 16.7871 9.40601 16.7871 10.1229C16.7871 10.8369 16.3072 11.3153 15.5822 11.3153C14.8601 11.3153 14.1365 10.8369 14.1365 10.1229C14.1365 9.40601 14.8601 8.9335 15.5822 8.9335ZM8.84429 11.3153C8.12218 11.3153 7.3942 10.8368 7.3942 10.1229C7.3942 9.40597 8.12218 8.93346 8.84429 8.93346C9.56559 8.93346 10.0463 9.40597 10.0463 10.1229C10.0463 10.8369 9.56559 11.3153 8.84429 11.3153ZM29.5453 18.9422C29.5453 15.1332 25.6935 12.0285 21.3677 12.0285C16.7871 12.0285 13.1797 15.1332 13.1797 18.9422C13.1797 22.7567 16.7871 25.8547 21.3677 25.8547C22.326 25.8547 23.2932 25.6169 24.2559 25.3777L26.897 26.8086L26.1726 24.4282C28.1056 22.993 29.5453 21.0906 29.5453 18.9422ZM18.7126 17.7498C18.2335 17.7498 17.7499 17.278 17.7499 16.7966C17.7499 16.3219 18.2335 15.8442 18.7126 15.8442C19.4406 15.8442 19.9176 16.3219 19.9176 16.7966C19.9176 17.278 19.4406 17.7498 18.7126 17.7498ZM24.0079 17.7498C23.5324 17.7498 23.0518 17.278 23.0518 16.7966C23.0518 16.3219 23.5324 15.8442 24.0079 15.8442C24.73 15.8442 25.2128 16.3219 25.2128 16.7966C25.2128 17.278 24.73 17.7498 24.0079 17.7498Z" fill="currentColor"></path></svg><div class="wechat-dropdown"><p class="text-[#4c576c] text-xs">Connect on WeChat</p><img src="https://cdnd.selectdb.com/assets/images/doris-wechat-b949e908a3bc2776d824f79a9100bd4b.png" alt=""></div></a></div></div></div></div><div class="footer__copyright">Copyright © 2024 The Apache Software Foundation,Licensed under the <a href="https://www.apache.org/licenses/LICENSE-2.0" target="_blank">Apache License, Version 2.0</a>. Apache, Doris, Apache Doris, the Apache feather logo and the Apache Doris logo are trademarks of The Apache Software Foundation.</div></div></div></div> |
| <script src="https://cdnd.selectdb.com/assets/js/runtime~main.eb208fba.js"></script> |
| <script src="https://cdnd.selectdb.com/assets/js/main.fa7fcb85.js"></script> |
| </body> |
| </html> |
