PG_GTT_ATTACHED_PIDS
PG_GTT_ATTACHED_PIDS is used to check which sessions are using global temporary tables by calling the pg_gtt_attached_pid() function. Data is inherited from a centralized global temporary table. In distributed mode, GS_GTT_ATTACHED_PIDS or GS_GLOBAL_GTT_ATTACHED_PIDS is recommended.
Name |
Type |
Description |
---|---|---|
schemaname |
name |
Schema name. |
tablename |
name |
Name of a global temporary table. |
relid |
oid |
OID of a global temporary table. |
pids |
bigint[] |
Thread PID list. |
sessionids |
bigint[] |
Session ID list. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot