SUMMARY_WORKLOAD_SQL_COUNT
Displays the distribution of SQL statements in workloads on each CN in the cluster, as described in Table 1.
| Name | Type | Description |
|---|---|---|
| node_name | name | Node name. |
| workload | name | Workload name. |
| select_count | bigint | Number of SELECT statements. |
| update_count | bigint | Number of UPDATE statements. |
| insert_count | bigint | Number of INSERT statements. |
| delete_count | bigint | Number of DELETE statements. |
| ddl_count | bigint | Number of DDL statements. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread. |
| dml_count | bigint | Number of DML statements. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread. |
| dcl_count | bigint | Number of DCL statements. The statistical result contains the SQL statements executed by users and the SQL statements executed by the database backend thread. |
| dbid | oid | ID of the database to which the statistics belong. |
| user_dml_count | bigint | Number of DML statements executed by users. |
| bg_dml_count | bigint | Number of DML statements executed by the database backend thread. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
