HeavyDB system tables provide a way to access information about database objects, database object permissions, and system resource (storage, CPU, and GPU memory) utilization. These system tables can be found in the information_schema database that is available by default on server startup. You can query system tables in the same way as regular tables, and you can use the SHOW CREATE TABLE command to view the table schemas.
The users system table provides information about all database users and contains the following columns:
The databases system table provides information about all created databases on the server and contains the following columns:
The permissions system table provides information about all user/role permissions for all database objects and contains the following columns:
The roles system table lists all created database roles and contains the following columns:
The tables system table provides information about all database tables and contains the following columns:
The dashboards system table provides information about created dashboards (enterprise edition only) and contains the following columns:
The role_assignments system table provides information about database roles that have been assigned to users and contains the following columns:
The memory_summary system table provides high level information about utilized memory across CPU and GPU devices and contains the following columns:
The memory_details system table provides detailed information about allocated memory segments across CPU and GPU devices and contains the following columns:
The storage_details system table provides detailed information about utilized storage per table and contains the following columns:
The request_logs system table provides information about HeavyDB Thrift API requests and contains the following columns:
The server_logs system table provides HeavyDB server logs in tabular form and contains the following columns:
The web_server_logs system table provides HEAVY.AI Web Server logs in tabular form and contains the following columns (Enterprise Edition only):
The logs system tables must be refreshed manually to view new log entries. You can run the REFRESH FOREIGN TABLES SQL command (for example, REFRESH FOREIGN TABLES server_logs, request_logs; ), or click the Refresh Data Now button on the table’s Data Manager page in Heavy Immerse.
The Request Logs and Monitoring system dashboard is built on the log-based system tables and provides visualization of request counts, performance, and errors over time, along with the server logs.
Cross-linking must be enabled to allow cross-filtering across charts that use different system tables. Enable cross-linking by adding "ui/enable_crosslink_panel": true to the feature_flags section of the servers.json file.