Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-8.x)/ Schemas/ DBE_PERF Schema/ OS/ OS_THREADS
Updated on 2025-08-19 GMT+08:00
View PDF

OS_THREADS

Provides status information about all threads on the current node, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.

Table 1 OS_THREADS columns

Name

Type

Description

node_name

text

Name of the current node.

pid

bigint

ID of the thread running under the current node process.

lwpid

integer

Lightweight thread ID 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.

dbid

oid

ID of the database to which a thread belongs.
Parent topic: OS