Updated on 2024-05-07 GMT+08:00

PGXC_OS_THREADS

PGXC_OS_THREADS displays thread status information under all normal nodes in the current cluster. Only system administrators and monitoring administrators can access this view.

Table 1 PGXC_OS_THREADS columns

Name

Type

Description

node_name

text

Names of the normal nodes in the cluster.

pid

bigint

IDs of running threads among the normal node processes in the current cluster.

lwpid

integer

Lightweight thread ID corresponding to the PID.

thread_name

text

Thread name corresponding to the PID.

creation_time

timestamp with time zone

Thread creation time corresponding to the PID.