docs/2.9.0/monitoring-metrics/system-views.html - ignite-website - Git at Google

 <!DOCTYPE html>


 <html lang="en">
 <head>
     <!-- Global site tag (gtag.js) - Google Analytics -->
     <script async src="https://www.googletagmanager.com/gtag/js?id=UA-61232409-1"></script>
     <script>
     window.dataLayer = window.dataLayer || [];
     function gtag(){dataLayer.push(arguments);}
     gtag('js', new Date());

     gtag('config', 'UA-61232409-1');
     </script>


     <meta charset="UTF-8">
     <meta name="ignite-version" content="2.9.0" />
     <title>System Views | Ignite Documentation</title>

     <link rel="canonical" href="/docs/latest/monitoring-metrics/system-views" />


 	<link rel="stylesheet" href="/assets/css/styles.css?1600377059">
     <link rel="stylesheet" href="/assets/css/asciidoc-pygments.css">
     <link rel="shortcut icon" href="/favicon.ico">
     <meta name='viewport' content='width=device-width, height=device-height, initial-scale=1.0, minimum-scale=1.0'>

 	<script type="text/javascript" src="/assets/js/anchor.min.js?1600377059"></script>

   <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/docsearch.js@2/dist/cdn/docsearch.min.css" />


 </head>
 <body>
     <header>
     <!--#include virtual="/includes/promotion_banner.html" -->
     <div class="container">
         <button type='button' class='menu' title='Docs menu'>
         <img src="/assets/images/menu-icon.svg"/>
         </button>
         <div class='home'>
             <a href="/" class='home' title='Apache Ignite home'>
                 <img src="/assets/images/apache_ignite_logo.svg" alt="Apache Ignite logo" width="103" >
             </a>
         </div>

         <nav>

         </nav>

         <select id="version-selector">
             <option value="2.9.0">2.9.0</option>
         </select>

         <a href="https://github.com/apache/ignite" title='GitHub' class='github' target="_blank">
             <img src="/assets/images/github-gray.svg" alt="GitHub logo">
         </a>

         <form class='search'>
             <button class="search-close" type='button'><img src='/assets/images/cancel.svg'></button>
             <input type="search" placeholder="Search…" id="search-input">
         </form>
         <button type='button' class='search-toggle'><img src='/assets/images/search.svg'></button>
         <button type='button' class='top-nav-toggle'>⋮</button>


     </div>
 </header>


     	 <link rel="stylesheet" href="/assets/css/docs.css">
 <section class='page-docs'>


 <nav class='left-nav' data-swiftype-index='false'>


         <li>


             <a href="/docs/latest/preface" class='' >Preface</a>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Quick Start Guides<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/quick-start/java"

                                 class=''
                             >Java</a>

                     </li>


                     <li>

                             <a href="/docs/latest/quick-start/dotnet"

                                 class=''
                             >.NET/C#</a>

                     </li>


                     <li>

                             <a href="/docs/latest/quick-start/cpp"

                                 class=''
                             >C++</a>

                     </li>


                     <li>

                             <a href="/docs/latest/quick-start/python"

                                 class=''
                             >Python</a>

                     </li>


                     <li>

                             <a href="/docs/latest/quick-start/nodejs"

                                 class=''
                             >Node.JS</a>

                     </li>


                     <li>

                             <a href="/docs/latest/quick-start/sql"

                                 class=''
                             >SQL</a>

                     </li>


                     <li>

                             <a href="/docs/latest/quick-start/php"

                                 class=''
                             >PHP</a>

                     </li>


                     <li>

                             <a href="/docs/latest/quick-start/restapi"

                                 class=''
                             >REST API</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="/installation" class='group-toggle collapsed '>Installation<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/installation/installing-using-zip"

                                 class=''
                             >Installing Using ZIP Archive</a>

                     </li>


                     <li>

                             <a href="/docs/latest/installation/installing-using-docker"

                                 class=''
                             >Installing Using Docker</a>

                     </li>


                     <li>

                             <a href="/docs/latest/installation/deb-rpm"

                                 class=''
                             >Installing DEB or RPM package</a>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Kubernetes<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//installation/kubernetes/amazon-eks-deployment" class=''>Amazon EKS</a></li>


 								  <li><a href="/docs/latest//installation/kubernetes/azure-deployment" class=''>Azure Kubernetes Service</a></li>


 								  <li><a href="/docs/latest//installation/kubernetes/gke-deployment" class=''>Google Kubernetes Engine</a></li>

                             </nav>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Setting Up<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/setup"

                                 class=''
                             >Setting Up Ignite for Java</a>

                     </li>


                     <li>

                             <a href="/docs/latest/setup-dotnet"

                                 class=''
                             >Setting Up Ignite for .NET/C#</a>

                     </li>


              </nav>

         </li>

         <li>


             <a href="/docs/latest/understanding-configuration" class='' >Understanding Configuration</a>

         </li>

         <li>


             <a href="/docs/latest/logging" class='' >Configuring Logging</a>

         </li>

         <li>


             <a href="/docs/latest/starting-nodes" class='' >Starting and Stopping Nodes</a>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Clustering<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/clustering/clustering"

                                 class=''
                             >Overview</a>

                     </li>


                     <li>

                             <a href="/docs/latest/clustering/tcp-ip-discovery"

                                 class=''
                             >TCP/IP Discovery</a>

                     </li>


                     <li>

                             <a href="/docs/latest/clustering/zookeeper-discovery"

                                 class=''
                             >ZooKeeper Discovery</a>

                     </li>


                     <li>

                             <a href="/docs/latest/clustering/discovery-in-the-cloud"

                                 class=''
                             >Discovery in the Cloud</a>

                     </li>


                     <li>

                             <a href="/docs/latest/clustering/network-configuration"

                                 class=''
                             >Network Configuration</a>

                     </li>


                     <li>

                             <a href="/docs/latest/clustering/connect-client-nodes"

                                 class=''
                             >Connecting Client Nodes</a>

                     </li>


                     <li>

                             <a href="/docs/latest/clustering/running-client-nodes-behind-nat"

                                 class=''
                             >Running Client Nodes Behind NAT</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Data Modeling<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/data-modeling/data-modeling"

                                 class=''
                             >Introduction</a>

                     </li>


                     <li>

                             <a href="/docs/latest/data-modeling/data-partitioning"

                                 class=''
                             >Data Partitioning</a>

                     </li>


                     <li>

                             <a href="/docs/latest/data-modeling/affinity-collocation"

                                 class=''
                             >Affinity Colocation</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Configuring Memory<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/memory-architecture"

                                 class=''
                             >Memory Architecture</a>

                     </li>


                     <li>

                             <a href="/docs/latest/memory-configuration/data-regions"

                                 class=''
                             >Configuring Data Regions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/memory-configuration/eviction-policies"

                                 class=''
                             >Eviction Policies</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Configuring Caches<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/configuring-caches/configuration-overview"

                                 class=''
                             >Cache Configuration</a>

                     </li>


                     <li>

                             <a href="/docs/latest/configuring-caches/configuring-backups"

                                 class=''
                             >Configuring Partition Backups</a>

                     </li>


                     <li>

                             <a href="/docs/latest/configuring-caches/atomicity-modes"

                                 class=''
                             >Atomicity Modes</a>

                     </li>


                     <li>

                             <a href="/docs/latest/configuring-caches/expiry-policies"

                                 class=''
                             >Expiry Policy</a>

                     </li>


                     <li>

                             <a href="/docs/latest/configuring-caches/on-heap-caching"

                                 class=''
                             >On-Heap Caching</a>

                     </li>


                     <li>

                             <a href="/docs/latest/configuring-caches/cache-groups"

                                 class=''
                             >Cache Groups</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Persistence<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/persistence/native-persistence"

                                 class=''
                             >Ignite Persistence</a>

                     </li>


                     <li>

                             <a href="/docs/latest/persistence/external-storage"

                                 class=''
                             >External Storage</a>

                     </li>


                     <li>

                             <a href="/docs/latest/persistence/swap"

                                 class=''
                             >Swapping</a>

                     </li>


                     <li>

                             <a href="/docs/latest/persistence/custom-cache-store"

                                 class=''
                             >Implementing Custom Cache Store</a>

                     </li>


                     <li>

                             <a href="/docs/latest/persistence/snapshots"

                                 class=''
                             >Cluster Snapshots</a>

                     </li>


                     <li>

                             <a href="/docs/latest/persistence/disk-compression"

                                 class=''
                             >Disk Compression</a>

                     </li>


                     <li>

                             <a href="/docs/latest/persistence/persistence-tuning"

                                 class=''
                             >Tuning Persistence</a>

                     </li>


              </nav>

         </li>

         <li>


             <a href="/docs/latest/baseline-topology" class='' >Baseline Topology</a>

         </li>

         <li>


             <a href="/docs/latest/cluster-states" class='' >Cluster States</a>

         </li>

         <li>


             <a href="/docs/latest/data-rebalancing" class='' >Data Rebalancing</a>

         </li>

         <li>


             <a href="/docs/latest/partition-loss-policy" class='' >Partition Loss Policy</a>

         </li>

         <li>


             <a href="/docs/latest/deploying-user-code" class='' >Deploying User Code</a>

         </li>

         <li>


             <a href="/docs/latest/peer-class-loading" class='' >Peer Class Loading</a>

         </li>

         <li>


             <a href="/docs/latest/data-streaming" class='' >Data Streaming</a>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Using Key-Value Cache API<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/key-value-api/basic-cache-operations"

                                 class=''
                             >Basic Cache Operations</a>

                     </li>


                     <li>

                             <a href="/docs/latest/key-value-api/binary-objects"

                                 class=''
                             >Working with Binary Objects</a>

                     </li>


                     <li>

                             <a href="/docs/latest/key-value-api/using-scan-queries"

                                 class=''
                             >Using Scan Queries</a>

                     </li>


                     <li>

                             <a href="/docs/latest/read-repair"

                                 class=''
                             >Read Repair</a>

                     </li>


              </nav>

         </li>

         <li>


             <a href="/docs/latest/key-value-api/continuous-queries" class='' >Using Continuous Queries</a>

         </li>

         <li>


             <a href="/docs/latest/key-value-api/transactions" class='' >Performing Transactions</a>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Working with SQL<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/SQL/sql-introduction"

                                 class=''
                             >Introduction</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/schemas"

                                 class=''
                             >Understanding Schemas</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/indexes"

                                 class=''
                             >Defining Indexes</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/sql-api"

                                 class=''
                             >Using SQL API</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/distributed-joins"

                                 class=''
                             >Distributed Joins</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/sql-transactions"

                                 class=''
                             >SQL Transactions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/custom-sql-func"

                                 class=''
                             >Custom SQL Functions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/JDBC/jdbc-driver"

                                 class=''
                             >JDBC Driver</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/JDBC/jdbc-client-driver"

                                 class=''
                             >JDBC Client Driver</a>

                     </li>


                     <li>

                             <a href="/docs/latest/transactions/mvcc"

                                 class=''
                             >Multiversion Concurrency Control</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Distributed Computing<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/distributed-computing/distributed-computing"

                                 class=''
                             >Distributed Computing API</a>

                     </li>


                     <li>

                             <a href="/docs/latest/distributed-computing/cluster-groups"

                                 class=''
                             >Cluster Groups</a>

                     </li>


                     <li>

                             <a href="/docs/latest/distributed-computing/executor-service"

                                 class=''
                             >Executor Service</a>

                     </li>


                     <li>

                             <a href="/docs/latest/distributed-computing/map-reduce"

                                 class=''
                             >MapReduce API</a>

                     </li>


                     <li>

                             <a href="/docs/latest/distributed-computing/load-balancing"

                                 class=''
                             >Load Balancing</a>

                     </li>


                     <li>

                             <a href="/docs/latest/distributed-computing/fault-tolerance"

                                 class=''
                             >Fault Tolerance</a>

                     </li>


                     <li>

                             <a href="/docs/latest/distributed-computing/job-scheduling"

                                 class=''
                             >Job Scheduling</a>

                     </li>


              </nav>

         </li>

         <li>


             <a href="/docs/latest/collocated-computations" class='' >Colocating Computations with Data</a>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Working with Events<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/events/listening-to-events"

                                 class=''
                             >Enabling and Listenting to Events</a>

                     </li>


                     <li>

                             <a href="/docs/latest/events/events"

                                 class=''
                             >Events</a>

                     </li>


              </nav>

         </li>

         <li>


             <a href="/docs/latest/near-cache" class='' >Near Caches</a>

         </li>

         <li>


             <a href="/docs/latest/platform-cache" class='' >.NET Platform Cache</a>

         </li>

         <li>


             <a href="/docs/latest/services/services" class='' >Services</a>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Distributed Data Structures<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/data-structures/queue-and-set"

                                 class=''
                             >Queue and Set</a>

                     </li>


                     <li>

                             <a href="/docs/latest/data-structures/atomic-types"

                                 class=''
                             >Atomic Types</a>

                     </li>


                     <li>

                             <a href="/docs/latest/data-structures/countdownlatch"

                                 class=''
                             >CountDownLatch</a>

                     </li>


                     <li>

                             <a href="/docs/latest/data-structures/atomic-sequence"

                                 class=''
                             >Atomic Sequence</a>

                     </li>


                     <li>

                             <a href="/docs/latest/data-structures/semaphore"

                                 class=''
                             >Semaphore</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Machine Learning<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/machine-learning/machine-learning"

                                 class=''
                             >Machine Learning</a>

                     </li>


                     <li>

                             <a href="/docs/latest/machine-learning/partition-based-dataset"

                                 class=''
                             >Partition Based Dataset</a>

                     </li>


                     <li>

                             <a href="/docs/latest/machine-learning/updating-trained-models"

                                 class=''
                             >Updating Trained Models</a>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Binary Classification<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//machine-learning/binary-classification/introduction" class=''>Introduction</a></li>


 								  <li><a href="/docs/latest//machine-learning/binary-classification/linear-svm" class=''>Linear SVM (Support Vector Machine)</a></li>


 								  <li><a href="/docs/latest//machine-learning/binary-classification/decision-trees" class=''>Decision Trees</a></li>


 								  <li><a href="/docs/latest//machine-learning/binary-classification/multilayer-perceptron" class=''>Multilayer Perceptron</a></li>


 								  <li><a href="/docs/latest//machine-learning/binary-classification/logistic-regression" class=''>Logistic Regression</a></li>


 								  <li><a href="/docs/latest//machine-learning/binary-classification/knn-classification" class=''>k-NN Classification</a></li>


 								  <li><a href="/docs/latest//machine-learning/binary-classification/ann" class=''>ANN (Approximate Nearest Neighbor)</a></li>


 								  <li><a href="/docs/latest//machine-learning/binary-classification/naive-bayes" class=''>Naive Bayes</a></li>

                             </nav>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Regression<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//machine-learning/regression/introduction" class=''>Introduction</a></li>


 								  <li><a href="/docs/latest//machine-learning/regression/linear-regression" class=''>Linear Regression</a></li>


 								  <li><a href="/docs/latest//machine-learning/regression/decision-trees-regression" class=''>Decision Trees Regression</a></li>


 								  <li><a href="/docs/latest//machine-learning/regression/knn-regression" class=''>k-NN Regression</a></li>

                             </nav>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Clustering<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//machine-learning/clustering/introduction" class=''>Introduction</a></li>


 								  <li><a href="/docs/latest//machine-learning/clustering/k-means-clustering" class=''>K-Means Clustering</a></li>


 								  <li><a href="/docs/latest//machine-learning/clustering/gaussian-mixture" class=''>Gaussian mixture (GMM)</a></li>

                             </nav>

                     </li>


                     <li>

                             <a href="/docs/latest/machine-learning/preprocessing"

                                 class=''
                             >Preprocessing</a>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Model Selection<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//machine-learning/model-selection/introduction" class=''>Introduction</a></li>


 								  <li><a href="/docs/latest//machine-learning/model-selection/evaluator" class=''>Evaluator</a></li>


 								  <li><a href="/docs/latest//machine-learning/model-selection/split-the-dataset-on-test-and-train-datasets" class=''>Split the dataset on test and train datasets</a></li>


 								  <li><a href="/docs/latest//machine-learning/model-selection/hyper-parameter-tuning" class=''>Hyper-parameter tuning</a></li>


 								  <li><a href="/docs/latest//machine-learning/model-selection/pipeline-api" class=''>Pipeline API</a></li>

                             </nav>

                     </li>


                     <li>

                             <a href="/docs/latest/machine-learning/multiclass-classification"

                                 class=''
                             >Multiclass Classification</a>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Ensemble Methods<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//machine-learning/ensemble-methods/introduction" class=''></a></li>


 								  <li><a href="/docs/latest//machine-learning/ensemble-methods/stacking" class=''>Stacking</a></li>


 								  <li><a href="/docs/latest//machine-learning/ensemble-methods/baggin" class=''>Bagging</a></li>


 								  <li><a href="/docs/latest//machine-learning/ensemble-methods/random-forest" class=''>Random Forest</a></li>


 								  <li><a href="/docs/latest//machine-learning/ensemble-methods/gradient-boosting" class=''>Gradient Boosting</a></li>

                             </nav>

                     </li>


                     <li>

                             <a href="/docs/latest/machine-learning/recommendation-systems"

                                 class=''
                             >Recommendation Systems</a>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Importing Model<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//machine-learning/importing-model/introduction" class=''>Introduction</a></li>


 								  <li><a href="/docs/latest//machine-learning/importing-model/model-import-from-gxboost" class=''>Import Model from XGBoost</a></li>


 								  <li><a href="/docs/latest//machine-learning/importing-model/model-import-from-apache-spark" class=''>Import Model from Apache Spark</a></li>

                             </nav>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Monitoring<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/monitoring-metrics/intro"

                                 class=''
                             >Introduction</a>

                     </li>


                     <li>

                             <a href="/docs/latest/monitoring-metrics/cluster-id"

                                 class=''
                             >Cluster ID and Tag</a>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Metrics<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//monitoring-metrics/configuring-metrics" class=''>Configuring Metrics</a></li>


 								  <li><a href="/docs/latest//monitoring-metrics/metrics" class=''>JMX Metrics</a></li>

                             </nav>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>New Metrics System<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//monitoring-metrics/new-metrics-system" class=''>Introduction</a></li>


 								  <li><a href="/docs/latest//monitoring-metrics/new-metrics" class=''>Metrics</a></li>

                             </nav>

                     </li>


                     <li>

                             <a href="/docs/latest/monitoring-metrics/system-views"

                                 class=''
                             >System Views</a>

                     </li>


                     <li>

                             <a href="/docs/latest/monitoring-metrics/tracing"

                                 class=''
                             >Tracing</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="/security" class='group-toggle collapsed '>Security<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/security/authentication"

                                 class=''
                             >Authentication</a>

                     </li>


                     <li>

                             <a href="/docs/latest/security/ssl-tls"

                                 class=''
                             >SSL/TLS</a>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Transparent Data Encryption<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//security/tde" class=''>Introduction</a></li>


 								  <li><a href="/docs/latest//security/master-key-rotation" class=''>Master key rotation</a></li>

                             </nav>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Thin Clients<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/thin-clients/getting-started-with-thin-clients"

                                 class=''
                             >Thin Clients Overview</a>

                     </li>


                     <li>

                             <a href="/docs/latest/thin-clients/java-thin-client"

                                 class=''
                             >Java Thin Client</a>

                     </li>


                     <li>

                             <a href="/docs/latest/thin-clients/dotnet-thin-client"

                                 class=''
                             >.NET Thin Client</a>

                     </li>


                     <li>

                             <a href="/docs/latest/thin-clients/cpp-thin-client"

                                 class=''
                             >C++ Thin Client</a>

                     </li>


                     <li>

                             <a href="/docs/latest/thin-clients/python-thin-client"

                                 class=''
                             >Python Thin Client</a>

                     </li>


                     <li>

                             <a href="/docs/latest/thin-clients/php-thin-client"

                                 class=''
                             >PHP Thin Client</a>

                     </li>


                     <li>

                             <a href="/docs/latest/thin-clients/nodejs-thin-client"

                                 class=''
                             >Node.js Thin Client</a>

                     </li>


                     <li>


                             <button
                                 type='button'
                                 class='collapsed '>Binary Client Protocol<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
                             <nav class="sub_pages collapsed">


 								  <li><a href="/docs/latest//binary-client-protocol/binary-client-protocol" class=''>Binary Client Protocol</a></li>


 								  <li><a href="/docs/latest//binary-client-protocol/data-format" class=''>Data Format</a></li>


 								  <li><a href="/docs/latest//binary-client-protocol/key-value-queries" class=''>Key-Value Queries</a></li>


 								  <li><a href="/docs/latest//binary-client-protocol/sql-and-scan-queries" class=''>SQL and Scan Queries</a></li>


 								  <li><a href="/docs/latest//binary-client-protocol/binary-type-metadata" class=''>Binary Types Metadata</a></li>


 								  <li><a href="/docs/latest//binary-client-protocol/cache-configuration" class=''>Cache Configuration</a></li>

                             </nav>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>ODBC Driver<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/SQL/ODBC/odbc-driver"

                                 class=''
                             >ODBC Driver</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/ODBC/connection-string-dsn"

                                 class=''
                             >Connection String and DSN</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/ODBC/querying-modifying-data"

                                 class=''
                             >Querying and Modifying Data</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/ODBC/specification"

                                 class=''
                             >Specification</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/ODBC/data-types"

                                 class=''
                             >Data Types</a>

                     </li>


                     <li>

                             <a href="/docs/latest/SQL/ODBC/error-codes"

                                 class=''
                             >Error Codes</a>

                     </li>


              </nav>

         </li>

         <li>


             <a href="/docs/latest/restapi" class='' >REST API</a>

         </li>

         <li>


             <a href="/docs/latest/control-script" class='' >Control Script</a>

         </li>

         <li>


             <a href="/docs/latest/plugins" class='' >Plugins</a>

         </li>

         <li>


             <a href="/docs/latest/sqlline" class='' >SQLLine</a>

         </li>

         <li>


 			<button type='button' data-guide-url="" class='group-toggle collapsed '>Ignite for Spark<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/ignite-for-spark/overview"

                                 class=''
                             >Overview</a>

                     </li>


                     <li>

                             <a href="/docs/latest/ignite-for-spark/ignitecontext-and-rdd"

                                 class=''
                             >IgniteContext and IgniteRDD</a>

                     </li>


                     <li>

                             <a href="/docs/latest/ignite-for-spark/ignite-dataframe"

                                 class=''
                             >Ignite DataFrame</a>

                     </li>


                     <li>

                             <a href="/docs/latest/ignite-for-spark/installation"

                                 class=''
                             >Installation</a>

                     </li>


                     <li>

                             <a href="/docs/latest/ignite-for-spark/spark-shell"

                                 class=''
                             >Test Ignite with Spark-shell</a>

                     </li>


                     <li>

                             <a href="/docs/latest/ignite-for-spark/troubleshooting"

                                 class=''
                             >Troubleshooting</a>

                     </li>


              </nav>

         </li>

         <li>


 			<button type='button' data-guide-url="/sql-reference/sql-reference-overview" class='group-toggle collapsed '>SQL Reference<img class="state-indicator" src="/assets/images/left-nav-arrow.svg"></button>
              <nav class='nav-group collapsed'>


                     <li>

                             <a href="/docs/latest/sql-reference/sql-conformance"

                                 class=''
                             >SQL Conformance</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/ddl"

                                 class=''
                             >Data Definition Language (DDL)</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/dml"

                                 class=''
                             >Data Manipulation Language (DML)</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/transactions"

                                 class=''
                             >Transactions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/operational-commands"

                                 class=''
                             >Operational Commands</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/aggregate-functions"

                                 class=''
                             >Aggregate functions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/numeric-functions"

                                 class=''
                             >Numeric Functions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/string-functions"

                                 class=''
                             >String Functions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/date-time-functions"

                                 class=''
                             >Data and Time Functions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/system-functions"

                                 class=''
                             >System Functions</a>

                     </li>


                     <li>

                             <a href="/docs/latest/sql-reference/data-types"

                                 class=''
                             >Data Types</a>

                     </li>


              </nav>

         </li>

 </nav>
 <div class="left-nav__overlay"></div>


     <article data-swiftype-index='true'>
       <a class='edit-link' href="https://github.com/apache/ignite/tree/IGNITE-7595/docs/_docs/monitoring-metrics/system-views.adoc" target="_blank">Edit</a>

             <h1>System Views</h1>

         <div id="preamble">
 <div class="sectionbody">
 <div class="admonitionblock warning">
 <table>
 <tr>
 <td class="icon">
 <div class="title">Warning</div>
 </td>
 <td class="content">
 The system views are an experimental feature and can be changed in future releases.
 </td>
 </tr>
 </table>
 </div>
 <div class="paragraph">
 <p>Ignite provides a number of built-in SQL views that contain information about cluster nodes and node metrics.
 The views are available in the SYS schema.
 See the <a href="/docs/latest/SQL/schemas">Understanding Schemas</a> page for the information on how to access a non-default schema.</p>
 </div>
 <div class="admonitionblock important">
 <table>
 <tr>
 <td class="icon">
 <div class="title">Important</div>
 </td>
 <td class="content">
 <h3 id="limitations" class="discrete">Limitations</h3>
 <div class="olist arabic">
 <ol class="arabic">
 <li>
 <p>You cannot create objects in the SYS schema.</p>
 </li>
 <li>
 <p>System views from the SYS schema cannot be joined with user tables.</p>
 </li>
 </ol>
 </div>
 </td>
 </tr>
 </table>
 </div>
 </div>
 </div>
 <div class="sect1">
 <h2 id="querying-system-views">Querying System Views</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>To query the system views using the <a href="/docs/latest/sqlline">SQLLine</a> tool, connect to the SYS schema as follows:</p>
 </div>
 <div class="listingblock">
 <div class="content">
 <pre class="rouge highlight"><code data-lang="shell">./sqlline.sh <span class="nt">-u</span> jdbc:ignite:thin://127.0.0.1/SYS</code></pre>
 </div>
 </div>
 <div class="paragraph">
 <p>If your node is running on a remote server, replace <code>127.0.0.1</code> with the IP address of the server.</p>
 </div>
 <div class="paragraph">
 <p>Run a query:</p>
 </div>
 <div class="listingblock">
 <div class="content">
 <pre class="rouge highlight"><code data-lang="sql"><span class="c1">-- get the list of nodes</span>
 <span class="k">select</span> <span class="o">*</span> <span class="k">from</span> <span class="n">NODES</span><span class="p">;</span>

 <span class="c1">-- view the CPU load as a percentage for a specific node</span>
 <span class="k">select</span> <span class="n">CUR_CPU_LOAD</span> <span class="o">*</span> <span class="mi">100</span> <span class="k">from</span> <span class="n">NODE_METRICS</span> <span class="k">where</span> <span class="n">NODE_ID</span> <span class="o">=</span> <span class="s1">'a1b77663-b37f-4ddf-87a6-1e2d684f3bae'</span></code></pre>
 </div>
 </div>
 <div class="paragraph">
 <p>The same example using <a href="/docs/latest/thin-clients/java-thin-client">Java Thin Client</a>:</p>
 </div>
 <div class="listingblock">
 <div class="content">
 <pre class="rouge highlight"><code data-lang="java"><span class="nc">ClientConfiguration</span> <span class="n">cfg</span> <span class="o">=</span> <span class="k">new</span> <span class="nc">ClientConfiguration</span><span class="o">().</span><span class="na">setAddresses</span><span class="o">(</span><span class="s">"127.0.0.1:10800"</span><span class="o">);</span>

 <span class="k">try</span> <span class="o">(</span><span class="nc">IgniteClient</span> <span class="n">igniteClient</span> <span class="o">=</span> <span class="nc">Ignition</span><span class="o">.</span><span class="na">startClient</span><span class="o">(</span><span class="n">cfg</span><span class="o">))</span> <span class="o">{</span>

     <span class="c1">// getting the id of the first node</span>
     <span class="no">UUID</span> <span class="n">nodeId</span> <span class="o">=</span> <span class="o">(</span><span class="no">UUID</span><span class="o">)</span> <span class="n">igniteClient</span><span class="o">.</span><span class="na">query</span><span class="o">(</span><span class="k">new</span> <span class="nc">SqlFieldsQuery</span><span class="o">(</span><span class="s">"SELECT * from NODES"</span><span class="o">).</span><span class="na">setSchema</span><span class="o">(</span><span class="s">"IGNITE"</span><span class="o">))</span>
     <span class="o">.</span><span class="na">getAll</span><span class="o">().</span><span class="na">iterator</span><span class="o">().</span><span class="na">next</span><span class="o">().</span><span class="na">get</span><span class="o">(</span><span class="mi">0</span><span class="o">);</span>

     <span class="kt">double</span> <span class="n">cpu_load</span> <span class="o">=</span> <span class="o">(</span><span class="nc">Double</span><span class="o">)</span> <span class="n">igniteClient</span>
     <span class="o">.</span><span class="na">query</span><span class="o">(</span><span class="k">new</span> <span class="nc">SqlFieldsQuery</span><span class="o">(</span><span class="s">"select CUR_CPU_LOAD * 100 from NODE_METRICS where NODE_ID = ? "</span><span class="o">)</span>
     <span class="o">.</span><span class="na">setSchema</span><span class="o">(</span><span class="s">"IGNITE"</span><span class="o">).</span><span class="na">setArgs</span><span class="o">(</span><span class="n">nodeId</span><span class="o">.</span><span class="na">toString</span><span class="o">()))</span>
     <span class="o">.</span><span class="na">getAll</span><span class="o">().</span><span class="na">iterator</span><span class="o">().</span><span class="na">next</span><span class="o">().</span><span class="na">get</span><span class="o">(</span><span class="mi">0</span><span class="o">);</span>

     <span class="nc">System</span><span class="o">.</span><span class="na">out</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="s">"node's cpu load = "</span> <span class="o">+</span> <span class="n">cpu_load</span><span class="o">);</span>

 <span class="o">}</span> <span class="k">catch</span> <span class="o">(</span><span class="nc">ClientException</span> <span class="n">e</span><span class="o">)</span> <span class="o">{</span>
     <span class="nc">System</span><span class="o">.</span><span class="na">err</span><span class="o">.</span><span class="na">println</span><span class="o">(</span><span class="n">e</span><span class="o">.</span><span class="na">getMessage</span><span class="o">());</span>
 <span class="o">}</span> <span class="k">catch</span> <span class="o">(</span><span class="nc">Exception</span> <span class="n">e</span><span class="o">)</span> <span class="o">{</span>
     <span class="nc">System</span><span class="o">.</span><span class="na">err</span><span class="o">.</span><span class="na">format</span><span class="o">(</span><span class="s">"Unexpected failure: %s\n"</span><span class="o">,</span> <span class="n">e</span><span class="o">);</span>
 <span class="o">}</span></code></pre>
 </div>
 </div>
 </div>
 </div>
 <div class="sect1">
 <h2 id="caches">CACHES</h2>
 <div class="sectionbody">
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">Column</th>
 <th class="tableblock halign-left valign-top">Type</th>
 <th class="tableblock halign-left valign-top">Description</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_TYPE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache type</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_MODE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache mode</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ATOMICITY_MODE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Atomicity mode</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_GROUP_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache group name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AFFINITY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of affinity function</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AFFINITY_MAPPER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of affinity mapper</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BACKUPS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">backup count</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_GROUP_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">cache group id</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_LOADER_FACTORY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of cache loader factory</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_STORE_FACTORY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of cache store factory</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_WRITER_FACTORY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of cache writer factory</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DATA_REGION_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Data region name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DEFAULT_LOCK_TIMEOUT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Lock timeout in milliseconds</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">EVICTION_FILTER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of eviction filter</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">EVICTION_POLICY_FACTORY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of eviction policy factory</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">EXPIRY_POLICY_FACTORY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of expiry policy factory</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INTERCEPTOR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of interceptor</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_COPY_ON_READ</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Flag indicating whether a copy of the value stored in the on-heap cache</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_EAGER_TTL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Flag indicating whether expired cache entries will be eagerly removed from cache</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_ENCRYPTION_ENABLED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if cache data encrypted</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_EVENTS_DISABLED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if events disabled for this cache</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_INVALIDATE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if values will be invalidated (nullified) upon commit in near cache</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_LOAD_PREVIOUS_VALUE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if value should be loaded from store if it is not in the cache</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_MANAGEMENT_ENABLED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_NEAR_CACHE_ENABLED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if near cache enabled</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_ONHEAP_CACHE_ENABLED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if on heap cache enabled</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_READ_FROM_BACKUP</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if read operation should be performed from backup node</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_READ_THROUGH</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if read from third party storage enabled</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_SQL_ESCAPE_ALL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">If true all the SQL table and field names will be escaped with double quotes</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_SQL_ONHEAP_CACHE_ENABLED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">If true SQL on-heap cache is enabled. When enabled, Ignite will cache SQL rows as they are accessed by query engine. Rows are invalidated and evicted from cache when relevant cache entry is either changed or evicted.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_STATISTICS_ENABLED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_STORE_KEEP_BINARY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Flag indicating that {@link CacheStore} implementation is working with binary objects instead of Java objects.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_WRITE_BEHIND_ENABLED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Flag indicating whether Ignite should use write-behind behaviour for the cache store</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_WRITE_THROUGH</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if write to third party storage enabled</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_CONCURRENT_ASYNC_OPERATIONS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum number of allowed concurrent asynchronous operations. If 0 returned then number of concurrent asynchronous operations is unlimited</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_QUERY_ITERATORS_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum number of query iterators that can be stored. Iterators are stored to support query pagination when each page of data is sent to user&#8217;s node only on demand</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NEAR_CACHE_EVICTION_POLICY_FACTORY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of near cache eviction policy factory</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NEAR_CACHE_START_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Initial cache size for near cache which will be used to pre-create internal hash table after start.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_FILTER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of node filter</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PARTITION_LOSS_POLICY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of partition loss policy</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">QUERY_DETAIL_METRICS_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">size of queries detail metrics that will be stored in memory for monitoring purposes. If 0 then history will not be collected.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">QUERY_PARALLELISM</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Hint to query execution engine on desired degree of parallelism within a single node</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_BATCH_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Size (in bytes) to be loaded within a single rebalance message</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_BATCHES_PREFETCH_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of batches generated by supply node at rebalancing start</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_DELAY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Rebalance delay in milliseconds</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_MODE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Rebalance mode</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_ORDER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Rebalance order</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_THROTTLE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Time in milliseconds to wait between rebalance messages to avoid overloading of CPU or network</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_TIMEOUT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Rebalance timeout in milliseconds</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SQL_INDEX_MAX_INLINE_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Index inline size in bytes</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SQL_ONHEAP_CACHE_MAX_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum SQL on-heap cache. Measured in number of rows. When maximum size is reached oldest cached rows will be evicted.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SQL_SCHEMA</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Schema name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOPOLOGY_VALIDATOR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of topology validator</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">WRITE_BEHIND_BATCH_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum batch size for write-behind cache store operations</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">WRITE_BEHIND_COALESCING</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Write coalescing flag for write-behind cache store operations. Store operations (get or remove) with the same key are combined or coalesced to single, resulting operation to reduce pressure to underlying cache store</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">WRITE_BEHIND_FLUSH_FREQUENCY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Frequency with which write-behind cache is flushed to the cache store in milliseconds</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">WRITE_BEHIND_FLUSH_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum size of the write-behind cache. If cache size exceeds this value, all cached items are flushed to the cache store and write cache is cleared</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">WRITE_BEHIND_FLUSH_THREAD_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of threads that will perform cache flushing</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">WRITE_SYNCHRONIZATION_MODE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Gets write synchronization mode</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="cache_groups">CACHE_GROUPS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>The CACHE_GROUPS view contains information about the <a href="/docs/latest/configuring-caches/cache-groups">cache groups</a>.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">Column</th>
 <th class="tableblock halign-left valign-top">Data Type</th>
 <th class="tableblock halign-left valign-top">Description</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AFFINITY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The string representation (as returned by the <code>toString()</code> method) of the affinity function defined for the cache group.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ATOMICITY_MODE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The <a href="/docs/latest/configuring-caches/atomicity-modes">atomicity mode</a> of the cache group.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BACKUPS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The number of <a href="/docs/latest/configuring-caches/configuring-backups">backup partitions</a> configured for the cache group.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The number of caches in the cache group.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_GROUP_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The ID of the cache group.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_GROUP_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The name of the cache group.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_MODE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The cache mode.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DATA_REGION_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The name of the <a href="/docs/latest/memory-configuration/data-regions">data region</a>.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_SHARED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BOOLEAN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">If this group contains more than one cache.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_FILTER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The string representation (as returned by the <code>toString()</code> method) of the node filter defined for the cache group.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PARTITION_LOSS_POLICY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="/docs/latest/partition-loss-policy">Partition loss policy</a>.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PARTITIONS_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The number of partitions.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_DELAY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="/docs/latest/data-rebalancing#other-properties">Rebalancing delay</a>.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_MODE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="/docs/latest/data-rebalancing#configuring-rebalancing-mode">Rebalancing mode</a>.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REBALANCE_ORDER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock"><a href="/docs/latest/data-rebalancing#other-properties">Rebalancing order</a>.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOPOLOGY_VALIDATOR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The string representation (as returned by the <code>toString()</code> method) of the topology validator defined for the cache group.</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="tasks">TASKS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about currently running compute tasks started by a node. For instance, let&#8217;s assume that an application started a compute task using the thick client&#8217;s API, and a task&#8217;s job was executed on a server node. In this case, the thick client will report statistics related to the task through this system view while and not the server node. The latter will only update its job execution statistics.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AFFINITY_CACHE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AFFINITY_PARTITION_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache partition id</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">END_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">End time</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">EXEC_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Thread pool name executing task</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INTERNAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if task is internal</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">JOB_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Compute job ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">START_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Start time</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TASK_CLASS_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Task class name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TASK_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Task name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TASK_NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Task originating node id</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">USER_VERSION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Task user version</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="services">SERVICES</h2>
 <div class="sectionbody">
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">AFFINITY_KEY</th>
 <th class="tableblock halign-left valign-top">string</th>
 <th class="tableblock halign-left valign-top">Affinity key value for service</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_PER_NODE_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum count of services instances per node</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Service name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TYPE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DESCRIPTION</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_FILTER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of node filter</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ORIGIN_NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Originating node ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SERVICE_CLASS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Service class name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SERVICE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Service ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">STATICALLY_CONFIGURED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True is service statically configured</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total count of service instances</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="transactions">TRANSACTIONS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about currently running transactions.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ORIGINATING_NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">STATE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">XID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LABEL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">START_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ISOLATION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CONCURRENCY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">KEYS_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_IDS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">COLOCATED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DHT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DURATION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IMPLICIT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IMPLICIT_SINGLE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INTERNAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL_NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NEAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ONE_PHASE_COMMIT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">OTHER_NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SUBJECT_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SYSTEM</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">THREAD_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIMEOUT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOP_VER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="nodes">NODES</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>The NODES view contains information about the cluster nodes.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 25%;">
 <col style="width: 25%;">
 <col style="width: 50%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">Column</th>
 <th class="tableblock halign-left valign-top">Data Type</th>
 <th class="tableblock halign-left valign-top">Description</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_LOCAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BOOLEAN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Whether the node is local.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ADDRESSES</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The addresses of the node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CONSISTENT_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node&#8217;s consistent ID.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">HOSTNAMES</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">The host names of the node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_CLIENT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BOOLEAN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Indicates whether the node is a client.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_DAEMON</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BOOLEAN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Indicates whether the node is a daemon node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node ID.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_ORDER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node order within the topology.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VERSION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node version.</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="node_attributes">NODE_ATTRIBUTES</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>The NODE_ATTRIBUTES view contains the attributes of all nodes.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">Column</th>
 <th class="tableblock halign-left valign-top">Data Type</th>
 <th class="tableblock halign-left valign-top">Description</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node ID.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Attribute name.</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="baseline_nodes">BASELINE_NODES</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>The BASELINE_NODES view contains information about the nodes that are part of the current baseline topology.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">Column</th>
 <th class="tableblock halign-left valign-top">Data Type</th>
 <th class="tableblock halign-left valign-top">Description</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CONSISTENT_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VARCHAR</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node consistent ID.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ONLINE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BOOLEAN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Indicates whether the node is up and running.</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="client_connections">CLIENT_CONNECTIONS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about currently opened client connections: JDBC, ODBC, Thin clients.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CONNECTION_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ID of the connection</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL_ADDRESS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IP</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">address  IP address of the local node</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REMOTE_ADDRESS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IP</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">address  IP address of the remote node</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TYPE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Type of the connection</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">USER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">User name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VERSION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Protocol version</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="striped_threadpool_queue">STRIPED_THREADPOOL_QUEUE</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about tasks waiting for the execution in the system striped thread pool.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DESCRIPTION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of the task</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">STRIPE_INDEX</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Index of the stripe thread</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TASK_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Class name of the task</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">THREAD_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name of the stripe thread</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="datastream_threadpool_queue">DATASTREAM_THREADPOOL_QUEUE</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about tasks waiting for the execution in the data streamer stripped thread pool.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DESCRIPTION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of the task</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">STRIPE_INDEX</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Index of the stripe thread</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TASK_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Class name of the task</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">THREAD_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name of the stripe thread</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="scan_queries">SCAN_QUERIES</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about currently running scan queries.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_GROUP_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache group ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_GROUP_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache group name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CANCELED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if canceled</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DURATION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query duration</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FILTER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of filter</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">KEEP_BINARY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if keepBinary enabled</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if query local only</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ORIGIN_NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node id started query</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PAGE_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Page size</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PARTITION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query partition ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">QUERY_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">START_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query start time</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SUBJECT_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">User ID started query</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TASK_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOPOLOGY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Topology version</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TRANSFORMER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of transformer</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="sql_queries_history">SQL_QUERIES_HISTORY</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about SQL queries history.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCHEMA_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Schema name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SQL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query text</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if local only</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">EXECUTIONS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Count of executions</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FAILURES</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Count of failures</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DURATION_MIN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Minimal duration of execution</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DURATION_MAX</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum duration of execution</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LAST_START_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">date</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Last execution date</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="continuous_queries">CONTINUOUS_QUERIES</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about currently running continuous queries.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AUTO_UNSUBSCRIBE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if query should be stopped when node disconnected or originating node left</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BUFFER_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Event batch buffer size</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DELAYED_REGISTER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if query would be started when corresponding cache started</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INTERVAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Notify interval</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_EVENTS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if used for subscription to remote events</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_MESSAGING</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if used for subscription to messages.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_QUERY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if user started continuous query.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">KEEP_BINARY</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if keepBinary enabled</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LAST_SEND_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Last time event batch sent to query originating node</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL_LISTENER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of local listener</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL_TRANSFORMED_LISTENER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of local transformed listener</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Originating node id</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NOTIFY_EXISTING</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if listener should be notified about existing entries</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">OLD_VALUE_REQUIRED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if old entry value should be included in event</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REMOTE_FILTER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of remote filter</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">REMOTE_TRANSFORMER</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">toString representation of remote transformer</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ROUTINE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOPIC</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query topic name</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="sql_queries">SQL_QUERIES</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about currently running SQL queries.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DURATION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query execution duration</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if local only</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">ORIGIN_NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node that started query</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">QUERY_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCHEMA_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Schema name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SQL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query text</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">START_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">date</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query start time</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="sql_queries_history-2">SQL_QUERIES_HISTORY</h2>
 <div class="sectionbody">
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCHEMA_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Schema name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SQL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Query text</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LOCAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if local only</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">EXECUTIONS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Count of executions</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FAILURES</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Count of failures</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DURATION_MIN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Minimal duration of execution</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DURATION_MAX</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">long</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum duration of execution</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LAST_START_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">date</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Last execution date</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="schemas">SCHEMAS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about SQL schemas.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name of the schema</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PREDEFINED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">If true schema is predefined</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="node_metrics">NODE_METRICS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>The NODE_METRICS view provides various metrics about the state of nodes, resource consumption and other metrics.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">Column</th>
 <th class="tableblock halign-left valign-top">Data Type</th>
 <th class="tableblock halign-left valign-top">Description</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UUID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Node ID.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LAST_UPDATE_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIMESTAMP</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Last time the metrics were updated.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_ACTIVE_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum number of concurrent jobs this node ever had at one time.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_ACTIVE_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of currently active jobs running on the node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AVG_ACTIVE_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FLOAT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Average number of active jobs concurrently executing on the node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_WAITING_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum number of waiting jobs this node ever had at one time.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_WAITING_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of queued jobs currently waiting to be executed.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AVG_WAITING_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FLOAT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Average number of waiting jobs this node ever had at one time.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_REJECTED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum number of jobs rejected at once during a single collision resolution operation.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_REJECTED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of jobs rejected as a result of the most recent collision resolution operation.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AVG_REJECTED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FLOAT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Average number of jobs this node rejected as a result of collision resolution operations.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_REJECTED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total number of jobs this node has rejected as a result of collision resolution operations since the node startup.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_CANCELED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum number of cancelled jobs this node ever had running concurrently.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_CANCELED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of cancelled jobs that are still running.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AVG_CANCELED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FLOAT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Average number of cancelled jobs this node ever had running concurrently.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_CANCELED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of jobs cancelled since the node startup.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_JOBS_WAIT_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum time a job ever spent waiting in a queue before being executed.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_JOBS_WAIT_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Longest wait time among the jobs that are currently waiting for execution.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AVG_JOBS_WAIT_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Average time jobs spend in the queue before being executed.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_JOBS_EXECUTE_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum job execution time.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_JOBS_EXECUTE_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Longest time a current job has been executing for.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AVG_JOBS_EXECUTE_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Average job execution time on this node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_JOBS_EXECUTE_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total time all finished jobs took to execute on this node since the node startup.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_EXECUTED_JOBS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total number of jobs handled by the node since the node startup.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_EXECUTED_TASKS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total number of tasks handled by the node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_BUSY_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total time this node spent executing jobs.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_IDLE_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total time this node spent idling (not executing any jobs).</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_IDLE_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Time this node has spent idling since executing the last job.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">BUSY_TIME_PERCENTAGE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FLOAT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Percentage of job execution vs idle time.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IDLE_TIME_PERCENTAGE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">FLOAT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Percentage of idle vs job execution time.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_CPU</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of CPUs available to the Java Virtual Machine.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_CPU_LOAD</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DOUBLE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Percentage of CPU usage expressed as a fraction in the range [0, 1].</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AVG_CPU_LOAD</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DOUBLE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Average percentage of CPU usage expressed as a fraction in the range [0, 1].</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_GC_CPU_LOAD</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DOUBLE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Average time spent in GC since the last update of the metrics. By default, metrics are updated every 2 seconds.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">HEAP_MEMORY_INIT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Amount of heap memory in bytes that the JVM initially requests from the operating system for memory management. Shows <code>-1</code> if the initial memory size is undefined.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">HEAP_MEMORY_USED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Current heap size that is used for object allocation. The heap consists of one or more memory pools. This value is the sum of used heap memory values of all heap memory pools.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">HEAP_MEMORY_COMMITED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Amount of heap memory in bytes that is committed for the JVM to use. This amount of memory is guaranteed for the JVM to use. The heap consists of one or more memory pools. This value is the sum of committed heap memory values of all heap memory pools.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">HEAP_MEMORY_MAX</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum amount of heap memory in bytes that can be used for memory management. The column displays <code>-1</code> if the maximum memory size is undefined.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">HEAP_MEMORY_TOTAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total amount of heap memory in bytes. The column displays <code>-1</code> if the total memory size is undefined.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NONHEAP_MEMORY_INIT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Amount of non-heap memory in bytes that the JVM initially requests from the operating system for memory management. The column displays <code>-1</code> if the initial memory size is undefined.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NONHEAP_MEMORY_USED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Current non-heap memory size that is used by Java VM. The non-heap memory consists of one or more memory pools. This value is the sum of used non-heap memory values of all non-heap memory pools.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NONHEAP_MEMORY_COMMITED</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Amount of non-heap memory in bytes that is committed for the JVM to use. This amount of memory is guaranteed for the JVM to use. The non-heap memory consists of one or more memory pools. This value is the sum of committed non-heap memory values of all non-heap memory pools.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NONHEAP_MEMORY_MAX</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Returns the maximum amount of non-heap memory in bytes that can be used for memory management. The column displays <code>-1</code> if the maximum memory size is undefined.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NONHEAP_MEMORY_TOTAL</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total amount of non-heap memory in bytes that can be used for memory management. The column displays <code>-1</code> if the total memory size is undefined.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">UPTIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Uptime of the JVM.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">JVM_START_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIMESTAMP</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Start time of the JVM.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NODE_START_TIME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TIMESTAMP</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Start time of the node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LAST_DATA_VERSION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">In-Memory Data Grid assigns incremental versions to all cache operations. This column contains the latest data version on the node.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_THREAD_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of live threads including both daemon and non-daemon threads.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">MAX_THREAD_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Maximum live thread count since the JVM started or peak was reset.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TOTAL_THREAD_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Total number of threads  started since the JVM started.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CUR_DAEMON_THREAD_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of live daemon threads.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SENT_MESSAGES_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of node communication messages sent.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SENT_BYTES_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Amount of bytes sent.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">RECEIVED_MESSAGES_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Number of node communication messages received.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">RECEIVED_BYTES_COUNT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">LONG</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Amount of bytes received.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">OUTBOUND_MESSAGES_QUEUE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Outbound messages queue size.</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="tables">TABLES</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>The TABLES view contains information about the SQL tables.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">Column</th>
 <th class="tableblock halign-left valign-top">Data Type</th>
 <th class="tableblock halign-left valign-top">Description</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AFFINITY_KEY_COLUMN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Affinity key column name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache id for the table</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache name for the table</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_INDEX_REBUILD_IN_PROGRESS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if some index rebuild for this table in progress</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">KEY_ALIAS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Key column alias</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">KEY_TYPE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Key type name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCHEMA_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Schema name of the table</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TABLE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name of the table</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VALUE_ALIAS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Value column alias</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VALUE_TYPE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Value type name</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="table_columns">TABLE_COLUMNS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about SQL table columns.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AFFINITY_COLUMN</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if column affinity key.</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">AUTO_INCREMENT</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if auto incremented</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">COLUMN_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Column name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DEFAULT_VALUE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Default column value</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NULLABLE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if nullable</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PK</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if primary key</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PRECISION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Column precision</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCALE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Column scale</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCHEMA_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Schema name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TABLE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Table name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TYPE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Column type</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="views">VIEWS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about SQL views.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCHEMA</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Schema</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DESCRIPTION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Description</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="view_columns">VIEW_COLUMNS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>This view exposes information about SQL views columns.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">NAME</th>
 <th class="tableblock halign-left valign-top">TYPE</th>
 <th class="tableblock halign-left valign-top">DESCRIPTION</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">COLUMN_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name of the column</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">DEFAULT_VALUE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Column default value</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">NULLABLE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if column nullable</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">PRECISION</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Column precision</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCALE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Column scale</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCHEMA_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name of the view</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TYPE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Column type</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">VIEW_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name of the view</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="indexes">INDEXES</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>The INDEXES view contains information about SQL indexes.</p>
 </div>
 <table class="tableblock frame-all grid-all stripes-even stretch">
 <colgroup>
 <col style="width: 28.5714%;">
 <col style="width: 14.2857%;">
 <col style="width: 57.1429%;">
 </colgroup>
 <thead>
 <tr>
 <th class="tableblock halign-left valign-top">Column</th>
 <th class="tableblock halign-left valign-top">Data Type</th>
 <th class="tableblock halign-left valign-top">Description</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INDEX_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Name of the index</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INDEX_TYPE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Type of the index</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">COLUMNS</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Columns included in index</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">SCHEMA_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Schema name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">TABLE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Table name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_NAME</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">string</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache name</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">CACHE_ID</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Cache ID</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">INLINE_SIZE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">int</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">Inline size in bytes</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_PK</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if primary key index</p></td>
 </tr>
 <tr>
 <td class="tableblock halign-left valign-top"><p class="tableblock">IS_UNIQUE</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">boolean</p></td>
 <td class="tableblock halign-left valign-top"><p class="tableblock">True if unique index</p></td>
 </tr>
 </tbody>
 </table>
 </div>
 </div>
 <div class="sect1">
 <h2 id="page_lists">PAGE_LISTS</h2>
 <div class="sectionbody">
 <div class="paragraph">
 <p>Page list is a data structure used to store a list of partially free data pages (free-lists) and fully free allocated pages (reuse-lists). The purpose of free lists and reuse lists is to quickly locate a page with enough free space to save an entry or to determine that no such page exists and a new page should be allocated.
 Page lists organized in buckets. Each bucket group pages with about the same size of free space.
 If persistence is enabled page lists are created for each partition of each cache group, to view such page lists cacheGroupPageLists system view (SQL name CACHE_GROUP_PAGE_LISTS) can be used. If persistence is disabled page lists are created for each data region, in this case, dataRegionPageLists system view (SQL name DATA_REGION_PAGE_LISTS) can be used. These views contain information about each bucket of each page list what is useful to understand how much data can be inserted into the cache without allocating new pages and also helps to detect skews in page lists utilization.</p>
 </div>
 </div>
 </div>
         <div class="copyright">
  © 2020 The Apache Software Foundation.<br/>
 Apache, Apache Ignite, the Apache feather and the Apache Ignite logo are either registered trademarks or trademarks of The Apache Software Foundation.

 </div>

     </article>
     <nav class="right-nav" data-swiftype-index='false'>
     <ul class="sectlevel1">
 <li><a href="#querying-system-views">Querying System Views</a></li>
 <li><a href="#caches">CACHES</a></li>
 <li><a href="#cache_groups">CACHE_GROUPS</a></li>
 <li><a href="#tasks">TASKS</a></li>
 <li><a href="#services">SERVICES</a></li>
 <li><a href="#transactions">TRANSACTIONS</a></li>
 <li><a href="#nodes">NODES</a></li>
 <li><a href="#node_attributes">NODE_ATTRIBUTES</a></li>
 <li><a href="#baseline_nodes">BASELINE_NODES</a></li>
 <li><a href="#client_connections">CLIENT_CONNECTIONS</a></li>
 <li><a href="#striped_threadpool_queue">STRIPED_THREADPOOL_QUEUE</a></li>
 <li><a href="#datastream_threadpool_queue">DATASTREAM_THREADPOOL_QUEUE</a></li>
 <li><a href="#scan_queries">SCAN_QUERIES</a></li>
 <li><a href="#sql_queries_history">SQL_QUERIES_HISTORY</a></li>
 <li><a href="#continuous_queries">CONTINUOUS_QUERIES</a></li>
 <li><a href="#sql_queries">SQL_QUERIES</a></li>
 <li><a href="#sql_queries_history-2">SQL_QUERIES_HISTORY</a></li>
 <li><a href="#schemas">SCHEMAS</a></li>
 <li><a href="#node_metrics">NODE_METRICS</a></li>
 <li><a href="#tables">TABLES</a></li>
 <li><a href="#table_columns">TABLE_COLUMNS</a></li>
 <li><a href="#views">VIEWS</a></li>
 <li><a href="#view_columns">VIEW_COLUMNS</a></li>
 <li><a href="#indexes">INDEXES</a></li>
 <li><a href="#page_lists">PAGE_LISTS</a></li>
 </ul>


 <footer>
 </footer>

 </nav>

 </section>
 <script type='module' src='/assets/js/code-copy-to-clipboard.js' async crossorigin></script>

     <script>
     // inits deep anchors -- needs to be done here because of https://www.bryanbraun.com/anchorjs/#dont-run-it-too-late
     anchors.add('.page-docs h1, .page-docs h2, .page-docs h3:not(.discrete), .page-docs h4, .page-docs h5');
     anchors.options = {
         placement: 'right',
         visible: 'always'
     };
     </script>
     <!-- load google fonts async -->
     <script type="text/javascript">
     WebFontConfig = {
       google: { families: [ 'Open+Sans:300,400,600,700&display=swap' ] }
     };
     (function() {
       var wf = document.createElement('script');
       wf.src = 'https://ajax.googleapis.com/ajax/libs/webfont/1/webfont.js';
       wf.type = 'text/javascript';
       wf.async = 'true';
       var s = document.getElementsByTagName('script')[0];
       s.parentNode.insertBefore(wf, s);
     })(); </script>
     <script src="https://cdn.jsdelivr.net/npm/docsearch.js@2/dist/cdn/docsearch.min.js"></script>
     <script>
       docsearch({
         // Your apiKey and indexName will be given to you once
         // we create your config
         apiKey: '3eee686c0ebe39eff3baeb18c56fa5f8',
         indexName: 'apache_ignite',
         // Replace inputSelector with a CSS selector
         // matching your search input
         inputSelector: '#search-input',
         // algoliaOptions: { 'facetFilters': ["version:$VERSION"] },

         // Set debug to true to inspect the dropdown
         debug: false,
       });
     </script>
 <script type='module' src='/assets/js/index.js?1600377059' async crossorigin></script>
 <script type='module' src='/assets/js/versioning.js?1600377059' async crossorigin></script>
 </body>

 </html>