Updated on 2024-09-30 GMT+08:00

PGXC_OS_THREADS

PGXC_OS_THREADS displays thread status information under all normal nodes in the current cluster.

Table 1 PGXC_OS_THREADS columns

Name

Type

Description

node_name

text

Names of all normal nodes currently in the cluster.

pid

bigint

Thread IDs currently running in the processes of all normal nodes in the cluster.

lwpid

integer

Lightweight thread IDs corresponding to the PIDs.

thread_name

text

Thread names corresponding to the PIDs.

creation_time

timestamp with time zone

Creation time of the threads corresponding to the PIDs.