LOCAL_THREADPOOL_STATUS

default: number of initial threads in the thread pool
new: number of new threads in the thread pool
expect: number of expected threads in the thread pool
actual: number of actual threads in the thread pool
idle: number of idle threads in the thread pool
pending: number of waiting threads in the thread pool

LOCAL_THREADPOOL_STATUS displays the status of worker threads and sessions in the thread pool. This view is valid only when enable_thread_pool is set to on.

**Table 1** LOCAL_THREADPOOL_STATUS columns
Name	Type	Description
node_name	text	Node name
group_id	integer	ID of the thread pool group
bind_numa_id	integer	NUMA ID to which the thread pool group is bound
bind_cpu_number	integer	Information about the CPU to which the thread pool group is bound. If no CPUs are bound, the value is NULL.
listener	integer	Number of listener threads in the thread pool group
worker_info	text	Information about threads in the thread pool, including: default: number of initial threads in the thread pool new: number of new threads in the thread pool expect: number of expected threads in the thread pool actual: number of actual threads in the thread pool idle: number of idle threads in the thread pool pending: number of waiting threads in the thread pool
session_info	text	Information about sessions in the thread pool, including: total: number of all sessions in the thread pool waiting: number of sessions waiting to be scheduled in the thread pool running: number of running sessions in the thread pool idle: number of idle sessions in the thread pool
stream_info	text	Information about streams in the thread pool, including: total: number of all stream threads in the thread pool running: number of running stream threads in the thread pool idle: number of idle stream threads in the thread pool