GS_STATIC_THREADPOOL_CTRL_STATUS

GS_STATIC_THREADPOOL_CTRL_STATUS returns statistics about static threads related to the thread pool of the current instance. When the thread pool is enabled, the CN thread pool can be queried using this view. A blank row is returned when a DN is connected for query. Only the user with the PUBLIC permission can query this view.

**Table 1** GS_STATIC_THREADPOOL_CTRL_STATUS columns
Name	Type	Description
node_name	text	Instance name.
group_id	integer	Group ID of the thread pool.
worker_info	text	Dynamic statistics about the running thread pool of the current group. The information includes: default and default_s: number of threads, including default value of the dynamic thread pool and default value of the static thread pool. expect and expect_s: number of threads, including the expected value of the dynamic thread pool and expected value of the static thread pool. actual: actual number of running threads, including dynamic pool threads and static pool threads. static threads limit: indicates the number of static pool threads configured for the current group. has static threads: specifies whether a static pool is created for the current group. The default value is 0, indicating that no user is created. idle static threads: number of idle static pool threads. wait session num: number of waiting sessions.