Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ Schemas/ DBE_PERF Schema/ Session/Thread/ LOCAL_THREADPOOL_STATUS
Updated on 2025-08-19 GMT+08:00
View PDF

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

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 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.
Parent topic: Session/Thread