Help Center/ Data Warehouse Service / Standard Data Warehouse (9.1.0.x)/ DWS System Catalogs and Views/ System Views/ PG_OS_THREADS

Updated on 2025-10-09 GMT+08:00

View PDF

PG_OS_THREADS

PG_OS_THREADS displays the status information about all the threads under the current node.

**Table 1** PG_OS_THREADS columns
Column	Type	Description
node_name	Text	Name of the node
pid	Bigint	Thread number running under the current node process
lwpid	Integer	Lightweight thread IDs corresponding to the PIDs
thread_name	Text	Thread names corresponding to the PIDs
creation_time	Timestamp with time zone	Creation time of the threads corresponding to the PIDs

Parent Topic: System Views

Previous topic: PG_NODE_ENV

Next topic: PG_POOLER_STATUS

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel