LOCAL_THREADPOOL_STATUS

default: Number of initial threads in the thread pool group
new: Number of new threads in the thread pool group
expect: Expected number of threads in the thread pool group
actual: Actual number of threads in the thread pool group
idle: Number of idle threads in the thread pool group
pending: Number of pending threads in the thread pool group

LOCAL_THREADPOOL_STATUS displays the status of worker threads and sessions in a thread pool, as shown in Table 1. 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	Database process 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 group new: Number of new threads in the thread pool group expect: Expected number of threads in the thread pool group actual: Actual number of threads in the thread pool group idle: Number of idle threads in the thread pool group pending: Number of pending threads in the thread pool group
session_info	text	Information about sessions in the thread pool, including: total: Total number of sessions in the thread pool group waiting: Number of sessions pending scheduling in the thread pool group running: Number of running sessions in the thread pool group idle: Number of idle sessions in the thread pool group
stream_info	text	Stream pool information, including: total: total number of threads in the stream pool group. running: number of threads that are being executed in the stream pool. idle: number of idle threads in the stream pool.