HomeMogDBMogDB StackUqbar
v1.1

Documentation:v1.1

Supported Versions:

LOCAL_THREADPOOL_STATUS

LOCAL_THREADPOOL_STATUS displays the status of worker threads and sessions in a 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 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
Copyright © 2011-2024 www.enmotech.com All rights reserved.