GLOBAL_WORKLOAD_SQL_ELAPSE_TIME
GLOBAL_WORKLOAD_SQL_ELAPSE_TIME displays statistics on the response time of SQL statements in all workload Cgroups in a cluster, including the maximum, minimum, average, and total response time of SELECT, UPDATE, INSERT, and DELETE statements. The unit is microsecond.
| 
        Column  | 
      
        Type  | 
      
        Description  | 
     
|---|---|---|
| 
        workload  | 
      
        Name  | 
      
        Workload Cgroup name  | 
     
| 
        total_select_elapse  | 
      
        Bigint  | 
      
        Total response time of SELECT statements  | 
     
| 
        max_select_elapse  | 
      
        Bigint  | 
      
        Maximum response time of SELECT statements  | 
     
| 
        min_select_elapse  | 
      
        Bigint  | 
      
        Minimum response time of SELECT statements  | 
     
| 
        avg_select_elapse  | 
      
        Bigint  | 
      
        Average response time of SELECT statements  | 
     
| 
        total_update_elapse  | 
      
        Bigint  | 
      
        Total response time of UPDATE statements  | 
     
| 
        max_update_elapse  | 
      
        Bigint  | 
      
        Maximum response time of UPDATE statements  | 
     
| 
        min_update_elapse  | 
      
        Bigint  | 
      
        Minimum response time of UPDATE statements  | 
     
| 
        avg_update_elapse  | 
      
        Bigint  | 
      
        Average response time of UPDATE statements  | 
     
| 
        total_insert_elapse  | 
      
        Bigint  | 
      
        Total response time of INSERT statements  | 
     
| 
        max_insert_elapse  | 
      
        Bigint  | 
      
        Maximum response time of INSERT statements  | 
     
| 
        min_insert_elapse  | 
      
        Bigint  | 
      
        Minimum response time of INSERT statements  | 
     
| 
        avg_insert_elapse  | 
      
        Bigint  | 
      
        Average response time of INSERT statements  | 
     
| 
        total_delete_elapse  | 
      
        Bigint  | 
      
        Total response time of DELETE statements  | 
     
| 
        max_delete_elapse  | 
      
        Bigint  | 
      
        Maximum response time of DELETE statements  | 
     
| 
        min_delete_elapse  | 
      
        Bigint  | 
      
        Minimum response time of DELETE statements  | 
     
| 
        avg_delete_elapse  | 
      
        Bigint  | 
      
        Average response time of DELETE statements  | 
     
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.