The Virtual Tables are virtual tables that represent various operational information of the Machbase server in the form of a table. The names of these tables begin with "V$".
This data is used to know what state the Machbase server is operating in.In addition, various information can be obtained through JOIN operation with other tables in this virtual table.
Virtual Tables are read-only and can not be added / deleted / updated by the user.
Displays the property information set in the server.
Minimum set value
Maximum set value
Displays session information connected to the Machbase server.
Whether connection is closed
Leave message in session trace log status
1: Leaves errors occurring in the Parsing, Validation, Optimization steps2: Leaves result performance of DDL3: (Leaves both cases above)
Whether hidden columns are shown upon SELECT
Whether there is feedback to client on APPEND error
Default input format upon Datetime input
Number of Buckets in Temp Hashtable created when performing query
Maximum memory size available when performing query
Whether Result Cache in in use
Maximum elapsed time to store results when using Result Cache
Maximum size of memory used per query when using Result Cache
Maximum number of results used per query when using Result Cache
Whether to cache approximate query results when using Result Cache
Displays session memory information.
Memory manager identifier
Displays statistical information of the session.
Statistical information identifier
Statistical information value
Displays the time information of the session.
Performance unit identifier
Maximum time (per each performance unit)
Displays memory information of the system.
Memory manager name
(Recorded) Maximum usage
Displays statistical information of the system.
Statistical information name
Displays the time information of the system.
Performance unit name
Average time (per each performance unit)
Minimum Time (per each performance unit)
Maximum Time (per each performance unit)
Displays information about the query statement that the user is currently executing.
Performed query session identifier
Resulting record size of select statements
Displays information about Machbase version.
Database major version
Database minor version
META major version
META minor version
Client (Communication Level) major version
Client (Communication Level) minor version
Version name of DB data files.
File DB major version
File DB minor version
File META major version
File META minor version
File Client (Communication Level) major version
File Client (Communication Level) minor version
File creation time
Display the result cache list.
Time cache was used or created
Cache user identifier
Cache query statement
Time spent producing result
Number of tables associated with query statement
Number of result records
Number of sessions currently being referenced
Cache hit count
Time the cache was used or created for aggregate results
Cache hit count for aggregate results
Display statistical information of result cache in one session.
Number of result caches
Total cache hit count
Total cache hit count for aggregate results
Cache replacement count
Size of cache memory used
Displays internal information of the storage system.
Total capacity of disk column data
Total capacity of index file data
Total capacity of DWFILE for all column data
Total number of data files of TAGDATA table partition tables
Displays the information of the mounted backup database using the mount function.
Mounted database name
Backup file location
Backup database tablespace identifier
Backup database identifier
Backup database first entry time
Backup database last entry time
Backup begin time
Backup end time
Displays the comprehensive information on the cache objects containing the results read from the storage system.
Current number of result set cache objects
Displays information about each cache object that contains the results read from the storage system.
(Internal server use flag)
Displays the table space information of the storage system.
Flag indicating tablespace property
Tablespace reference count
Tablespace disk count
Disk tablespace identifier
I/O Thread count
I/O Job count
Virtual disk count
Displays the information of the double-write file (DW File) operated by the storage system.
Disk image size
Head CRC32 Code Image
Tail CRC32 Code Image
CRC32 Code Page
Head Timestamp Page
Tail Timestamp Page
Displays information about the Page Cache operating on the storage system
Maximum memory size of Page Cache
Current memory size of Page Cache
Number of cached pages
Displays information about the LRU List of Page Cache operated by the storage system.
Page Cache Offset
Displays the amount of storage used by the storage system.
Display table details.
Displays internal information about Log Table.
System Change Number at time of creation
System Change Number at time of most recent update
Number of sessions referencing table in DDL syntax execution
Minimum table RID
Last row ID of table + 1
ID at start of recording meta information
ID at end of recording meta information
Last row ID recorded on disk + 1
Flag indicating table property
Table column count
Table index count
Last RID recorded in index + 1
Last recorded _arrival_time value
Last checkpoint time
Number of records not deleted when using auto delete
How long to keep data when using auto delete function
Displays information about the columns in the Log Table.
Column data size
Maximum number of data stored in partition
Maximum number of data stored in page
Maximum number of cache values
Maximum size of MIN / MAX cache for column partitions
Current partition in progress of input identifier
Number of partitions that have read data in current cache
Current Min / MAX cache size
Location value of end rid maintaining default value
Total size of column partition data file for that column
Memory size used by table
Memory size allocated by table
Displays column partition information of log table.
Flag indicating column property
First RID stored in partition
Last RID stored in partition
Last RID SYNC ended.
Data with a RID greater than the starting RID and less than the last SYNC RID is recorded in the partition file.
First time data was entered into column partition
Last time data was entered into column partition
Maximum partition data count
Maximum page data count
Maximum partition page count
Page size stored in column partition
Page count created in current column partition
Column partition compression ratio. If it is 0, data compression has not been performed yet.
Partition file name
A large amount of data is written to the external partition file, indicating the size of the file
Minimum column partition value
Maximum column partition value
Displays index information generated in Log Table.
Flag indicating index property
First RID entered into table
Last table RID
First index RID
Last index RID
Last recorded RID in file + 1
Index column count
Index first partition identifier
Index last partition identifier
Number of index partitions requested to reflect on disk
Maximum key size
Total size of index partition file for that index
Displays information about LSM Index partitions.
Index table identifier
Index partition LSM level
First RID entered into partition
Last RID entered into partition + 1
Key value count entered into partition
Size of page storing key value
Number of pages storing key value
Minimum key value
Maximum key value
Total size of page storing bitmap value
Number of pages storing bitmap value
Total size of page storing meta information
Number of pages storing meta information
Total time to complete partition
Total time to complete partition for KeyValue Mode
Total time to complete partition for Bitmap Mode
Displays information about the LSM Index partition cache.
Index Table identifier
Number of key values entered into partition
Redblack Tree memory usage
Displays information about the level of the LSM index.
First partition RID
Last partition RID + 1
RID at start time of recording meta information
RID at end time of recording meta information
Maximum deleted RID + 1
Displays information about the files that make up the LSM Index.
Partition first RID
Partition last RID + 1
Index file location
Displays working status of Ager responsible for LSM Index deletion.
Index Ager working status
Displays information about Volatile Table.
Maximum Volatile Tablespace size
Current Volatile Tablespace size
Displays information about the partition table in the Tagdata Table.
Table start RID
Table end RID
Index end RID stored in storage
Table end RID in memory index
Current Index Build Stats
Current DELETE operation state. There is no IDLE because it is performed only when a DELETE command is entered.
Current Table Save operation state.
Displays the cache information used in the partition table of the Tagdata Table.
Type of object in cache
Size of memory in use
Data cache count
Data cache hit count
Data cache miss count
Number of page flushouts due to data cache crash
Number of data pages read directly from storage
Number of times data memory waited for cache crash
Data read operation wait count
Displays detailed information about each cache block used in the partition table of the Tagdata Table.
Displays the file information of the partition table of the Tag Table.
Minimum datatime value of this data file.
Maximum datatime value of this data file.
Displays the Rollup information that stores statistical information of the Tagdata table.
Rollup job ID
Table name to store Rollup information
Name of tag table that Rollup will query
Source Table end RID
Indicates Rollup progress status
Number of recently entered records
Displays the rollup status of the Tagdata table.
Name of table that Rollup will query
Name of table that Rollup will store
End RID of Rollup save table
Elapsed recent Rollup time
The name of stream query.
Last execution time of this query.
The name of table which searched from the query
Minimum wait time for query execution. If it is 0, it is executed every record. If it is not 0, it is executed each time. The unit is nanoseconds.
Displays license information.
License policy type
Work input limit
Additional data rate
Indicates license violation
Number of violations to suspend service (monthly update)
Indicates database is terminated in the event of license violation
(Internal server use)
Displays the license status.
Displays current mutex status.
Shows the call stack of the currently waiting mutex.
Displays the Node status for each Cluster. Only one is displayed.
Node type. There are two types that can be viewed by queries.
Displays DDL information performed by Cluster.
DDL sequence number
DDL execution time
DDL query result value (Internal server use)
Lead Broker Node name
DDL query value
Displays information about the replication operation.
Replication Node Hostname
Replication Manager address
Replication Manager port number
Maximum number of Senders that can be created
Maximum number of active Senders
Displays Sender replication when running Replication.
Sender operational status
Number of payloads received from sender
Total payload size received from Sender
Number of buffers remaining in the Receive Queue
Net send count
Net send size
Net receive count
Net receive size
Displays Sender metadata when running Replication.
Target table identifier
Target table type
Target record start RID
Target record end RID
Displays Receiver information when running Replication.
Receiver operational status
Displays Receiver metadata when running Replication.
Displays Reader information when running Replication.
Reader operation status
Displays Reader metadata when running Replication.
Displays Writer information when running Replication.
Writer operational status
Displays Writer metadata when running Replication.
Displays all Virtual Tables that start with "V$".
User who created table
Displays column information of Virtual Tables.
Column data type