Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Views/ PGXC_OS_THREADS
Updated on 2025-08-19 GMT+08:00
View PDF

PGXC_OS_THREADS

PGXC_OS_THREADS displays thread status information under all normal nodes in the current cluster. Only users with the SYSADMIN and MONADMIN permissions can query 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

ID of the lightweight thread corresponding to pid.

thread_name

text

Name of the thread corresponding to pid.

creation_time

timestamp with time zone

Creation time of the thread corresponding to pid.
Parent topic: System Views