PG_GLOBAL_TEMP_ATTACHED_PIDS
This view displays information about sessions of resources occupied by global temporary tables on the current node. This view is supported only by clusters of 8.2.1.220 and later versions.
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        schemaname  | 
      
        Name  | 
      
        Schema name  | 
     
| 
        tablename  | 
      
        Name  | 
      
        Table name  | 
     
| 
        pid  | 
      
        Bigint  | 
      
        PID of a session  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.