Updated on 2024-06-03 GMT+08:00

PGXC_OS_THREADS

PGXC_OS_THREADS provides information about the thread status of all normal nodes in the current cluster. Only the system administrator and monitor administrator can access this view.

Table 1 PGXC_OS_THREADS columns

Name

Type

Description

node_name

text

All normal node names in the cluster

pid

bigint

IDs of running threads among all 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