Note
This view is available starting with V2.2.77.
Purpose
This view displays the statistics of all previous workarea executions on all nodes of the current tenant, such as the number of times full in-memory processing occurred in the range of 1 M to 2 M, the number of one-pass executions, and so on.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| LOW_OPTIMAL_SIZE | bigint(20) | NO | The minimum memory size for optimal mode. |
| HIGH_OPTIMAL_SIZE | bigint(20) | NO | The maximum memory size for optimal mode. |
| OPTIMAL_EXECUTIONS | bigint(20) | NO | The number of executions in optimal mode within the minimum and maximum ranges. |
| ONEPASS_EXECUTIONS | bigint(20) | NO | The number of one-pass executions within the minimum and maximum ranges. |
| MULTIPASSES_EXECUTIONS | bigint(20) | NO | The number of multi-pass executions within the minimum and maximum ranges. |
| TOTAL_EXECUTIONS | bigint(20) | NO | The total number of executions. |
| CON_ID | bigint(20) | NO | The tenant ID. |
| SVR_IP | varchar(46) | NO | The server IP address. |
| SVR_PORT | bigint(20) | NO | The server port number. |
Sample query
Query the statistics of all previous workarea executions on all nodes of the current tenant and display the first 10 records.
obclient[oceanbase]> SELECT * FROM oceanbase.GV$SQL_WORKAREA_HISTOGRAM LIMIT 10;
The query result is as follows:
+------------------+-------------------+--------------------+--------------------+------------------------+------------------+--------+----------------+----------+
| LOW_OPTIMAL_SIZE | HIGH_OPTIMAL_SIZE | OPTIMAL_EXECUTIONS | ONEPASS_EXECUTIONS | MULTIPASSES_EXECUTIONS | TOTAL_EXECUTIONS | CON_ID | SVR_IP | SVR_PORT |
+------------------+-------------------+--------------------+--------------------+------------------------+------------------+--------+----------------+----------+
| 0 | 1048576 | 11965 | 0 | 0 | 11965 | 1002 | 172.xx.xxx.xxx | 2882 |
| 1048576 | 2097152 | 0 | 0 | 0 | 0 | 1002 | 172.xx.xxx.xxx | 2882 |
| 2097152 | 3145728 | 11 | 0 | 0 | 11 | 1002 | 172.xx.xxx.xxx | 2882 |
| 3145728 | 4194304 | 0 | 0 | 0 | 0 | 1002 | 172.xx.xxx.xxx | 2882 |
| 4194304 | 5242880 | 0 | 0 | 0 | 0 | 1002 | 172.xx.xxx.xxx | 2882 |
| 5242880 | 6291456 | 0 | 0 | 0 | 0 | 1002 | 172.xx.xxx.xxx | 2882 |
| 6291456 | 7340032 | 0 | 0 | 0 | 0 | 1002 | 172.xx.xxx.xxx | 2882 |
| 7340032 | 8388608 | 0 | 0 | 0 | 0 | 1002 | 172.xx.xxx.xxx | 2882 |
| 8388608 | 9437184 | 11 | 0 | 0 | 11 | 1002 | 172.xx.xxx.xxx | 2882 |
| 9437184 | 10485760 | 0 | 0 | 0 | 0 | 1002 | 172.xx.xxx.xxx | 2882 |
+------------------+-------------------+--------------------+--------------------+------------------------+------------------+--------+----------------+----------+
10 rows in set