PG_STAT_GET_MEM_MBYTES_RESERVED
PG_STAT_GET_MEM_MBYTES_RESERVED displays the current activity information of a thread stored in memory. You need to specify the thread ID (pid in PG_STAT_ACTIVITY) for query. If the thread ID is set to 0, the current thread ID is used. For example:
        1
         | 
       
        SELECT pg_stat_get_mem_mbytes_reserved(0);  | 
      
| 
        Column  | 
      
        Description  | 
     
|---|---|
| 
        ConnectInfo  | 
      
        Connection information.  | 
     
| 
        ParctlManager  | 
      
        Concurrency management information.  | 
     
| 
        GeneralParams  | 
      
        Basic parameter information.  | 
     
| 
        GeneralParams RPDATA  | 
      
        Basic resource pool information.  | 
     
| 
        ExceptionManager  | 
      
        Exception management information.  | 
     
| 
        CollectInfo  | 
      
        Collection information.  | 
     
| 
        GeneralInfo  | 
      
        Basic information.  | 
     
| 
        ParctlState  | 
      
        Concurrency status information.  | 
     
| 
        CPU INFO  | 
      
        CPU information.  | 
     
| 
        ControlGroup  | 
      
        Cgroup information.  | 
     
| 
        IOSTATE  | 
      
        I/O status information.  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.