Google Git
Sign in
apache/iotdb-website/refs/heads/asf-site/./zh/UserGuide/latest-Table/Reference/System-Tables_apache.html
blob: ec74fe8db5e0a7029e3649ae87b708df412da847 [file]
<!doctype html>
<html lang="zh-CN" data-theme="light">
<head>
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width,initial-scale=1" />
<meta name="generator" content="VuePress 2.0.0-rc.26" />
<meta name="theme" content="VuePress Theme Hope 2.0.0-rc.99" />
<style>
:root {
--vp-c-bg: #fff;
}
[data-theme="dark"] {
--vp-c-bg: #1b1b1f;
}
html,
body {
background: var(--vp-c-bg);
}
</style>
<script>
const userMode = localStorage.getItem("vuepress-theme-hope-scheme");
const systemDarkMode =
window.matchMedia &&
window.matchMedia("(prefers-color-scheme: dark)").matches;
if (userMode === "dark" || (userMode !== "light" && systemDarkMode)) {
document.documentElement.setAttribute("data-theme", "dark");
}
</script>
<script type="application/ld+json">{"@context":"https://schema.org","@type":"Article","headline":"系统表","image":[""],"dateModified":"2026-04-22T04:07:51.000Z","author":[]}</script><meta property="og:url" content="https://iotdb.apache.org/zh/UserGuide/latest-Table/Reference/System-Tables_apache.html"><meta property="og:site_name" content="IoTDB Website"><meta property="og:title" content="系统表"><meta property="og:description" content="系统表 IoTDB 内置系统数据库 INFORMATION_SCHEMA，其中包含一系列系统表，用于存储 IoTDB 运行时信息（如当前正在执行的 SQL 语句等）。目前INFORMATION_SCHEMA数据库只支持读操作。 1. 系统库 名称：INFORMATION_SCHEMA 指令：只读，只支持 Show databases (DETAILS)..."><meta property="og:type" content="article"><meta property="og:locale" content="zh-CN"><meta property="og:locale:alternate" content="en-US"><meta property="og:updated_time" content="2026-04-22T04:07:51.000Z"><meta property="article:modified_time" content="2026-04-22T04:07:51.000Z"><link rel="alternate" hreflang="en-us" href="https://iotdb.apache.org/UserGuide/latest-Table/Reference/System-Tables_apache.html"><script async src="https://widget.kapa.ai/kapa-widget.bundle.js" data-website-id="2d37bfdd-8d98-40ba-9223-9d4f81bfb327" data-project-name="Apache IoTDB" data-project-color="#FFFFFF" data-button-z-index="1999" data-button-padding="4px" data-button-border-radius="4px" data-button-image-height="24px" data-button-image-width="20px" data-button-text-color="#9E2878" data-project-logo="https://iotdb.apache.org/img/logo.svg" data-button-position-right="16px" data-button-position-bottom="8px" data-button-height="56px" data-button-width="48px" data-button-text="Ask" data-modal-override-open-selector="#custom-ask-ai-button" data-modal-image-width="150px" data-modal-title="AI Docs" data-modal-title-color="#9E2878" data-deep-thinking-button-active-bg-color="#F6F7F8" data-deep-thinking-button-active-text-color="#9E2878" data-deep-thinking-button-active-hover-text-color="#9E2878" data-modal-disclaimer="这是一个针对 Apache IoTDB 的定制化大型语言模型，能够访问所有[文档](iotdb.apache.org/docs/)、[GitHub 公开问题、PR 和自述文件](github.com/apache/iotdb)。&#10;&#10;
如果您遇到 <Error in verifying browser for feedback submission. Captcha token could not be obtained.> 请确保您能够顺畅访问 Google 服务。" data-user-analytics-fingerprint-enabled="true" data-consent-required="true" data-consent-screen-disclaimer="点击<I agree, let's chat>即表示您同意按照 kapa.ai 的[隐私政策](https://www.kapa.ai/content/privacy-policy)使用 AI 助手。本服务使用 reCAPTCHA，您需要同意 Google 的[隐私政策](https://policies.google.com/privacy)和[服务条款](https://policies.google.com/terms)。继续操作即表示您明确同意 kapa.ai 和 Google 的隐私政策。" data-language="zh"></script><link rel="icon" href="/favicon.ico"><meta name="Description" content="Apache IoTDB: Time Series Database for IoT"><meta name="Keywords" content="TSDB, time series, time series database, IoTDB, IoT database, IoT data management, 时序数据库, 时间序列管理, IoTDB, 物联网数据库, 实时数据库, 物联网数据管理, 物联网数据"><meta name="baidu-site-verification" content="wfKETzB3OT"><meta name="google-site-verification" content="mZWAoRY0yj_HAr-s47zHCGHzx5Ju-RVm5wDbPnwQYFo"><script type="text/javascript">var _paq = window._paq = window._paq || [];
/* tracker methods like "setCustomDimension" should be called before "trackPageView" */
_paq.push(["setDoNotTrack", true]);
_paq.push(["disableCookies"]);
_paq.push(['trackPageView']);
_paq.push(['enableLinkTracking']);
(function() {
var u="https://analytics.apache.org/";
_paq.push(['setTrackerUrl', u+'matomo.php']);
_paq.push(['setSiteId', '56']);
var d=document, g=d.createElement('script'), s=d.getElementsByTagName('script')[0];
g.async=true; g.src=u+'matomo.js'; s.parentNode.insertBefore(g,s);
})();
</script><title>系统表 | IoTDB Website</title><meta name="description" content="系统表 IoTDB 内置系统数据库 INFORMATION_SCHEMA，其中包含一系列系统表，用于存储 IoTDB 运行时信息（如当前正在执行的 SQL 语句等）。目前INFORMATION_SCHEMA数据库只支持读操作。 1. 系统库 名称：INFORMATION_SCHEMA 指令：只读，只支持 Show databases (DETAILS)...">
<link rel="preload" href="/assets/style-JraSdRX4.css" as="style"><link rel="stylesheet" href="/assets/style-JraSdRX4.css">
<link rel="modulepreload" href="/assets/app-C4FS647M.js"><link rel="modulepreload" href="/assets/System-Tables_apache.html-Dpd5nhNJ.js">
</head>
<body>
<div id="app"><!--[--><!--[--><!--[--><span tabindex="-1"></span><a href="#main-content" class="vp-skip-link sr-only">跳至主要內容</a><!--]--><!--[--><div class="theme-container external-link-icon has-toc" vp-container><!--[--><header id="navbar" class="vp-navbar" vp-navbar><div class="vp-navbar-start"><button type="button" class="vp-toggle-sidebar-button" title="Toggle Sidebar"><span class="icon"></span></button><!--[--><a class="route-link vp-brand" href="/zh/" aria-label="带我回家"><img class="vp-nav-logo" src="/logo.png" alt><!----><!----></a><!--]--></div><div class="vp-navbar-center"><!--[--><!--]--></div><div class="vp-navbar-end"><!--[--><!--[--><div id="docsearch-container" style="display:none;"></div><div class="docsearch-placeholder"><button type="button" aria-label="搜索文档" aria-keyshortcuts="Control+k" class="DocSearch DocSearch-Button"><span class="DocSearch-Button-Container"><svg width="20" height="20" viewBox="0 0 24 24" aria-hidden="true" class="DocSearch-Search-Icon"><circle cx="11" cy="11" r="8" stroke="currentColor" fill="none" stroke-width="1.4"></circle><path d="m21 21-4.3-4.3" stroke="currentColor" fill="none" stroke-linecap="round" stroke-linejoin="round"></path></svg><span class="DocSearch-Button-Placeholder">搜索文档</span></span><span class="DocSearch-Button-Keys"><kbd class="DocSearch-Button-Key DocSearch-Button-Key--ctrl">Ctrl</kbd><kbd class="DocSearch-Button-Key">K</kbd></span></button></div><!--]--><div><button id="custom-ask-ai-button"> ✨ Ask AI </button></div><nav class="vp-nav-links"><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="文档"><!--[--><!---->文档<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/UserGuide/latest/QuickStart/QuickStart_apache.html" aria-label="v2.0.x"><!---->v2.0.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/UserGuide/V1.3.x/QuickStart/QuickStart_apache.html" aria-label="v1.3.x"><!---->v1.3.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/UserGuide/V1.2.x/QuickStart/QuickStart.html" aria-label="v1.2.x"><!---->v1.2.x<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/UserGuide/V0.13.x/QuickStart/QuickStart.html" aria-label="v0.13.x"><!---->v0.13.x<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><a class="auto-link external-link" href="https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=177051872" aria-label="系统设计" rel="noopener noreferrer" target="_blank"><!---->系统设计<!----></a></div><div class="vp-nav-item hide-in-mobile"><a class="route-link auto-link" href="/zh/Download/" aria-label="下载"><!---->下载<!----></a></div><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="社区"><!--[--><!---->社区<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/About.html" aria-label="关于社区"><!---->关于社区<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Development-Guide.html" aria-label="贡献指南"><!---->贡献指南<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Community-Partners.html" aria-label="社区伙伴"><!---->社区伙伴<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Feedback.html" aria-label="交流与反馈"><!---->交流与反馈<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Events-and-Reports.html" aria-label="活动与报告"><!---->活动与报告<!----></a></li><li class="vp-dropdown-item"><a class="route-link auto-link" href="/zh/Community/Committers.html" aria-label="Committers"><!---->Committers<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="ASF"><!--[--><!---->ASF<!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/" aria-label="基金会" rel="noopener noreferrer" target="_blank"><!---->基金会<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/licenses/" aria-label="许可证" rel="noopener noreferrer" target="_blank"><!---->许可证<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/security/" aria-label="安全" rel="noopener noreferrer" target="_blank"><!---->安全<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/foundation/sponsorship.html" aria-label="赞助" rel="noopener noreferrer" target="_blank"><!---->赞助<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/foundation/thanks.html" aria-label="致谢" rel="noopener noreferrer" target="_blank"><!---->致谢<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://www.apache.org/events/current-event" aria-label="活动" rel="noopener noreferrer" target="_blank"><!---->活动<!----></a></li><li class="vp-dropdown-item"><a class="auto-link external-link" href="https://privacy.apache.org/policies/privacy-policy-public.html" aria-label="隐私" rel="noopener noreferrer" target="_blank"><!---->隐私<!----></a></li></ul></button></div></div></nav><div class="vp-nav-item"><div class="vp-dropdown-wrapper"><button type="button" class="vp-dropdown-title" aria-label="选择语言"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon i18n-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="i18n icon" name="i18n" style="width:1rem;height:1rem;vertical-align:middle;"><path d="M379.392 460.8 494.08 575.488l-42.496 102.4L307.2 532.48 138.24 701.44l-71.68-72.704L234.496 460.8l-45.056-45.056c-27.136-27.136-51.2-66.56-66.56-108.544h112.64c7.68 14.336 16.896 27.136 26.112 35.84l45.568 46.08 45.056-45.056C382.976 312.32 409.6 247.808 409.6 204.8H0V102.4h256V0h102.4v102.4h256v102.4H512c0 70.144-37.888 161.28-87.04 210.944L378.88 460.8zM576 870.4 512 1024H409.6l256-614.4H768l256 614.4H921.6l-64-153.6H576zM618.496 768h196.608L716.8 532.48 618.496 768z"></path></svg><!--]--><span class="arrow"></span><ul class="vp-dropdown"><li class="vp-dropdown-item"><a class="route-link auto-link" href="/UserGuide/latest-Table/Reference/System-Tables_apache.html" aria-label="English"><!---->English<!----></a></li><li class="vp-dropdown-item"><a class="route-link route-link-active auto-link" href="/zh/UserGuide/latest-Table/Reference/System-Tables_apache.html" aria-label="简体中文"><!---->简体中文<!----></a></li></ul></button></div></div><div class="vp-nav-item hide-in-mobile"><button type="button" class="vp-color-mode-switch" id="color-mode-switch"><svg xmlns="http://www.w3.org/2000/svg" class="icon auto-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="auto icon" name="auto" style="display:none;"><path d="M512 992C246.92 992 32 777.08 32 512S246.92 32 512 32s480 214.92 480 480-214.92 480-480 480zm0-840c-198.78 0-360 161.22-360 360 0 198.84 161.22 360 360 360s360-161.16 360-360c0-198.78-161.22-360-360-360zm0 660V212c165.72 0 300 134.34 300 300 0 165.72-134.28 300-300 300z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" class="icon dark-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="dark icon" name="dark" style="display:none;"><path d="M524.8 938.667h-4.267a439.893 439.893 0 0 1-313.173-134.4 446.293 446.293 0 0 1-11.093-597.334A432.213 432.213 0 0 1 366.933 90.027a42.667 42.667 0 0 1 45.227 9.386 42.667 42.667 0 0 1 10.24 42.667 358.4 358.4 0 0 0 82.773 375.893 361.387 361.387 0 0 0 376.747 82.774 42.667 42.667 0 0 1 54.187 55.04 433.493 433.493 0 0 1-99.84 154.88 438.613 438.613 0 0 1-311.467 128z"></path></svg><svg xmlns="http://www.w3.org/2000/svg" class="icon light-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="light icon" name="light" style="display:block;"><path d="M952 552h-80a40 40 0 0 1 0-80h80a40 40 0 0 1 0 80zM801.88 280.08a41 41 0 0 1-57.96-57.96l57.96-58a41.04 41.04 0 0 1 58 58l-58 57.96zM512 752a240 240 0 1 1 0-480 240 240 0 0 1 0 480zm0-560a40 40 0 0 1-40-40V72a40 40 0 0 1 80 0v80a40 40 0 0 1-40 40zm-289.88 88.08-58-57.96a41.04 41.04 0 0 1 58-58l57.96 58a41 41 0 0 1-57.96 57.96zM192 512a40 40 0 0 1-40 40H72a40 40 0 0 1 0-80h80a40 40 0 0 1 40 40zm30.12 231.92a41 41 0 0 1 57.96 57.96l-57.96 58a41.04 41.04 0 0 1-58-58l58-57.96zM512 832a40 40 0 0 1 40 40v80a40 40 0 0 1-80 0v-80a40 40 0 0 1 40-40zm289.88-88.08 58 57.96a41.04 41.04 0 0 1-58 58l-57.96-58a41 41 0 0 1 57.96-57.96z"></path></svg></button></div><div class="vp-nav-item vp-action"><a class="vp-action-link" href="https://github.com/apache/iotdb" target="_blank" rel="noopener noreferrer" aria-label="GitHub"><svg xmlns="http://www.w3.org/2000/svg" class="icon github-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="github icon" name="github" style="width:1.25rem;height:1.25rem;vertical-align:middle;"><path d="M511.957 21.333C241.024 21.333 21.333 240.981 21.333 512c0 216.832 140.544 400.725 335.574 465.664 24.49 4.395 32.256-10.07 32.256-23.083 0-11.69.256-44.245 0-85.205-136.448 29.61-164.736-64.64-164.736-64.64-22.315-56.704-54.4-71.765-54.4-71.765-44.587-30.464 3.285-29.824 3.285-29.824 49.195 3.413 75.179 50.517 75.179 50.517 43.776 75.008 114.816 53.333 142.762 40.79 4.523-31.66 17.152-53.377 31.19-65.537-108.971-12.458-223.488-54.485-223.488-242.602 0-53.547 19.114-97.323 50.517-131.67-5.035-12.33-21.93-62.293 4.779-129.834 0 0 41.258-13.184 134.912 50.346a469.803 469.803 0 0 1 122.88-16.554c41.642.213 83.626 5.632 122.88 16.554 93.653-63.488 134.784-50.346 134.784-50.346 26.752 67.541 9.898 117.504 4.864 129.834 31.402 34.347 50.474 78.123 50.474 131.67 0 188.586-114.73 230.016-224.042 242.09 17.578 15.232 33.578 44.672 33.578 90.454v135.85c0 13.142 7.936 27.606 32.854 22.87C862.25 912.597 1002.667 728.747 1002.667 512c0-271.019-219.648-490.667-490.71-490.667z"></path></svg></a></div><!--]--><button type="button" class="vp-toggle-navbar-button" aria-label="Toggle Navbar" aria-expanded="false" aria-controls="nav-screen"><span><span class="vp-top"></span><span class="vp-middle"></span><span class="vp-bottom"></span></span></button></div></header><!----><!--]--><!----><div class="toggle-sidebar-wrapper"><span class="arrow start"></span></div><aside id="sidebar" class="vp-sidebar" vp-sidebar><!--[--><p class="vp-sidebar-header iotdb-sidebar-header"><span class="vp-sidebar-title">IoTDB用户手册(V2.0.x)</span></p><div class="sidebar-top-wrapper"><ul class="switch-list"><li class="switch-type">树模型</li><li class="switch-type switch-active">表模型</li></ul><div class="help-icon-wrapper"><div class="help-icon"><span>模型说明</span></div></div></div><!--]--><ul class="vp-sidebar-links"><li><section class="vp-sidebar-group"><p class="vp-sidebar-header"><!----><span class="vp-sidebar-title">IoTDB用户手册(V2.0.x)</span><!----></p><ul class="vp-sidebar-links"></ul></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">关于IoTDB</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">预备知识</span><span class="vp-arrow end"></span></button><!----></section></li><li><a class="route-link auto-link vp-sidebar-link" href="/zh/UserGuide/latest-Table/QuickStart/QuickStart_apache.html" aria-label="快速上手"><!---->快速上手<!----></a></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">安装部署</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">基础功能</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">高级功能</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">AI 能力</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">工具体系</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">应用编程接口</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">生态集成</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">SQL手册</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">技术内幕</span><span class="vp-arrow end"></span></button><!----></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable active" type="button"><!----><span class="vp-sidebar-title">附录</span><span class="vp-arrow down"></span></button><ul class="vp-sidebar-links"><li><a class="route-link auto-link vp-sidebar-link" href="/zh/UserGuide/latest-Table/Reference/Sample-Data.html" aria-label="示例数据"><!---->示例数据<!----></a></li><li><a class="route-link auto-link vp-sidebar-link" href="/zh/UserGuide/latest-Table/Reference/System-Config-Manual_apache.html" aria-label="配置参数"><!---->配置参数<!----></a></li><li><a class="route-link auto-link vp-sidebar-link" href="/zh/UserGuide/latest-Table/Reference/Status-Codes.html" aria-label="状态码"><!---->状态码<!----></a></li><li><a class="route-link route-link-active auto-link vp-sidebar-link active" href="/zh/UserGuide/latest-Table/Reference/System-Tables_apache.html" aria-label="系统表"><!---->系统表<!----></a></li></ul></section></li><li><section class="vp-sidebar-group"><button class="vp-sidebar-header clickable" type="button"><!----><span class="vp-sidebar-title">FAQ</span><span class="vp-arrow end"></span></button><!----></section></li></ul><!----></aside><!--[--><main id="main-content" class="vp-page"><!--[--><!----><!----><nav class="vp-breadcrumb disable"></nav><div class="vp-page-title"><h1><!---->系统表</h1><div class="page-info"><!----><!----><span class="page-date-info" aria-label="写作日期📅" data-balloon-pos="up"><svg xmlns="http://www.w3.org/2000/svg" class="icon calendar-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="calendar icon" name="calendar"><path d="M716.4 110.137c0-18.753-14.72-33.473-33.472-33.473-18.753 0-33.473 14.72-33.473 33.473v33.473h66.993v-33.473zm-334.87 0c0-18.753-14.72-33.473-33.473-33.473s-33.52 14.72-33.52 33.473v33.473h66.993v-33.473zm468.81 33.52H716.4v100.465c0 18.753-14.72 33.473-33.472 33.473a33.145 33.145 0 01-33.473-33.473V143.657H381.53v100.465c0 18.753-14.72 33.473-33.473 33.473a33.145 33.145 0 01-33.473-33.473V143.657H180.6A134.314 134.314 0 0046.66 277.595v535.756A134.314 134.314 0 00180.6 947.289h669.74a134.36 134.36 0 00133.94-133.938V277.595a134.314 134.314 0 00-133.94-133.938zm33.473 267.877H147.126a33.145 33.145 0 01-33.473-33.473c0-18.752 14.72-33.473 33.473-33.473h736.687c18.752 0 33.472 14.72 33.472 33.473a33.145 33.145 0 01-33.472 33.473z"></path></svg><span data-allow-mismatch="text">2025/4/3</span><meta property="datePublished" content="2025-04-03T09:30:44.000Z"></span><!----><span class="page-reading-time-info" aria-label="阅读时间⌛" data-balloon-pos="up"><svg xmlns="http://www.w3.org/2000/svg" class="icon timer-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="timer icon" name="timer"><path d="M799.387 122.15c4.402-2.978 7.38-7.897 7.38-13.463v-1.165c0-8.933-7.38-16.312-16.312-16.312H256.33c-8.933 0-16.311 7.38-16.311 16.312v1.165c0 5.825 2.977 10.874 7.637 13.592 4.143 194.44 97.22 354.963 220.201 392.763-122.204 37.542-214.893 196.511-220.2 389.397-4.661 5.049-7.638 11.651-7.638 19.03v5.825h566.49v-5.825c0-7.379-2.849-13.981-7.509-18.9-5.049-193.016-97.867-351.985-220.2-389.527 123.24-37.67 216.446-198.453 220.588-392.892zM531.16 450.445v352.632c117.674 1.553 211.787 40.778 211.787 88.676H304.097c0-48.286 95.149-87.382 213.728-88.676V450.445c-93.077-3.107-167.901-81.297-167.901-177.093 0-8.803 6.99-15.793 15.793-15.793 8.803 0 15.794 6.99 15.794 15.793 0 80.261 63.69 145.635 142.01 145.635s142.011-65.374 142.011-145.635c0-8.803 6.99-15.793 15.794-15.793s15.793 6.99 15.793 15.793c0 95.019-73.789 172.82-165.96 177.093z"></path></svg><span>大约 14 分钟</span><meta property="timeRequired" content="PT14M"></span><!----><!----></div><hr></div><!----><div class="" vp-content><!----><div id="markdown-content"><h1 id="系统表" tabindex="-1"><a class="header-anchor" href="#系统表"><span>系统表</span></a></h1><p>IoTDB 内置系统数据库 <code>INFORMATION_SCHEMA</code>，其中包含一系列系统表，用于存储 IoTDB 运行时信息（如当前正在执行的 SQL 语句等）。目前<code>INFORMATION_SCHEMA</code>数据库只支持读操作。</p><h2 id="_1-系统库" tabindex="-1"><a class="header-anchor" href="#_1-系统库"><span>1. 系统库</span></a></h2><ul><li>名称：<code>INFORMATION_SCHEMA</code></li><li>指令：只读，只支持 <code>Show databases (DETAILS) </code>​<code>/ Show Tables (DETAILS) / Use</code>，其余操作将会报错：<code>&quot;The database &#39;information_schema&#39; can only be queried&quot;</code></li><li>属性：<code>TTL=INF</code>，其余属性默认为<code>null</code></li><li>SQL示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> show databases</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+-------+-----------------------+---------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">Database</span><span style="color:#ABB2BF;">|TTL(ms)|SchemaReplicationFactor|DataReplicationFactor|TimePartitionInterval|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+-------+-----------------------+---------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| INF| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+-------+-----------------------+---------------------+---------------------+</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> show tables </span><span style="color:#C678DD;">from</span><span style="color:#ABB2BF;"> information_schema</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| TableName|TTL(ms)|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| columns| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| config_nodes| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| configurations| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| connections| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| current_queries| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| data_nodes| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| databases| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| functions| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| keywords| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| nodes| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| pipe_plugins| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| pipes| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| queries| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">|queries_costs_histogram| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| regions| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| services| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| subscriptions| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| table_disk_usage| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| tables| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| topics| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">| views| INF|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-------+</span></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 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 class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h2 id="_2-系统表" tabindex="-1"><a class="header-anchor" href="#_2-系统表"><span>2. 系统表</span></a></h2><ul><li>名称：<code>DATABASES</code>, <code>TABLES</code>, <code>REGIONS</code>, <code>QUERIES</code>, <code>COLUMNS</code>, <code>PIPES</code>, <code>PIPE_PLUGINS</code>, <code>SUBSCRIPTION</code>, <code>TOPICS</code>, <code>VIEWS</code>, <code>MODELS</code>, <code>FUNCTIONS</code>, <code>CONFIGURATIONS</code>, <code>KEYWORDS</code>, <code>NODES</code>, <code>CONFIG_NODES</code>, <code>DATA_NODES</code>, <code>CONNECTIONS</code>, <code>CURRENT_QUERIES</code>, <code>QUERIES_COSTS_HISTOGRAM</code>、<code>SERVICES</code>、<code>TABLE_DISK_USAGE</code>（详细介绍见后面小节）</li><li>操作：只读，只支持<code>SELECT</code>, <code>COUNT/SHOW DEVICES</code>, <code>DESC</code>，不支持对于表结构 / 内容的任意修改，如果修改将会报错：<code>&quot;The database &#39;information_schema&#39; can only be queried&quot;</code></li><li>列名：系统表的列名均默认为小写，且用<code>_</code>分隔</li></ul><h3 id="_2-1-databases-表" tabindex="-1"><a class="header-anchor" href="#_2-1-databases-表"><span>2.1 DATABASES 表</span></a></h3><ul><li>包含集群中所有数据库的信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>database</td><td>STRING</td><td>TAG</td><td>数据库名称</td></tr><tr><td>ttl(ms)</td><td>STRING</td><td>ATTRIBUTE</td><td>数据保留时间</td></tr><tr><td>schema_replication_factor</td><td>INT32</td><td>ATTRIBUTE</td><td>元数据副本数</td></tr><tr><td>data_replication_factor</td><td>INT32</td><td>ATTRIBUTE</td><td>数据副本数</td></tr><tr><td>time_partition_interval</td><td>INT64</td><td>ATTRIBUTE</td><td>时间分区间隔</td></tr><tr><td>schema_region_group_num</td><td>INT32</td><td>ATTRIBUTE</td><td>元数据分区数量</td></tr><tr><td>data_region_group_num</td><td>INT32</td><td>ATTRIBUTE</td><td>数据分区数量</td></tr></tbody></table><ul><li>查询结果只展示自身对该数据库本身或库中任意表有任意权限的数据库集合</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">databases</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+-------+-------------------------+-----------------------+-----------------------+-----------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">database</span><span style="color:#ABB2BF;">|ttl(ms)|schema_replication_factor|data_replication_factor|time_partition_interval|schema_region_group_num|data_region_group_num|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+-------+-------------------------+-----------------------+-----------------------+-----------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| INF| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| database1| INF| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">604800000</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+-------+-------------------------+-----------------------+-----------------------+-----------------------+---------------------+</span></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></div><h3 id="_2-2-tables-表" tabindex="-1"><a class="header-anchor" href="#_2-2-tables-表"><span>2.2 TABLES 表</span></a></h3><ul><li>包含集群中所有表的信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>database</td><td>STRING</td><td>TAG</td><td>数据库名称</td></tr><tr><td>table_name</td><td>STRING</td><td>TAG</td><td>表名称</td></tr><tr><td>ttl(ms)</td><td>STRING</td><td>ATTRIBUTE</td><td>数据保留时间</td></tr><tr><td>status</td><td>STRING</td><td>ATTRIBUTE</td><td>状态</td></tr><tr><td>comment</td><td>STRING</td><td>ATTRIBUTE</td><td>注释</td></tr></tbody></table><ul><li>说明：status 可能为<code>USING</code>/<code>PRE_CREATE</code>/<code>PRE_DELETE</code>，具体见表管理中<a class="route-link" href="/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.html#_12-%E6%9F%A5%E7%9C%8B%E8%A1%A8">查看表</a>的相关描述</li><li>查询结果只展示自身有任意权限的表集合</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">tables</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+--------------+-----------+------+-------+-----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">database</span><span style="color:#ABB2BF;">| table_name| ttl(ms)|</span><span style="color:#C678DD;">status</span><span style="color:#ABB2BF;">|comment| table_type|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+--------------+-----------+------+-------+-----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| databases| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| models| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| subscriptions| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| regions| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| functions| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| keywords| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| columns| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| topics| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema|configurations| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| queries| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| tables| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| pipe_plugins| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| nodes| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| data_nodes| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| pipes| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| views| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">|information_schema| config_nodes| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">SYSTEM</span><span style="color:#ABB2BF;"> VIEW|</span></span>
<span class="line"><span style="color:#ABB2BF;">| database1| table1|</span><span style="color:#D19A66;">31536000000</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">| BASE </span><span style="color:#C678DD;">TABLE</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------------+--------------+-----------+------+-------+-----------+</span></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 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><h3 id="_2-3-regions-表" tabindex="-1"><a class="header-anchor" href="#_2-3-regions-表"><span>2.3 REGIONS 表</span></a></h3><ul><li>包含集群中所有<code>Region</code>的信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>region_id</td><td>INT32</td><td>TAG</td><td>region ID</td></tr><tr><td>datanode_id</td><td>INT32</td><td>TAG</td><td>dataNode ID</td></tr><tr><td>type</td><td>STRING</td><td>ATTRIBUTE</td><td>类型（SchemaRegion / DataRegion）</td></tr><tr><td>status</td><td>STRING</td><td>ATTRIBUTE</td><td>状态（Running/Unknown 等）</td></tr><tr><td>database</td><td>STRING</td><td>ATTRIBUTE</td><td>database 名字</td></tr><tr><td>series_slot_num</td><td>INT32</td><td>ATTRIBUTE</td><td>series slot 个数</td></tr><tr><td>time_slot_num</td><td>INT64</td><td>ATTRIBUTE</td><td>time slot 个数</td></tr><tr><td>rpc_address</td><td>STRING</td><td>ATTRIBUTE</td><td>Rpc 地址</td></tr><tr><td>rpc_port</td><td>INT32</td><td>ATTRIBUTE</td><td>Rpc 端口</td></tr><tr><td>internal_address</td><td>STRING</td><td>ATTRIBUTE</td><td>内部通讯地址</td></tr><tr><td>role</td><td>STRING</td><td>ATTRIBUTE</td><td>Leader / Follower</td></tr><tr><td>create_time</td><td>TIMESTAMP</td><td>ATTRIBUTE</td><td>创建时间</td></tr><tr><td>tsfile_size_bytes</td><td>INT64</td><td>ATTRIBUTE</td><td>可统计的 DataRegion：含有 TsFile 的总文件大小；不可统计的 DataRegion（Unknown）：-1；SchemaRegion：null；</td></tr></tbody></table><ul><li>仅管理员可执行查询操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">regions</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-----------+------------+-------+---------+---------------+-------------+-----------+--------+----------------+------+-----------------------------+-----------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|region_id|datanode_id| </span><span style="color:#C678DD;">type</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">status</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">database</span><span style="color:#ABB2BF;">|series_slot_num|time_slot_num|rpc_address|rpc_port|internal_address| </span><span style="color:#C678DD;">role</span><span style="color:#ABB2BF;">| create_time|tsfile_size_bytes|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-----------+------------+-------+---------+---------------+-------------+-----------+--------+----------------+------+-----------------------------+-----------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|SchemaRegion|Running|database1| </span><span style="color:#D19A66;">12</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">6667</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">127</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|Leader|</span><span style="color:#D19A66;">2025</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">03</span><span style="color:#ABB2BF;">-31T11:</span><span style="color:#D19A66;">19</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">485</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| DataRegion|Running|database1| </span><span style="color:#D19A66;">6</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">6</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">6667</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">127</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|Leader|</span><span style="color:#D19A66;">2025</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">03</span><span style="color:#ABB2BF;">-31T11:</span><span style="color:#D19A66;">19</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">09</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">156</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">3985</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| DataRegion|Running|database1| </span><span style="color:#D19A66;">6</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">6</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">6667</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">127</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|Leader|</span><span style="color:#D19A66;">2025</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">03</span><span style="color:#ABB2BF;">-31T11:</span><span style="color:#D19A66;">19</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">09</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">156</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">3841</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-----------+------------+-------+---------+---------------+-------------+-----------+--------+----------------+------+-----------------------------+-----------------+</span></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></div><h3 id="_2-4-queries-表" tabindex="-1"><a class="header-anchor" href="#_2-4-queries-表"><span>2.4 QUERIES 表</span></a></h3><ul><li>包含集群中所有正在执行的查询的信息。也可以使用 <code>SHOW QUERIES</code>语法去查询。</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>query_id</td><td>STRING</td><td>TAG</td><td>ID</td></tr><tr><td>start_time</td><td>TIMESTAMP</td><td>ATTRIBUTE</td><td>查询开始的时间戳，时间戳精度与系统精度保持一致</td></tr><tr><td>datanode_id</td><td>INT32</td><td>ATTRIBUTE</td><td>发起查询的DataNode ID</td></tr><tr><td>elapsed_time</td><td>FLOAT</td><td>ATTRIBUTE</td><td>查询执行耗时，单位是秒</td></tr><tr><td>statement</td><td>STRING</td><td>ATTRIBUTE</td><td>查询sql</td></tr><tr><td>user</td><td>STRING</td><td>ATTRIBUTE</td><td>发起查询的用户</td></tr></tbody></table><ul><li>普通用户查询结果仅显示自身执行的查询；管理员显示全部。</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">queries</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+</span></span>
<span class="line"><span style="color:#ABB2BF;">| query_id| start_time|datanode_id|elapsed_time| </span><span style="color:#C678DD;">statement</span><span style="color:#ABB2BF;">|user|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+</span></span>
<span class="line"><span style="color:#ABB2BF;">|20250331_023242_00011_1|</span><span style="color:#D19A66;">2025</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">03</span><span style="color:#ABB2BF;">-31T10:</span><span style="color:#D19A66;">32</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">42</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">360</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">025</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">queries</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">root</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-----------------------------+-----------+------------+----------------------------------------+----+</span></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></div><h3 id="_2-5-columns-表" tabindex="-1"><a class="header-anchor" href="#_2-5-columns-表"><span>2.5 COLUMNS 表</span></a></h3><ul><li>包含集群中所有表中列的信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>database</td><td>STRING</td><td>TAG</td><td>数据库名称</td></tr><tr><td>table_name</td><td>STRING</td><td>TAG</td><td>表名称</td></tr><tr><td>column_name</td><td>STRING</td><td>TAG</td><td>列名称</td></tr><tr><td>datatype</td><td>STRING</td><td>ATTRIBUTE</td><td>列的数值类型</td></tr><tr><td>category</td><td>STRING</td><td>ATTRIBUTE</td><td>列类型</td></tr><tr><td>status</td><td>STRING</td><td>ATTRIBUTE</td><td>列状态</td></tr><tr><td>comment</td><td>STRING</td><td>ATTRIBUTE</td><td>列注释</td></tr></tbody></table><p>说明：</p><ul><li>status 可能为<code>USING</code>/<code>PRE_DELETE</code>，具体见表管理中<a class="route-link" href="/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.html#_13-%E6%9F%A5%E7%9C%8B%E8%A1%A8%E7%9A%84%E5%88%97">查看表的列</a>的相关描述</li><li>查询结果只展示自身有任意权限的表的列信息</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">columns</span><span style="color:#C678DD;"> where</span><span style="color:#C678DD;"> database</span><span style="color:#56B6C2;"> =</span><span style="color:#98C379;"> &#39;database1&#39;</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+----------+------------+---------+---------+------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">database</span><span style="color:#ABB2BF;">|table_name| column_name| datatype| category|</span><span style="color:#C678DD;">status</span><span style="color:#ABB2BF;">|comment|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+----------+------------+---------+---------+------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| </span><span style="color:#C678DD;">time</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">TIMESTAMP</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">TIME</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| region| STRING| TAG| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| plant_id| STRING| TAG| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| device_id| STRING| TAG| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| model_id| STRING|ATTRIBUTE| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| maintenance| STRING|ATTRIBUTE| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| temperature| </span><span style="color:#C678DD;">FLOAT</span><span style="color:#ABB2BF;">| FIELD| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| humidity| </span><span style="color:#C678DD;">FLOAT</span><span style="color:#ABB2BF;">| FIELD| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1| </span><span style="color:#C678DD;">status</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">BOOLEAN</span><span style="color:#ABB2BF;">| FIELD| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| table1|arrival_time|</span><span style="color:#C678DD;">TIMESTAMP</span><span style="color:#ABB2BF;">| FIELD| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+----------+------------+---------+---------+------+-------+</span></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><h3 id="_2-6-pipes-表" tabindex="-1"><a class="header-anchor" href="#_2-6-pipes-表"><span>2.6 PIPES 表</span></a></h3><ul><li>包含集群中所有 PIPE 的信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>id</td><td>STRING</td><td>TAG</td><td>Pipe 名称</td></tr><tr><td>creation_time</td><td>TIMESTAMP</td><td>ATTRIBUTE</td><td>创建时间</td></tr><tr><td>state</td><td>STRING</td><td>ATTRIBUTE</td><td>Pipe 状态（RUNNING/STOPPED）</td></tr><tr><td>pipe_source</td><td>STRING</td><td>ATTRIBUTE</td><td>source 插件参数</td></tr><tr><td>pipe_processor</td><td>STRING</td><td>ATTRIBUTE</td><td>processor 插件参数</td></tr><tr><td>pipe_sink</td><td>STRING</td><td>ATTRIBUTE</td><td>source 插件参数</td></tr><tr><td>exception_message</td><td>STRING</td><td>ATTRIBUTE</td><td>Exception 信息</td></tr><tr><td>remaining_event_count</td><td>INT64</td><td>ATTRIBUTE</td><td>剩余 event 数量，如果 Unknown 则为 -1</td></tr><tr><td>estimated_remaining_seconds</td><td>DOUBLE</td><td>ATTRIBUTE</td><td>预估剩余时间，如果 Unknown 则为 -1</td></tr></tbody></table><ul><li>仅管理员可执行操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">pipes</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+-----------------------------+-------+--------------------------------------------------------------------------+--------------+-----------------------------------------------------------------------+-----------------+---------------------+---------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| id| creation_time| </span><span style="color:#C678DD;">state</span><span style="color:#ABB2BF;">| pipe_source|pipe_processor| pipe_sink|exception_message|remaining_event_count|estimated_remaining_seconds|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+-----------------------------+-------+--------------------------------------------------------------------------+--------------+-----------------------------------------------------------------------+-----------------+---------------------+---------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|tablepipe1|</span><span style="color:#D19A66;">2025</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">03</span><span style="color:#ABB2BF;">-31T12:</span><span style="color:#D19A66;">25</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">24</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">040</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|RUNNING|{</span><span style="color:#D19A66;">__system</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">sql</span><span style="color:#ABB2BF;">-dialect</span><span style="color:#56B6C2;">=</span><span style="color:#C678DD;">table</span><span style="color:#ABB2BF;">, </span><span style="color:#D19A66;">source</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">password</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">******, </span><span style="color:#D19A66;">source</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">username</span><span style="color:#56B6C2;">=</span><span style="color:#C678DD;">root</span><span style="color:#ABB2BF;">}| {}|{format</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">hybrid, node-urls</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">192</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">168</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">xxx</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">xxx</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">6667</span><span style="color:#ABB2BF;">, sink</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">iotdb-thrift-sink}| | </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+-----------------------------+-------+--------------------------------------------------------------------------+--------------+-----------------------------------------------------------------------+-----------------+---------------------+---------------------------+</span></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></div><h3 id="_2-7-pipe-plugins-表" tabindex="-1"><a class="header-anchor" href="#_2-7-pipe-plugins-表"><span>2.7 PIPE_PLUGINS 表</span></a></h3><ul><li>包含集群中所有PIPE插件的信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>plugin_name</td><td>STRING</td><td>TAG</td><td>插件名称</td></tr><tr><td>plugin_type</td><td>STRING</td><td>ATTRIBUTE</td><td>插件类型（Builtin/External）</td></tr><tr><td>class_name</td><td>STRING</td><td>ATTRIBUTE</td><td>插件的主类名</td></tr><tr><td>plugin_jar</td><td>STRING</td><td>ATTRIBUTE</td><td>插件的 jar 包名称，若为 builtin 类型则为 null</td></tr></tbody></table><ul><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">pipe_plugins</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+-----------+-------------------------------------------------------------------------------------------------+----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| plugin_name|plugin_type| class_name|plugin_jar|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+-----------+-------------------------------------------------------------------------------------------------+----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|IOTDB-THRIFT-</span><span style="color:#C678DD;">SSL</span><span style="color:#ABB2BF;">-SINK| Builtin|</span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">commons</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">pipe</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">agent</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">plugin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">builtin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">connector</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">thrift</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">IoTDBThriftSslConnector</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| IOTDB-AIR-GAP-SINK| Builtin| </span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">commons</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">pipe</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">agent</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">plugin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">builtin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">connector</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">airgap</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">IoTDBAirGapConnector</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| DO-NOTHING-SINK| Builtin| </span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">commons</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">pipe</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">agent</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">plugin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">builtin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">connector</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">donothing</span><span style="color:#ABB2BF;">.DoNothingConnector| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| DO-NOTHING-PROCESSOR| Builtin| </span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">commons</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">pipe</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">agent</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">plugin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">builtin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">processor</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">donothing</span><span style="color:#ABB2BF;">.DoNothingProcessor| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| IOTDB-THRIFT-SINK| Builtin| </span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">commons</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">pipe</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">agent</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">plugin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">builtin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">connector</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">thrift</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">IoTDBThriftConnector</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| IOTDB-SOURCE| Builtin| </span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">commons</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">pipe</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">agent</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">plugin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">builtin</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">extractor</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.IoTDBExtractor| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+-----------+-------------------------------------------------------------------------------------------------+----------+</span></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></div><h3 id="_2-8-subscriptions-表" tabindex="-1"><a class="header-anchor" href="#_2-8-subscriptions-表"><span>2.8 SUBSCRIPTIONS 表</span></a></h3><ul><li>包含集群中所有数据订阅的信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>topic_name</td><td>STRING</td><td>TAG</td><td>订阅主题名称</td></tr><tr><td>consumer_group_name</td><td>STRING</td><td>TAG</td><td>消费者组名称</td></tr><tr><td>subscribed_consumers</td><td>STRING</td><td>ATTRIBUTE</td><td>订阅的消费者</td></tr></tbody></table><ul><li>仅管理员可执行操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">subscriptions</span><span style="color:#C678DD;"> where</span><span style="color:#ABB2BF;"> topic_name </span><span style="color:#56B6C2;">=</span><span style="color:#98C379;"> &#39;topic_1&#39;</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+-------------------+--------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|topic_name|consumer_group_name| subscribed_consumers|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+-------------------+--------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| topic_1| cg1|</span><span style="color:#E06C75;">[c3, c4, c5, c6, c7, c0, c1, c2]</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+-------------------+--------------------------------+</span></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></div><h3 id="_2-9-topics-表" tabindex="-1"><a class="header-anchor" href="#_2-9-topics-表"><span>2.9 TOPICS 表</span></a></h3><ul><li>包含集群中所有数据订阅主题的信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>topic_name</td><td>STRING</td><td>TAG</td><td>订阅主题名称</td></tr><tr><td>topic_configs</td><td>STRING</td><td>ATTRIBUTE</td><td>订阅主题配置</td></tr></tbody></table><ul><li>仅管理员可执行操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">topics</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+----------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|topic_name| topic_configs|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+----------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| topic|{</span><span style="color:#D19A66;">__system</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">sql</span><span style="color:#ABB2BF;">-dialect</span><span style="color:#56B6C2;">=</span><span style="color:#C678DD;">table</span><span style="color:#ABB2BF;">, </span><span style="color:#C678DD;">start</span><span style="color:#ABB2BF;">-</span><span style="color:#C678DD;">time</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">2025</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">01</span><span style="color:#ABB2BF;">-10T17:</span><span style="color:#D19A66;">05</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">38</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">282</span><span style="color:#ABB2BF;">}|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+----------------------------------------------------------------+</span></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></div><h3 id="_2-10-views-表" tabindex="-1"><a class="header-anchor" href="#_2-10-views-表"><span>2.10 VIEWS 表</span></a></h3><blockquote><p>该系统表从 V 2.0.5 版本开始提供</p></blockquote><ul><li>包含数据库内所有的表视图信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>database</td><td>STRING</td><td>TAG</td><td>数据库名称</td></tr><tr><td>table_name</td><td>STRING</td><td>TAG</td><td>视图名称</td></tr><tr><td>view_definition</td><td>STRING</td><td>ATTRIBUTE</td><td>视图的创建语句</td></tr></tbody></table><ul><li>查询结果只展示自身有任意权限的视图集合</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">views</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+----------+---------------------------------------------------------------------------------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">database</span><span style="color:#ABB2BF;">|table_name| view_definition|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+----------+---------------------------------------------------------------------------------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|database1| ln|</span><span style="color:#C678DD;">CREATE</span><span style="color:#ABB2BF;"> VIEW </span><span style="color:#98C379;">&quot;ln&quot;</span><span style="color:#ABB2BF;"> (</span><span style="color:#98C379;">&quot;device&quot;</span><span style="color:#ABB2BF;"> STRING TAG,</span><span style="color:#98C379;">&quot;model&quot;</span><span style="color:#ABB2BF;"> STRING TAG,</span><span style="color:#98C379;">&quot;status&quot;</span><span style="color:#C678DD;"> BOOLEAN</span><span style="color:#ABB2BF;"> FIELD,</span><span style="color:#98C379;">&quot;hardware&quot;</span><span style="color:#ABB2BF;"> STRING FIELD) </span><span style="color:#C678DD;">WITH</span><span style="color:#ABB2BF;"> (ttl</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&#39;INF&#39;</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">AS</span><span style="color:#D19A66;"> root</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">ln</span><span style="color:#ABB2BF;">.**|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+----------+---------------------------------------------------------------------------------------------------------------------------------------</span></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></div><h3 id="_2-11-models-表" tabindex="-1"><a class="header-anchor" href="#_2-11-models-表"><span>2.11 MODELS 表</span></a></h3><blockquote><p>该系统表从 V 2.0.5 版本开始提供，从V 2.0.8 版本开始不再提供</p></blockquote><ul><li>包含数据库内所有的模型信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>model_id</td><td>STRING</td><td>TAG</td><td>模型名称</td></tr><tr><td>model_type</td><td>STRING</td><td>ATTRIBUTE</td><td>模型类型（预测，异常检测，自定义）</td></tr><tr><td>state</td><td>STRING</td><td>ATTRIBUTE</td><td>模型状态（是否可用）</td></tr><tr><td>configs</td><td>STRING</td><td>ATTRIBUTE</td><td>模型的超参数的 string 格式，与正常的 show 相同</td></tr><tr><td>notes</td><td>STRING</td><td>ATTRIBUTE</td><td>模型注释* 内置 model：Built-in model in IoTDB* 用户的 model：自定义</td></tr></tbody></table><ul><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#7F848E;font-style:italic;">-- 找到类型为内置预测的所有模型</span></span>
<span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">models</span><span style="color:#C678DD;"> where</span><span style="color:#ABB2BF;"> model_type </span><span style="color:#56B6C2;">=</span><span style="color:#98C379;"> &#39;BUILT_IN_FORECAST&#39;</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+-----------------+------+-------+-----------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| model_id| model_type| </span><span style="color:#C678DD;">state</span><span style="color:#ABB2BF;">|configs| notes|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+-----------------+------+-------+-----------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| _STLForecaster|BUILT_IN_FORECAST|ACTIVE| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
<span class="line"><span style="color:#ABB2BF;">| _NaiveForecaster|BUILT_IN_FORECAST|ACTIVE| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
<span class="line"><span style="color:#ABB2BF;">| _ARIMA|BUILT_IN_FORECAST|ACTIVE| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
<span class="line"><span style="color:#ABB2BF;">|_ExponentialSmoothing|BUILT_IN_FORECAST|ACTIVE| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
<span class="line"><span style="color:#ABB2BF;">| _HoltWinters|BUILT_IN_FORECAST|ACTIVE| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
<span class="line"><span style="color:#ABB2BF;">| _sundial|BUILT_IN_FORECAST|ACTIVE| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|Built-</span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> model </span><span style="color:#C678DD;">in</span><span style="color:#ABB2BF;"> IoTDB|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------------+-----------------+------+-------+-----------------------+</span></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></div><h3 id="_2-12-functions-表" tabindex="-1"><a class="header-anchor" href="#_2-12-functions-表"><span>2.12 FUNCTIONS 表</span></a></h3><blockquote><p>该系统表从 V 2.0.5 版本开始提供</p></blockquote><ul><li>包含数据库内所有的函数信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>function_name</td><td>STRING</td><td>TAG</td><td>函数名称</td></tr><tr><td>function_type</td><td>STRING</td><td>ATTRIBUTE</td><td>函数类型（内/外置数值/聚合/表函数）</td></tr><tr><td>class_name(udf)</td><td>STRING</td><td>ATTRIBUTE</td><td>如为 UDF，则为类名，否则为 null（暂定）</td></tr><tr><td>state</td><td>STRING</td><td>ATTRIBUTE</td><td>是否可用</td></tr></tbody></table><ul><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">functions</span><span style="color:#C678DD;"> where</span><span style="color:#ABB2BF;"> function_type</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">&#39;built-in table function&#39;</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">--------------+-----------------------+---------------+---------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|function_table| function_type|class_name(udf)| </span><span style="color:#C678DD;">state</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">--------------+-----------------------+---------------+---------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| CUMULATE|built-</span><span style="color:#C678DD;">in</span><span style="color:#C678DD;"> table</span><span style="color:#C678DD;"> function</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|AVAILABLE|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">SESSION</span><span style="color:#ABB2BF;">|built-</span><span style="color:#C678DD;">in</span><span style="color:#C678DD;"> table</span><span style="color:#C678DD;"> function</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|AVAILABLE|</span></span>
<span class="line"><span style="color:#ABB2BF;">| HOP|built-</span><span style="color:#C678DD;">in</span><span style="color:#C678DD;"> table</span><span style="color:#C678DD;"> function</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|AVAILABLE|</span></span>
<span class="line"><span style="color:#ABB2BF;">| TUMBLE|built-</span><span style="color:#C678DD;">in</span><span style="color:#C678DD;"> table</span><span style="color:#C678DD;"> function</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|AVAILABLE|</span></span>
<span class="line"><span style="color:#ABB2BF;">| FORECAST|built-</span><span style="color:#C678DD;">in</span><span style="color:#C678DD;"> table</span><span style="color:#C678DD;"> function</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|AVAILABLE|</span></span>
<span class="line"><span style="color:#ABB2BF;">| VARIATION|built-</span><span style="color:#C678DD;">in</span><span style="color:#C678DD;"> table</span><span style="color:#C678DD;"> function</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|AVAILABLE|</span></span>
<span class="line"><span style="color:#ABB2BF;">| CAPACITY|built-</span><span style="color:#C678DD;">in</span><span style="color:#C678DD;"> table</span><span style="color:#C678DD;"> function</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|AVAILABLE|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">--------------+-----------------------+---------------+---------+</span></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></div><h3 id="_2-13-configurations表" tabindex="-1"><a class="header-anchor" href="#_2-13-configurations表"><span>2.13 CONFIGURATIONS表</span></a></h3><blockquote><p>该系统表从 V 2.0.5 版本开始提供</p></blockquote><ul><li>包含数据库内所有的属性信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>variable</td><td>STRING</td><td>TAG</td><td>属性名</td></tr><tr><td>value</td><td>STRING</td><td>ATTRIBUTE</td><td>属性值</td></tr></tbody></table><ul><li>仅管理员可执行操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">configurations</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------------------------------+-----------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| variable| </span><span style="color:#C678DD;">value</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------------------------------+-----------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| ClusterName| defaultCluster|</span></span>
<span class="line"><span style="color:#ABB2BF;">| DataReplicationFactor| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| SchemaReplicationFactor| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| DataRegionConsensusProtocolClass| </span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">consensus</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iot</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">IoTConsensus</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|SchemaRegionConsensusProtocolClass| </span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">consensus</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">ratis</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">RatisConsensus</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| ConfigNodeConsensusProtocolClass| </span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">consensus</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">ratis</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">RatisConsensus</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| TimePartitionOrigin| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| TimePartitionInterval| </span><span style="color:#D19A66;">604800000</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| ReadConsistencyLevel| strong|</span></span>
<span class="line"><span style="color:#ABB2BF;">| SchemaRegionPerDataNode| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| DataRegionPerDataNode| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| SeriesSlotNum| </span><span style="color:#D19A66;">1000</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| SeriesSlotExecutorClass|</span><span style="color:#D19A66;">org</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">apache</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">iotdb</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">commons</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">partition</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">executor</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">hash</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">BKDRHashExecutor</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| DiskSpaceWarningThreshold| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">05</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| TimestampPrecision| ms|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------------------------------+-----------------------------------------------------------------+</span></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 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><h3 id="_2-14-keywords-表" tabindex="-1"><a class="header-anchor" href="#_2-14-keywords-表"><span>2.14 KEYWORDS 表</span></a></h3><blockquote><p>该系统表从 V 2.0.5 版本开始提供</p></blockquote><ul><li>包含数据库内所有的关键字信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>word</td><td>STRING</td><td>TAG</td><td>关键字</td></tr><tr><td>reserved</td><td>INT32</td><td>ATTRIBUTE</td><td>是否为保留字，1表示是，0表示否</td></tr></tbody></table><ul><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">keywords</span><span style="color:#C678DD;"> limit</span><span style="color:#D19A66;"> 10</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+--------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| word|reserved|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+--------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">ABSENT</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">ACTIVATION</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| ACTIVATE| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">ADD</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">ADMIN</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">AFTER</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| AINODES| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| ALL| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">ALTER</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| ANALYZE| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+--------+</span></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><h3 id="_2-15-nodes-表" tabindex="-1"><a class="header-anchor" href="#_2-15-nodes-表"><span>2.15 NODES 表</span></a></h3><blockquote><p>该系统表从 V 2.0.5 版本开始提供</p></blockquote><ul><li>包含数据库内所有的节点信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>node_id</td><td>INT32</td><td>TAG</td><td>节点 ID</td></tr><tr><td>node_type</td><td>STRING</td><td>ATTRIBUTE</td><td>节点类型</td></tr><tr><td>status</td><td>STRING</td><td>ATTRIBUTE</td><td>节点状态</td></tr><tr><td>internal_address</td><td>STRING</td><td>ATTRIBUTE</td><td>内部 rpc 地址</td></tr><tr><td>internal_port</td><td>INT32</td><td>ATTRIBUTE</td><td>内部端口</td></tr><tr><td>version</td><td>STRING</td><td>ATTRIBUTE</td><td>版本号</td></tr><tr><td>build_info</td><td>STRING</td><td>ATTRIBUTE</td><td>CommitID</td></tr><tr><td>activate_status（仅企业版）</td><td>STRING</td><td>ATTRIBUTE</td><td>激活状态</td></tr></tbody></table><ul><li>仅管理员可执行操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">nodes</span><span style="color:#ABB2BF;"> </span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+----------+-------+----------------+-------------+-------+----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|node_id| node_type| </span><span style="color:#C678DD;">status</span><span style="color:#ABB2BF;">|internal_address|internal_port|</span><span style="color:#C678DD;">version</span><span style="color:#ABB2BF;">|build_info|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+----------+-------+----------------+-------------+-------+----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|ConfigNode|Running| </span><span style="color:#D19A66;">127</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">10710</span><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">5</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| 58d685e|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| DataNode|Running| </span><span style="color:#D19A66;">127</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">10730</span><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">5</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| 58d685e|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+----------+-------+----------------+-------------+-------+----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+--------+</span></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></div><h3 id="_2-16-config-nodes-表" tabindex="-1"><a class="header-anchor" href="#_2-16-config-nodes-表"><span>2.16 CONFIG_NODES 表</span></a></h3><blockquote><p>该系统表从 V 2.0.5 版本开始提供</p></blockquote><ul><li>包含数据库内所有的配置节点信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>node_id</td><td>INT32</td><td>TAG</td><td>节点 ID</td></tr><tr><td>config_consensus_port</td><td>INT32</td><td>ATTRIBUTE</td><td>configNode 共识端口</td></tr><tr><td>role</td><td>STRING</td><td>ATTRIBUTE</td><td>configNode 节点角色</td></tr></tbody></table><ul><li>仅管理员可执行操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">config_nodes</span><span style="color:#ABB2BF;"> </span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+---------------------+------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|node_id|config_consensus_port| </span><span style="color:#C678DD;">role</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+---------------------+------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">10720</span><span style="color:#ABB2BF;">|Leader|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+---------------------+------+</span></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></div><h3 id="_2-17-data-nodes-表" tabindex="-1"><a class="header-anchor" href="#_2-17-data-nodes-表"><span>2.17 DATA_NODES 表</span></a></h3><blockquote><p>该系统表从 V 2.0.5 版本开始提供</p></blockquote><ul><li>包含数据库内所有的数据节点信息</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>node_id</td><td>INT32</td><td>TAG</td><td>节点 ID</td></tr><tr><td>data_region_num</td><td>INT32</td><td>ATTRIBUTE</td><td>DataRegion 数量</td></tr><tr><td>schema_region_num</td><td>INT32</td><td>ATTRIBUTE</td><td>SchemaRegion 数量</td></tr><tr><td>rpc_address</td><td>STRING</td><td>ATTRIBUTE</td><td>Rpc 地址</td></tr><tr><td>rpc_port</td><td>INT32</td><td>ATTRIBUTE</td><td>Rpc 端口</td></tr><tr><td>mpp_port</td><td>INT32</td><td>ATTRIBUTE</td><td>MPP 通信端口</td></tr><tr><td>data_consensus_port</td><td>INT32</td><td>ATTRIBUTE</td><td>DataRegion 共识端口</td></tr><tr><td>scema_consensus_port</td><td>INT32</td><td>ATTRIBUTE</td><td>SchemaRegion 共识端口</td></tr></tbody></table><ul><li>仅管理员可执行操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">data_nodes</span><span style="color:#ABB2BF;"> </span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+---------------+-----------------+-----------+--------+--------+-------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|node_id|data_region_num|schema_region_num|rpc_address|rpc_port|mpp_port|data_consensus_port|schema_consensus_port|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+---------------+-----------------+-----------+--------+--------+-------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">6667</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">10740</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">10760</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">10750</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-------+---------------+-----------------+-----------+--------+--------+-------------------+---------------------+</span></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></div><h3 id="_2-18-connections-表" tabindex="-1"><a class="header-anchor" href="#_2-18-connections-表"><span>2.18 CONNECTIONS 表</span></a></h3><blockquote><p>该系统表从 V 2.0.8 版本开始提供</p></blockquote><ul><li>包含集群中所有连接。</li><li>表结构如下表所示：</li></ul><table><thead><tr><th><strong>列名</strong></th><th><strong>数据类型</strong></th><th><strong>列类型</strong></th><th><strong>说明</strong></th></tr></thead><tbody><tr><td>datanode_id</td><td>STRING</td><td>TAG</td><td>DataNode的ID</td></tr><tr><td>user_id</td><td>STRING</td><td>TAG</td><td>用户ID</td></tr><tr><td>session_id</td><td>STRING</td><td>TAG</td><td>Session ID</td></tr><tr><td>user_name</td><td>STRING</td><td>ATTRIBUTE</td><td>用户名</td></tr><tr><td>last_active_time</td><td>TIMESTAMP</td><td>ATTRIBUTE</td><td>最近活跃时间</td></tr><tr><td>client_ip</td><td>STRING</td><td>ATTRIBUTE</td><td>客户端IP</td></tr></tbody></table><ul><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">connections</span><span style="color:#ABB2BF;">;</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------+-------+----------+---------+-----------------------------+---------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|datanode_id|user_id|session_id|user_name| last_active_time|client_ip|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------+-------+----------+---------+-----------------------------+---------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">root</span><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">2026</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">01</span><span style="color:#ABB2BF;">-21T16:</span><span style="color:#D19A66;">28</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">54</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">704</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">127</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------+-------+----------+---------+-----------------------------+---------+</span></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></div><h3 id="_2-19-current-queries-表" tabindex="-1"><a class="header-anchor" href="#_2-19-current-queries-表"><span>2.19 CURRENT_QUERIES 表</span></a></h3><blockquote><p>该系统表从 V 2.0.8 版本开始提供</p></blockquote><ul><li>包含所有执行结束时间在 <code>[now() - query_cost_stat_window, now())</code> 范围内的所有查询，也包括当前正在执行的查询。其中<code>query_cost_stat_window </code>代表查询耗时统计的窗口，默认值为 0 ，可通过配置文件<code>iotdb-system.properties</code>进行配置。</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>query_id</td><td>STRING</td><td>TAG</td><td>查询语句的 ID</td></tr><tr><td>state</td><td>STRING</td><td>FIELD</td><td>查询状态，RUNNING 表示正在执行，FINISHED 表示已结束</td></tr><tr><td>start_time</td><td>TIMESTAMP</td><td>FIELD</td><td>查询开始的时间戳，时间戳精度与系统精度保持一致</td></tr><tr><td>end_time</td><td>TIMESTAMP</td><td>FIELD</td><td>查询结束的时间戳，时间戳精度与系统精度保持一致。若查询尚未结束，该列值为 NULL</td></tr><tr><td>datanode_id</td><td>INT32</td><td>FIELD</td><td>该查询语句是从哪个 DataNode 发起的</td></tr><tr><td>cost_time</td><td>FLOAT</td><td>FIELD</td><td>查询的执行耗时，单位是秒。若查询尚未结束，该列值为查询已执行时间</td></tr><tr><td>statement</td><td>STRING</td><td>FIELD</td><td>查询的sql / 查询请求拼接后的 sql</td></tr><tr><td>user</td><td>STRING</td><td>FIELD</td><td>发起查询的用户</td></tr><tr><td>client_ip</td><td>STRING</td><td>FIELD</td><td>发起查询的客户端 ip</td></tr></tbody></table><ul><li>普通用户查询结果仅显示自身执行的查询；管理员显示全部。</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">current_queries</span><span style="color:#ABB2BF;">;</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-------+-----------------------------+--------+-----------+---------+------------------------------------------------+----+---------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| query_id| </span><span style="color:#C678DD;">state</span><span style="color:#ABB2BF;">| start_time|end_time|datanode_id|cost_time| </span><span style="color:#C678DD;">statement</span><span style="color:#ABB2BF;">|user|client_ip|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-------+-----------------------------+--------+-----------+---------+------------------------------------------------+----+---------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|20260121_085427_00013_1|RUNNING|</span><span style="color:#D19A66;">2026</span><span style="color:#ABB2BF;">-</span><span style="color:#D19A66;">01</span><span style="color:#ABB2BF;">-21T16:</span><span style="color:#D19A66;">54</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">27</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">019</span><span style="color:#ABB2BF;">+</span><span style="color:#D19A66;">08</span><span style="color:#ABB2BF;">:</span><span style="color:#D19A66;">00</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">current_queries</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">root</span><span style="color:#ABB2BF;">|</span><span style="color:#D19A66;">127</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">-----------------------+-------+-----------------------------+--------+-----------+---------+------------------------------------------------+----+---------+</span></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></div><h3 id="_2-20-queries-costs-histogram-表" tabindex="-1"><a class="header-anchor" href="#_2-20-queries-costs-histogram-表"><span>2.20 QUERIES_COSTS_HISTOGRAM 表</span></a></h3><blockquote><p>该系统表从 V 2.0.8 版本开始提供</p></blockquote><ul><li>包含过去 <code>query_cost_stat_window</code> 时间内的查询耗时的直方图（仅统计已经执行结束的 SQL），其中<code>query_cost_stat_window </code>代表查询耗时统计的窗口，默认值为 0 ，可通过配置文件<code>iotdb-system.properties</code>进行配置。</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>bin</td><td>STRING</td><td>TAG</td><td>分桶名：共包含61个分桶，[0, 1), [1, 2), [2, 3),...., [59, 60), 60+</td></tr><tr><td>nums</td><td>INT32</td><td>FIELD</td><td>分桶内sql的个数</td></tr><tr><td>datanode_id</td><td>INT32</td><td>FIELD</td><td>该桶属于哪个 DataNode</td></tr></tbody></table><ul><li>仅管理员可执行操作</li><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">queries_costs_histogram</span><span style="color:#C678DD;"> limit</span><span style="color:#D19A66;"> 10</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------+----+-----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| bin|nums|datanode_id|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------+----+-----------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">3</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">3</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">4</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">4</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">5</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">5</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">6</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">6</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">7</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">7</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">8</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| [</span><span style="color:#D19A66;">8</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">9</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|[</span><span style="color:#D19A66;">9</span><span style="color:#ABB2BF;">,</span><span style="color:#D19A66;">10</span><span style="color:#ABB2BF;">)| </span><span style="color:#D19A66;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------+----+-----------+</span></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><h3 id="_2-21-services-表" tabindex="-1"><a class="header-anchor" href="#_2-21-services-表"><span>2.21 SERVICES 表</span></a></h3><blockquote><p>该系统表从 V 2.0.8 版本开始提供</p></blockquote><ul><li>可展示所有正常工作（RUNNING 或 READ-ONLY） DN 上的服务（MQTT 服务、REST 服务）。</li><li>表结构如下表所示：</li></ul><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>service_name</td><td>STRING</td><td>TAG</td><td>服务名称</td></tr><tr><td>datanode_id</td><td>INT32</td><td>ATTRIBUTE</td><td>所在 DataNode 的 ID</td></tr><tr><td>state</td><td>STRING</td><td>ATTRIBUTE</td><td>服务状态： RUNNING / STOPPED</td></tr></tbody></table><ul><li>查询示例：</li></ul><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">services</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------+-----------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">service_name</span><span style="color:#ABB2BF;">|datanode_id| </span><span style="color:#C678DD;">state</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------+-----------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| MQTT| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">STOPPED</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| REST| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">|RUNNING|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">------------+-----------+-------+</span></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></div><h5 id="_2-22-table-disk-usage-表" tabindex="-1"><a class="header-anchor" href="#_2-22-table-disk-usage-表"><span>2.22 TABLE_DISK_USAGE 表</span></a></h5><blockquote><p>该系统表从 V 2.0.9-beta 版本开始提供</p></blockquote><p>用于展示指定表（不包含 view）的磁盘空间占用情况，包括 ChunkGroup 的大小和 Metadata 大小。</p><p>注意：统计基于 TsFile 中数据的真实大小，因此不会考虑 mods 删除的情况。</p><p>表结构如下表所示：</p><table><thead><tr><th>列名</th><th>数据类型</th><th>列类型</th><th>说明</th></tr></thead><tbody><tr><td>database</td><td>string</td><td>Field</td><td>Database 名</td></tr><tr><td>table_name</td><td>string</td><td>Field</td><td>表名</td></tr><tr><td>datanode_id</td><td>int32</td><td>Field</td><td>DataNode 节点 id</td></tr><tr><td>region_id</td><td>int32</td><td>Field</td><td>Region id</td></tr><tr><td>time_partition</td><td>int64</td><td>Field</td><td>时间分区 id</td></tr><tr><td>size_in_bytes</td><td>int64</td><td>Field</td><td>占用磁盘空间(byte)</td></tr></tbody></table><p>查询示例：</p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#7F848E;font-style:italic;">-- 查询所有数据;</span></span>
<span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">table_disk_usage</span><span style="color:#ABB2BF;">;</span></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></div><div class="language-bash line-numbers-mode" data-highlighter="shiki" data-ext="bash" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-bash"><span class="line"><span style="color:#61AFEF;">+---------+-------------------+-----------+---------+--------------+-------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">database</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table_name</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">datanode_id</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">region_id</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">time_partition</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">size_in_bytes</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------+-------------------+-----------+---------+--------------+-------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2864</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">867</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2864</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2864</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2865</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1411</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2865</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2865</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2925</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">590</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2925</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2925</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2864</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">883</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2864</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2864</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2865</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1224</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2865</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2865</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2888</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2888</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table3</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2888</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">205</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">etth</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">tab_cov_forecast</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">8</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">etth</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">tab_real</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">8</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">963</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">etth</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">tab_target_forecast</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">8</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">etth</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">tab_cov_forecast</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">9</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">448</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">etth</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">tab_real</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">9</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">etth</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">tab_target_forecast</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">9</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------+-------------------+-----------+---------+--------------+-------------+</span></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 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><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#7F848E;font-style:italic;">-- 指定查询条件;</span></span>
<span class="line"><span style="color:#C678DD;">select</span><span style="color:#ABB2BF;"> * </span><span style="color:#C678DD;">from</span><span style="color:#D19A66;"> information_schema</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">table_disk_usage</span><span style="color:#C678DD;"> where</span><span style="color:#ABB2BF;"> region_id </span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;"> 4</span><span style="color:#C678DD;"> and</span><span style="color:#ABB2BF;"> table_name </span><span style="color:#C678DD;">like</span><span style="color:#98C379;"> &#39;%1&#39;</span><span style="color:#ABB2BF;">;</span></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></div><div class="language-bash line-numbers-mode" data-highlighter="shiki" data-ext="bash" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-bash"><span class="line"><span style="color:#61AFEF;">+---------+----------+-----------+---------+--------------+-------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">database</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">table_name</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">datanode_id</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">region_id</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">time_partition</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">size_in_bytes</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------+----------+-----------+---------+--------------+-------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2864</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">883</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2864</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2865</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1224</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2865</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2888</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table11</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">4</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2888</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">0</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------+----------+-----------+---------+--------------+-------------+</span></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></div><h2 id="_3-权限说明" tabindex="-1"><a class="header-anchor" href="#_3-权限说明"><span>3. 权限说明</span></a></h2><ul><li>不支持通过<code>GRANT/REVOKE</code>语句对 <code>information_schema</code> 数据库及其下任何表进行权限操作</li><li>支持任意用户通过<code>show databases</code>语句查看<code>information_schema</code>数据库相关信息</li><li>支持任意用户通过<code>show tables from information_schema</code> 语句查看所有系统表相关信息</li><li>支持任意用户通过<code>desc</code>语句查看任意系统表</li></ul></div><!----><!----><!----></div><footer class="vp-page-meta"><div class="vp-meta-item edit-link"><a class="auto-link external-link vp-meta-label" href="https://github.com/apache/iotdb-docs/edit/main/src/zh/UserGuide/latest-Table/Reference/System-Tables_apache.md" aria-label="发现错误？在 GitHub 上编辑此页" rel="noopener noreferrer" target="_blank"><!--[--><svg xmlns="http://www.w3.org/2000/svg" class="icon edit-icon" viewBox="0 0 1024 1024" fill="currentColor" aria-label="edit icon" name="edit"><path d="M430.818 653.65a60.46 60.46 0 0 1-50.96-93.281l71.69-114.012 7.773-10.365L816.038 80.138A60.46 60.46 0 0 1 859.225 62a60.46 60.46 0 0 1 43.186 18.138l43.186 43.186a60.46 60.46 0 0 1 0 86.373L588.879 565.55l-8.637 8.637-117.466 68.234a60.46 60.46 0 0 1-31.958 11.229z"></path><path d="M728.802 962H252.891A190.883 190.883 0 0 1 62.008 771.98V296.934a190.883 190.883 0 0 1 190.883-192.61h267.754a60.46 60.46 0 0 1 0 120.92H252.891a69.962 69.962 0 0 0-69.098 69.099V771.98a69.962 69.962 0 0 0 69.098 69.098h475.911A69.962 69.962 0 0 0 797.9 771.98V503.363a60.46 60.46 0 1 1 120.922 0V771.98A190.883 190.883 0 0 1 728.802 962z"></path></svg><!--]-->发现错误？在 GitHub 上编辑此页<!----></a></div><div class="vp-meta-item git-info"><div class="update-time"><span class="vp-meta-label">最近更新: </span><time class="vp-meta-info" datetime="2026-04-22T04:07:51.000Z" data-allow-mismatch>2026/4/22 04:07</time></div><!----></div></footer><nav class="vp-page-nav"><a class="route-link auto-link prev" href="/zh/UserGuide/latest-Table/Reference/Status-Codes.html" aria-label="状态码"><div class="hint"><span class="arrow start"></span>上一页</div><div class="link"><!---->状态码</div></a><!----></nav><!----><!----><!--]--></main><!--]--><footer class="site-footer"><span id="doc-version" style="display:none;">latest-Table</span><p class="copyright-text">版权所有 © 2026 Apache软件基金会。
Apache IoTDB，IoTDB，Apache，Apache 羽毛标志和 Apache IoTDB 项目标志是 Apache 软件基金会在所有国家的注册商标或商标</p><p style="text-align:center;margin-top:10px;color:#909399;font-size:12px;margin:0 30px;"><strong>有问题吗？</strong> 在 QQ、微信或 Slack 上联系我们。 <a href="https://github.com/apache/iotdb/issues/1995">立即加入社区</a></p></footer></div><!--]--><!--]--><!--[--><!----><!--]--><!--]--></div>
<script type="module" src="/assets/app-C4FS647M.js" defer></script>
</body>
</html>