操作指导

前提条件

GUC参数enable_connect_thread_pool和enable_thread_pool取值都为on。

操作步骤

1. 查看enable_connect_thread_pool参数是否打开。

   gaussdb=# show enable_connect_thread_pool;
    enable_connect_thread_pool
   ----------------------------
    on
   (1 row)

2. 查看enable_thread_pool参数是否打开。

   gaussdb=# show enable_thread_pool;
    enable_thread_pool
   --------------------
    on
   (1 row)

3. 查看建连线程池参数配置，group_id为-1表示是建连线程池。

   gaussdb=# SELECT * from DBE_PERF.LOCAL_THREADPOOL_STATUS where group_id='-1';
    node_name  | group_id | bind_numa_id | bind_cpu_number | listener |                       worker_info                        |             session_info
   |         stream_info
   ------------+----------+--------------+-----------------+----------+----------------------------------------------------------+---------------------------------------
   +-----------------------------
    singlenode |       -1 |              |               0 |        1 | default: 8 new: 0 expect: 8 actual: 8 idle: 8 pending: 0 | total: 0 waiting: 0 running:0 idle: 0
   | total: 0 running: 0 idle: 0
   (1 row)