WORKLOAD_SQL_COUNT
Displays the distribution of SQL statements in workloads on the current node, as described in Table 1.
Name |
Type |
Description |
---|---|---|
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot