Help Center/ Data Warehouse Service / Developer Guide/ Developer Guide (9.1.1.x)/ DWS System Catalogs and Views/ System Views/ PGXC_GLOBAL_TEMP_ATTACHED_PIDS

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

View PDF

PGXC_GLOBAL_TEMP_ATTACHED_PIDS

This view displays information about sessions of resources occupied by global temporary tables on CNs. This view is supported only by clusters of 8.2.1.220 and later versions.

**Table 1** PG_GLOBAL_TEMP_ATTACHED_PIDS columns
Column	Type	Description
nodename	name	Node name
schemaname	name	Schema name
tablename	name	Table name
pid	bigint	PID of a session

Parent Topic: System Views

Previous topic: PGXC_GET_TABLESPACE_OBS_FILE

Next topic: PGXC_GTM_SNAPSHOT_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.See the reply and handling status in My Cloud VOC.

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

For any further questions, feel free to contact us through the chatbot.