VIEW_RESOURCE_TAG view records the configured worker thread grouping information for each business type in the system. This information includes the group identifier, number of threads, and configuration status, helping users understand system resource allocation.Field Name | Type | Description |
attribute | varchar(64) | Business type identifier system: The default group assigned by the system.pq: The business group for PQ (Parallel Query).duckdb: The business group related to the DuckDB engine. |
tag | int unsigned | The unique identifier for internal system grouping, automatically assigned and managed by the system. This is an internal system identifier. Users do not need to pay attention to or modify it. In daily use, identify different groups by the business type name (attribute field). |
thread_num | int unsigned | Total number of started worker threads under the current group. |
enable | int unsigned | Configuration effective status: 0: The configuration does not take effect. 1: The configuration takes effect. |
tdsql > SELECT * FROM information_schema.VIEW_RESOURCE_TAG;+-----------+-----+------------+--------+| attribute | tag | thread_num | enable |+-----------+-----+------------+--------+| pq | 2 | 29 | 1 || duckdb | 1 | 2 | 1 || system | 0 | 72 | 1 |+-----------+-----+------------+--------+
フィードバック