SUMMARY_WORKLOAD_SQL_COUNT
Displays the distribution of SQL statements in workloads on each primary database node in the database, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.
| 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 | Database ID. |
| 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. |
