Updated on 2025-07-22 GMT+08:00

OS_THREADS

Provides information about the status of all threads under the current node.

Table 1 OS_THREADS columns

Name

Type

Description

node_name

text

Database process name

pid

bigint

ID of the thread running under the current database process

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.