PG_WLM_STATISTICS
PG_WLM_STATISTICS displays information about workload management after the task is complete or the exception has been handled. This view has been discarded in 8.1.2. You can use PGXC_WLM_SESSION_INFO to view load management records of completed jobs executed on all CNs.
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        statement  | 
      
        Text  | 
      
        Statement executed for exception handling  | 
     
| 
        block_time  | 
      
        Bigint  | 
      
        Block time before the statement is executed  | 
     
| 
        elapsed_time  | 
      
        Bigint  | 
      
        Elapsed time when the statement is executed  | 
     
| 
        total_cpu_time  | 
      
        Bigint  | 
      
        Total time used by the CPU on the DN when the statement is executed for exception handling  | 
     
| 
        qualification_time  | 
      
        Bigint  | 
      
        Period when the statement checks the inclination ratio  | 
     
| 
        cpu_skew_percent  | 
      
        Integer  | 
      
        CPU usage skew on the DN when the statement is executed for exception handling  | 
     
| 
        control_group  | 
      
        Text  | 
      
        Cgroup used when the statement is executed for exception handling  | 
     
| 
        status  | 
      
        Text  | 
      
        Statement status after it is executed for exception handling 
  | 
     
| 
        action  | 
      
        Text  | 
      
        Actions when statements are executed for exception handling 
  | 
     
| 
        queryid  | 
      
        Bigint  | 
      
        Internal query ID used for statement execution  | 
     
| 
        threadid  | 
      
        Bigint  | 
      
        ID of the backend thread  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.